1. Provided is an example scenario and the resulting ERD. Using this example and the notation key provided, draw an ERD for each of the scenarios (a-d):

KEY:

NOTE: Use either the notation in RED or BLUE. You do not need to use both.

NOTE: Each diagram is unrelated to the previous. Figures can be drawn using shapes in WORD, using Draw.io, or using any other figure drawing tools (pen and paper are fine, as long as they are scanned into the final submission).

1. A department offers several courses. A course belongs to a department.

2. A course can have many sections, but in some semesters, no section will be open (Once a year course). A section must belong to a course. Course has the attributes NAME, ID, DEPARTEMNT. ID is the Primary Key.

3. Each department has many professors assigned to it. One of those professors chairs the department. Only one of the professors can chair the department to (s)he is assigned, and no professor is required to accept the chair position. Therefore, DEPARTMENT is optional to PROFESSOR in the chairs relationship. A professor is assigned to a department. A department must have a chair.