Normalization: 1NF, 2NF, 3NF

What is Normalization?

Normalization is the process of organizing data to reduce redundancy.

1NF - First Normal Form

Eliminate repeating groups. Each field contains only atomic values.

2NF - Second Normal Form

Be in 1NF and remove partial dependency.

3NF - Third Normal Form

Be in 2NF and remove transitive dependency.

Example:

Split one table into multiple based on repeating columns or derived data.