Explain database normalization up to 3NF.

Answer preview

Normalization is organizing columns and tables so that every fact is stored exactly once, which removes insert, update, and delete anomalies. Each normal form kills a specific kind of redundancy: 1NF removes repeating groups, 2NF removes partial dependencies on part of a composit…