BISI 4150- Data Base Systems Entity-Relationship Modeling In-Class Exercise 2, V. 3 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. The company is organized into departments. Each department has a name, a number, and an employee who manages the department 2. 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. 3. We store each employee's name, social security number, address, salary, sex, and birth 4. Every employee is assigned to a department but may work on several projects, which are 5. We keep track of the number of hours per week that each employee works on each 6. For most projects, a team of employees is assigned to work on the project while some 7. We also keep track of the direct supervisor of each employee date. not necessarily under the control of the same department. project. employees are never assigned to a project. 8. 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