Regional Labs is a company that conducts research and development work on a contract bas...

Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-33 shows data that Regional Labs collects about projects and the employees assigned to them.

This data is stored in a relation (table) named PROJECT:

PROJECT (ProjectID, EmployeeName, EmployeeSalary)

A. Assuming that all functional dependencies are apparent in this data, which of the following are true?

1. ProjectID → EmployeeName

2. ProjectID → EmployeeSalary

3. (ProjectID, EmployeeName) → EmployeeSalary

4. EmployeeName → EmployeeSalary

5. EmployeeSalary → ProjectID

6. EmployeeSalary → (ProjectID, EmployeeName)

B. What is the primary key of PROJECT?

C. Are all the nonkey attributes (if any) dependent on the primary key?

D. In what normal form is PROJECT?

E. Describe two modification anomalies that affect PROJECT.

F. Is ProjectID a determinant? If so, based on which functional dependencies in part A?

G. Is EmployeeName a determinant? If so, based on which functional dependencies in part A?

H. Is (ProjectID, EmployeeName) a determinant? If so, based on which functional dependencies in part A?

I. Is EmployeeSalary a determinant? If so, based on which functional dependencies in part A?

J. Does this relation contain a transitive dependency? If so, what is it?

K. Redesign the relation to eliminate modification anomalies.