Project ID

Project Name

Project Manager

Project Manager Location

Employee ID

Employee Name

Employee Location

Title

Hourly Rate

Billable Hours

a. 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

b. 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.

c. Draw the entity relationship diagram.

d. Based on your ERD, draw the physical data model including primary keys and foreign keys.