You have been asked to design a database for the ABC company. Here is the information that you have gathered:

$$ The company has multiple divisions. Each division is identified by a division ID$.$

$$ A division operates many departments. Each department is identified by a department ID and has name and location.

$$ Each department is operated by one division.

$$ A department employs many employees. Each employee is identified by an employee ID$,$ and their lastname, firstname, and phone number are kept in the system.

$$ Each employee is employed by one department. Some employees, known as $$rovers$,$ are not assigned to any department.

$$ An employee may be assigned multiple projects. Each project is identified by a project ID and has a name and start date.

$$ A project may have many employees assigned to it$.$ Some projects may not have any employee assigned to them.

$$ One of the employees manages each department, and each department is managed by only one employee.