A university registar's office maintains data about the following entities :Course : including number, titles, credits, syllabus, prerequisitesCourse offerings including course number, year, semester, section, number, instructors, timing and classroom.Students: including student_id, name and program.Instructors : including identification number, name, department and title.
Construct an E-R diagram for the registar's office.Document all assumptions that you make about the mapping constraints.
|Subject||Database Management System|
|NU Year||Set: 2.(c) Marks: 3+5=8 Year: 2010|