. A university registrar’s office stores information about the following entities: • Students, including student-id, name, and gpa • Instructors, including Id-number, name, department, and title • Courses, including course-number, title, credits, syllabus • Class-Sections, including section number, year, semester, time schedule, and classroom. Each class-section belongs to only one course, and can be taught by only one instructor. Every course can have
Question3. A university registrar’s office stores information about the
following entities:
• Students, including student-id, name, and gpa
• Instructors, including Id-number, name, department, and title
• Courses, including course-number, title, credits, syllabus
• Class-Sections, including section number, year, semester, time schedule, and classroom.
Each class-section belongs to only one course, and can be taught by only one instructor.
Every course can have zero or several sections, and zero or several courses as prerequisites.
Moreover, the information about enrollment of students in class sections and grades that
they received in each class must be stored.
Draw an Entity Relationship diagram for the registrar’s office. Indicate all assumptions
that you make about the constraints.
Step by step
Solved in 2 steps with 1 images
