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