|
Normal Form |
What Does it Mean |
|
First Normal Form (1NF) |
There Can Be Only One |
|
Value in a Field |
|
|
Place for Data to go |
|
|
Second Normal Form (2NF) |
Data is Unique to Primary Key |
|
Third Normal Form (3NF) |
Data is Unique only to Primary Key |
One,Two,Three
Sam
Sam
Sam
The 2nd and 3rd Normal form usually require the use of a compound key (A key made up of more than 1 field)