Normalization

noun

say it: “nor-muh-lih-ZAY-shun” /ˌnɔːrməlɪˈzeɪʃən/

Organizing tables so each fact is stored once, to avoid repeated data that can fall out of step.

What is Normalization in a relational database?

Normalization — Organizing relations to reduce redundancy and prevent modification anomalies.

In a sentence

  • “After normalization, the customer's address lives in one row, not on every order.”

Level: Journeyman · More Database terms at this level

Updated