Skip to content
Quantoros

What is normalization?

SQLLevel: IntermediateDatabase Design

What is normalization?

Hints
  • Which functional dependencies hold between table attributes?
  • Check insert, update and delete anomalies; what changes when the table is decomposed?

Answer

Normalization is the process of organizing a database to reduce data redundancy and improve data integrity by dividing large tables into smaller, related ones.

The normal forms (1NF, 2NF, 3NF, BCNF) each progressively reduce certain types of redundancy. In practice, most people target 3NF for OLTP systems.

The tradeoff: normalization requires more JOINs at query time, which can hurt read performance. OLAP and reporting systems often denormalize intentionally for speed.

Source and licence: SQL Interview Questions — Arda Kocadoru · MIT

Related questions