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.