Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure below shows that regional Labs collects about projects and the...

Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure below shows 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 non-key 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 function dependencies is 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 trasitive dependency? if so, what is it?

K. Redesign the relation to eliminate modification anomalies.