Class Exercise $-$ Example $3$

$-$A department employs many employees, but each employee is employed by one department.

$-$Adivision operates many departments, but each department is operated by one division.

$-$An employee may be assigned many projects, and a project may have many employees assigned to it$.$

$-$One of the employees manages each department, and each department

is managed by only one employee.

$-$One of the employees runs each division, and each division is run by only one employee.

$*$Draw an ER diagram that captures the preceding information

$*$Convert ERD to relational schema