TASK

A company has a database that tracks the companys departments, employees, and their dependents. For the company, we maintain company name as Primary key (Pkey) and its address. Employees and their dependents are Persons. For Person, we maintain SSN as the Pkey, Name as a three-component attribute with Fname, MI, and Lname, DOB, and address. Employees have properties of EID as Candidate Key (CKey), hireDate, and gender. For dependents, we maintain Age as a Derived attribute from DOB. For Departments, we maintain DID as the Pkey, Dname as a Ckey, and Budget.

Here is what we know about the association of these entities with each other.

- A company has one or more departments. Each department is only within one company.

- Employees can work for one and only one department. A department must have one or more employees. The date that an employee starts working for a department is tracked.

- Each department can have only one employee as a manager. An employee can be the manager of one or more departments. The date an employee starts managing a department must be tracked.

- Employees are either hourly or salaried. For hourly employees, we maintain the number of hours worked and the hourly rate. For salaried employees we maintain salary.

- An employee can be married to another employee. Some other employees are married but to someone outside the company. The rest of the employees are not married. We want to know the marital status of each employee and the basic information of their spouse.

-We want to track the dependent of our employees. A dependent is a Person whose parent(s) are our employee(s). A dependent must have at least one but can have two employees as his/her parents. An employee can have one or more dependents. A dependent can also be an employee. - An employee may work on many projects and a project may have many participants. - A department may own many projects and a project may be owned by multiple department. - A project has a Project ID (PID). Each department has a budget for a project. We want to track the amount of the budget and the starting date.

Question: Create Entity Relationship diagram for Conceptual model, logical model, and physical model.