Entity-Relationship Diagram

The University of COLAMBIA has several departments. Each department is managed by a chair, and at least one professor. Professors must be assigned to one, but possibly more departments. At least one professor teaches each course, but a professor may be on sabbatical and not teach any course. Each course may be taught more than once by different professors. We know of the department name, the professor name, the professor employee id, the course names, the course schedule, the term/year that the course is taught, the departments the professor is assigned to, the department that offers the course.

1) Identify Entities

2) Find Relationships

3) Rough ERD Draw the entities and relationships that you have discovered.

4) Fill in Cardinality

Determine the cardinality of the relationships.

5) Fill in Modularity

Determine the modularity of the relationships.