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.

$($ER diagrams should not be like tables. Entities should be shown as rectangles and Relationships should be shown as diamonds. If there is a key constraint, it should be shown with an arrow from entity to relationship. If there is total participation, it should be shown with a thick arrow. Weak entities should also be indicated in the diagram.$)$