A startup company is using an excel spreadsheet to keep track of the billable hours that each employee spends on a project. As you can see, they are not data modelers. They would like to convert the spreadsheet into a database that they can use as a back end for a time keeping application. The column names of the spreadsheet are shown below:

Project ID

Project Name

Project Manager

Project Manager Location

Employee ID

Employee Name

Employee Location

Title

Hourly Rate

Billable Hours

1. Draw a dependency diagram for the schema and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups. Here are the field descriptions:
   1. Project ID the identifier for the project
   2. Project Name the name of the project
   3. Project Manager the name of the project manager for a project, projects can have more than one project manager
   4. Project Manager Location location of the project manager
   5. Employee ID the identification number for an employee
   6. Employee Name the name of an employee
   7. Employee Location the location of an employee
   8. Title the position title for the employee
   1. Hourly Rate the rate that is charged to the project sponsor based on the position of the employee
   10. Hours worked the number of billable hours that an employee has charged to a project

2. Remove all partial and transitive dependencies and draw a new set of relations in third normal form. Put your thinking cap on because there are some obvious data management pitfalls associated with the above relation.

3. Draw the entity relationship diagram.

4. Based on your ERD, draw the physical data model including tables, attributes, data types, primary keys, and foreign keys.

Please post screenshots!!