Q$1)$ Draw the ER Diagram for the scenario below. $(60$ Points$)$

The company database keeps track of company's employee, department and projects. We

store Employee's name, ssn$,$ address, salary, gender, date of birth and age. An employee is

assigned to one department, but may work on several projects which are not necessarily

controlled by the same department. A particular employee manages the department. Each

department has a unique name, unique number and several locations. The department

controls number of projects each of which has a unique name, unique number and a single

location. We want to keep track of the dependents of each employee for insurance purpose.

We keep each dependent's first name, sex, birth date and relationship to employee.