Normalization Rules

1st NF : No Repeating groups : Remove any repeating groups along with the primary key to a new table.


2nd NF: No Partial Dependencies :If columns are dependent on only a part of the primary key, extract them along with the part of the primary key to a new table.


3rd NF: No Transitive Dependencies:  If non-key columns are dependent on another non-key column, extract them to a new table and identify a primary key.


4th NF Separates independent multi-valued facts to separate tables.


5th NF Breaks out data redundancy not covered by previous NFs.


ELIMINATE DATA NOT DEPENDENT ON KEY. All non key cols should be dependent on the Primary key. (Then the table is said to have functional dependence.)The aim of normalization Is to arrive at a set of tables that are fully functionally dependent.