Consider the grade book database described in problem 6 of the Exercises in Chapter 1 of this lab manual.
a. Create a XML representation of the data described there (you should invent your own data instances).
b. Write a XML Schema specification for the XML document constructed in part a.
c. Write expressions in XQuery to answer all queries of problem 3 of the Exercises in Chapter 2 of this lab manual.
Problem 6
Consider a grade book database in which instructors within an academic department maintain scores/points obtained by individual students in their classes. The data requirements are summarized as follows:
• Students are identified by a unique student id, their first and last names, and an email address.
• The instructor teaches certain courses each term. The courses are uniquely identified by a course number, a section number, and the term in which they are taught. The instructor also assigns grade cutoffs (example 90, 80, 70, and 60) for letter grades A, B, C, D, and F for each course he or she teaches. • Students are enrolled in courses taught by the instructor.
• Each course being taught by the instructor has a number of grading components (such as mid-term, final exam, project, etc.). Each grading component has a maximum number of points (such as 100 or 50) and a weight (such as 20% or 10%). The weights of all the grading components of a course usually add up to 100.
• Finally, the instructor records the points earned by each student in each of the grading components in each of the courses. For example, student with id=1234 earns 84 points for the grading component mid-term for the course CSc 2310 section 2 in the fall 2005 term. The mid-term grading component may have been defined to have a maximum of 100 points and a weight of 20% of the course grade.
Design an enhanced Entity-Relationship diagram for the grade book database and enter the design using a data-modeling tool such as ERWin.
Problem 3
Consider a movie database in which data is recorded about the movie industry. The data requirements are summarized as follows:
• Movies are identified by their title and year of release. They have a length in minutes. They also have a studio that produces the movie and are classified under one or more genres (such as horror, action, drama etc). Movies are directed by one or more directors and have one or more actors acting in them. The movie also has a plot outline. Each movie also has zero or more quotable quotes that are spoken by a particular actor acting in the movie.
• Actors are identified by their names and date of birth and act in one or more movies. Each actor has a role in the movie.
• Directors are also identified by their names and date of birth and direct one or more movies. It is possible for a director to act in a movie (not necessarily in a movie they direct).
• Studios are identified by their names and have an address. They produce one or more movies.
Design an Entity-Relationship diagram for the movie order database and enter the design using a data-modeling tool such as ERWin.