A college contains many departments. Each department can offer any number of courses.

a) A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department. An instructor can work only in one department. For each department there is a Head. An instructor can be head of only one department. Each instructor can take any number of courses. A course can be taken by only one instructor. A student can enroll for any number of courses. Each course can have any number of students.
Draw an ER diagram for this schema that takes into account all the assertions given.

Leave a Reply