Case Study: describe using ERD diagram how the university can manage Building, Classroom, Course, students, and Instructors, each of which is a table that is drawn indicating Primary Key, and Foreign key. Then explains how the university can add a new course without conflicting with others courses’ time and classroom.

Question

Notice: the relation between Course and Student is m-to-m because a Student may have more than one Course has more than one student.
Draw the ED-D using crows-feet notation. Show the entities and relationships between entities (Building, Classroom, Course, student, Instructor). Indicate the PK primary key, and FK foreign key in each table)
 

Answer 1

Cannot draw on these posts.