Construct a Database of Acme Company:

The Acme Company wants to construct a database to keep track of the company's employees, departments, and projects as well as the employee's dependents. The requirements collected to date to be modeled are: 1. 2. 3. 5. 6. 4. Every employee is assigned to a department but may work on several projects, which are not necessarily under the control of the same department. 7. The company is organized into departments. Each department has a name, a number, and an employee who manages the department. 8. A department controls a number of projects, each of which has a name, a number, and a start date but not all departments have projects assigned to them. We store each employee's name, social security number, address, salary, sex, and birth date. We keep track of the number of hours per week that each employee works on each project. For most projects, a team of employees is assigned to work on the project while some employees are never assigned to a project. We also keep track of the direct supervisor of each employee. We want to keep track of the dependents of each employee, if they have any, for insurance purposes. We keep each dependent's name, sex, birth date, and relationship to the employee.