Given the relation EMPLOYEE(ID#, LastName, ProjectID, ProjectName) and ProjectID can determine ProjectName, but not last name, the relation violates:
A) 1st normal form.
B) Mills normal form.
C) 2nd normal form.
D) 3rd normal form.
E) Olsen normal form.

Question

Quizplus · Accepted Answer

The relation violates 3rd normal form because ProjectName is functionally dependent on ProjectID, but there is a transitive dependency between ProjectID and LastName. Therefore, the relation should be decomposed into two tables: EMPLOYEE(ID#, LastName, ProjectID) and PROJECT(ProjectID, ProjectName).

Given the Relation EMPLOYEE(ID#, LastName, ProjectID, ProjectName) and ProjectID Can