Create an entity-relationship diagram (ERD) for the faculty-course teaching system based on the following information.
A course can have many course sections offered in each semester, but for some semesters, a course might not be offered.
A faculty member could teach many course sections and in some semesters a faculty member might not teach any. However, at least one faculty member is assigned to teach a course section.
In order to make sure that all course sections are similar, one faculty member is appointed as a course director to manage the course, and each course director member can manage many courses.
Identify reasonable entities for the system.
Identify relationships (one-to-one, one-to-many, or many-to-many) using the crow's foot notation described in Chapter 2 of Kendall & Kendall 9th textbook among these entities.
Write sentences explaining the left-to-right and right-to-left relationships for each relationship.