Assignment #1: Database Analysis and Design with E-R Diagram Due: 11:59pm, Sunday, Feb. 9. Please submit in D2L using the associated link. To develop a database for a certain company, the following facts have been obtained after the requirement collection and analysis phase: 1. The company is organized into departments. Each department has a department name, a unique department ID number, and a particular employee who manages the department. We keep track of the starting date when the employee began managing the department. A department may have multiple locations in different cities. 2. A department controls a number of projects, each of which has a project name, a unique project ID number, and a single location. 3. Each employee has the following information: name (first name, last name, and middle name), SSN, date of birth, gender, address, and salary. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works for each project. We also keep track of the direct supervisor of each employee. 4. We want to keep track of the dependents of each employee for insurance purpose. Each dependent has the following information: first name, gender, date of birth, and relationship to the employee. Based on the above description, draw an E-R diagram by either Microsoft Visio or Dia. Note: For a multi-valued attribute, we use {} in MS Visio (e.g., (skills}), and double circles in Dia