Reference no: EM131246881
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.
|
Defect tracking system
: The Defect Tracking System (DTS) is a web based application that can be accessed throughout the organisation. There are features like email notifications, user maintenance, user access control, report generators etc in this system.
|
|
Write and execute xquery expressions
: For every project located in "Stafford", retrieve the project number, the controlling department number, and the department's manager's last name, address, and birth date.
|
|
Brief description of your business research topic
: A brief description of the research methodologies and techniques to be used for the research project. What research methodology will you use - What will be the steps in your project?
|
|
Unpaid balance of the loan
: An individual is borrowing 100000 at 8% interest compounded annually the loan is to be paid in equal annual payments over 30 years. if the lender is still charging 8% per year, compounded annually, on the unpaid balance of the loan what is the balanc..
|
|
Design an enhanced entity-relationship diagram
: Write expressions in XQuery to answer all queries of problem 3 of the Exercises in Chapter 2 of this lab manual.
|
|
Establish a marketing plan to grow the market
: MKT5000 Assignment - The strategic marketing plan. This assignment leads on from assignment 1. Essentially you are required to establish a marketing plan to grow the market and sales for the organisation you have chosen in the target market you hav..
|
|
Examine the primary reasons why medical tourism
: From the e-Activity, examine the primary reasons why medical tourism is becoming popular among Americans, and determine whether or not the health care industry should encourage this consumer behavior. Give at least two (2) specific examples associ..
|
|
Write a xml schema specification for the xml document
: Produce a listing of URLs of articles for each author. Output should consist of author names followed by list of URLS, sorted by author names.
|
|
What are you willing to go to the wall for
: This unit has stressed the importance of staying grounded and also clearly defining your true north. Keeping with that focus, put together a solid mantra/motto which captures your personal belief about your leadership goal. What are you willing to..
|