1. (2/2/2/4 in order.) The PROJECT database. Following is a relation:

PROJECT (Proj_Num, Proj_Name, Emp_Num, Emp_Name, Job_Class, Charge_Hour, Hours_Billed)

Assumption:

• One project has several employees. One employee works in several projects.
• One employee is assigned to a Job_Class. One Job_Class has several employees.
• Charge_Hour means hourly rate for a particular Job_Class
• Hours_Billed means the work hours of an employee for a particular project

1. List all functional dependencies.
2. Among the list of (1), list partial dependencies (if none, type N/A).
3. Among the list of (1), list transitive dependencies (if none, type N/A).
4. Describe the new database design in 3NF. Refine your design so that it presents attribute atomicity and proper naming conventions.

TABLE (PrimaryKey, ForeignKey (FK), Attribute1, Attribute2, Attribute3)