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.
D
Explanation: D) A relation is said to be in third normal form when there are no transitive dependencies. ProjectID determining ProjectName is a transitive dependency.
CL
Business
You might also like to view...
Demographic segmentation is based on measurable characteristics of populations, which includes all the following examples except __________.
Fill in the blank(s) with the appropriate word(s).
Business
The due date for the second installment of real property taxes is:
a. December 10 b. February 1 c. March 1 d. April 10
Business