Normalization Forms

Table is in 1st normal form if:

• Each field contains only single value
• Values stored in a column must be of same type
• There should never be duplicate records
• The order of the data does not matter

Table is in 2nd normal form if:

• Table is in 1st normal form
• Each table should contain information only about a single entity (no partial dependencies)

Table is in 3rd normal form if:

• Table is in 2nd normal form
• There is no other non key attribute that needs to be changed when changing another non key attribute (no transitive dependencies)