1. A university registrar’s office maintains data about the following entities: (a) courses, including
number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number,
year, semester, section number, instructor(s), timings, and classroom; (c) students, including
student-id, name, and program; and (d) instructors, including identification number, name,
department, and title. Further, the enrolment of students in courses and grades awarded to students
in each course they are enrolled for must be appropriately modelled. Construct an E-R diagram
for the registrar’s office. Document all assumptions that you make about the mapping constraints.