Part $1$

Draw an ERD for MyCollege. You can do it using paper and pencil, or using a tool to draw ERDs. If you use a tool, please mention the name and url.

Note: DO NOT USE A TOOL THAT TRANSFORMS DIRECTLY YOUR ERD INTO RELATIONS. If you do you will not understand how to draw an ERD.

The ERD will capture the following information:

$$MyCollege has several schools.

$$Each school has a unique Dean. Deans are not shared between schools.

$$Each school has several departments. A department belongs to one school only.

$$Departments offer majors.

$$Departments offer courses. A course can be offered by several departments.

$$Several sections $($classes$)$ of the same course can be offered.

$$Each department has a unique chair and several professors. A chair is a professor.

$$A professor teaches up to $3$ classes. A professor could teach $0$ class due to release time for research or administration.

$$Students enroll in up to $5($different$)$ classes a semester. The minimum number of classes a student can take is $1.$

$$A student can have $1$ or $2$ majors.

Part $2$

Transform your ERD into a set of relations. Be sure to show the primary keys and foreign keys.