Question:
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 enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.
Construct an ER diagram for the registrar’s office. Document all assumption that you make about the mapping constraints.
Answer:
To create an Entity-Relationship (ER) diagram for the university registrar’s office, we need to represent the main entities: students, courses, course offerings, and instructors. Additionally, we’ll need to capture the relationships between these entities, as well as any attributes associated with each entity.
