Normalization

 First Normal Form:
===============
Tables are said to be in first normal form when:
- The table has a primary key.
- No single attribute (column) has multiple values.
- The non-key attributes (columns) depend on the primary key.

Second Normal Form:
=================
Tables are said to be in second normal form when:
- The tables meet the criteria for first normal form.
- If the primary key is a composite of attributes (contains multiple
columns), the non key attributes (columns) must depend on the whole
key.


Third Normal Form:
================
Tables are said to be in third normal form when:
- The tables meet the criteria for second normal form.
- Each non-key attribute in a row does not depend on the entry in another key column.

Fourth Normal Form:
================
Tables are said to be in fourth normal form when:
- The table meets the criteria for third normal form.
- Situations where non-key attributes depend on the key column
exclusive of other non-key columns are eliminated.


Fifth Normal Form:
===============
Tables are said to be in fifth normal form when:
- The table meets the criteria for fourth normal form.
- The table consists of a key attribute and a non-key attribute only.

SHARE

About df