Normalization Flow Chart

Normalization step by steps:-

1.       Check, If there are any comma separated value. If yes then create a row for single data.

2.       Check for primary key, It must exist.

3.       Check weather Primary key -> Composite key. If no, then table is already in 2^nd Normalization Form. Else draw dependency diagram and follow the process to convert table in 2NF. It removes partial dependency.

4.       Check if there exists any Transitive dependency. If no, Table already in 3NF.