Question 1: A university registrar’s office maintains data regarding the given entities:
a) Courses, comprising number, title, credits, syllabus and prerequisites;
b) Course offerings, comprising course number, year, semester, section number, instructor(s), timings and classroom;
c) Students, comprising the student-id, name and program;
d) Instructors, comprising identification number, name, department and title.
In addition, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be suitably modeled. Construct an E-R diagram for registrar’s office. Document all suppositions that you make regarding the mapping constraints
Question 2: Design an E-R diagram for keeping the track of exploits of your favorite sports team. You must store the matches played, the scores in each match, players in each match, and individual player statistics for each match. Summary statistics must be modeled as derived attributes.
Question 3: Describe the significance of ER Model for the Database design?
Question 4: Explain the fundamental constructs of the ER Model.