Draw an ER diagram for the following Company database (make sure you show all the cardinalities and participation ratios). State any assumptions made: We need to store the SSN, name, birthdate, address, salary and gender of each employee. The company will need to know the employee's first, middle and last names. for each employee. 1. The Ss We need to store the name, number and location of each department. A department may be located in more than one location. The department number and name will be unique for each department. 2. 3. We need to store information about projects controlled by departments. Each project will have a number, name and location. Name and number will be unique for each project. An employee may have a dependent, but a dependent must belong to an employee.A dependent cannot exist if the employee does not exist. For each dependent we will store the name, sex, birth date and relationship. 4. Additional information: All employees must work for a department. One employee can only work for one department. Each department must have an employee working for it and can have more than one employee working for it. An employee may manage a department. A department must be managed by an employee. The Start date of the manager is dependent on the Employee as well as the department A department may control many projects. A project must be controlled by one department. An employee must work on a project and can work on more than one project at a time. A project must have at least one employee working for it and may have many employees working for it. The number of hours that an employee works depends on the project