Again consider the entity-relationship diagram shown in Figure. Add the following to the diagram and list any assumptions you had to make. A faculty member usually teaches many course sections, but some semesters a faculty member may not teach any. Each course section must have at least one faculty member teaching it, but sometimes teams teach course sections. Furthermore, to make sure that all course sections are similar, one faculty member is assigned as course coordinator to oversee the course, and each faculty member can be coordinator of manycourses.

Course Course number Title Credit hours Course Section Course Enrollment Student Section number Start time Room number Grade Student ID Name Major