Details

Draw an E$-$R diagram to model course registration.

$**$HINT $-$ This was frequently used an example by the lecture and the text.

$-$Include entities for student, instructor, course, and classroom.

$-$Each student is described by a unique ID number and by their name

$-$Each course is described by a unique course number, a course name, and a meeting time

$-$Each classroom is described by a unique room number, a building, and its capacity

$-$A student has to take a minimum of $1$ course and a maximum of many courses

$-$A course is taken by a minimum of zero students and a maximum of many students

$-$When a course is taught, it is taught by a minimum of one instructor but can be taught by many instructors

$-$Instructors have to teach a minimum of $1$ course but can teach many courses

$-$A given course will be taught in a minimum of zero classrooms and in a maximum of $2$ classrooms.

Classrooms are used by a minimum of zero courses but by a maximum of many courses