18
5
Concepts of Database Management, 4th Edition, Pratt & Adamski
Third Normal Form (3NF)
•3NF Table
•In 2NF
•+
•the only determinants contained are candidate keys
•
if by knowing the value of X, you also know the value of Y, then
Y is functionally dependent on X.
Also we say that X is a determinant of Y.
== The primary key will be a determinant. Any candidate key will also be a determinant.