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.