X hits on this document

Word document

For the exam you should be able to - page 7 / 11

38 views

0 shares

0 downloads

0 comments

7 / 11

5. Print the film id and title of film projects by "Universal" that have received the highest rating (i.e. the highest score between 1 and 10). (filmId, title, rating)

6. Construct an E-R diagram for a university database. Be sure to specify all primary keys, mapping cardinalities (constraints), etc. Also, be sure to list any assumptions you are making.The database should contain at least the following information:

Students, who have names, addresses, phone numbers, student numbers, GPA, etc., and who have taken classes and received grades in them.

Departments, that have names, ids, locations, etc.

Courses within departments (ignore cross listings for the moment), that have numbers, titles, credits, etc. These courses can be offered in multiple sections that are taught in particular semesters that have locations, times and days, etc and are taught by professors who work in departments.

2. What changes (if any) would you make to your answer to question 1 if cross listing of courses was allowed (i.e., if the same course could be listed with separate names by several departments). Be sure to justify/explain your answer

Document info
Document views38
Page views38
Page last viewedWed Dec 07 12:56:43 UTC 2016
Pages11
Paragraphs265
Words2948

Comments