Question & Answer: Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts……

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts.

1)The university keeps track of each student’s name, a unique student number, a unique Social Security number, address (split into street address, city, state, and zip code), phone number, birth date, sex, level (Freshman, etc.), major department, and degree program (BS, MS, PhD).

2)Each department is described by a unique name, a unique department code, office phone number, and the college it belongs to.

3)Each course has course name, a unique course number, description, number of credit hours, and offering department.

4)Each section has an instructor, semester, year, course, and section number. The section number distinguishes sections of the same course that are taught during the same semester/year, its values being 1, 2, 3, …, up to the number of sections taught during each semester.

5)A grade report has a student, section, a letter grade (F, D, C, B, A), and a numeric grade (0,…, 4).

Design an ER Schema for this application, and draw its ER Diagram using the notations used in class. Specify key attributes of each Entity Type, and structural constraints on each Relation Type.