Esc
↑↓ navigate   Enter open   Esc close

Databases & SQL

Normalisation

/ˌnɔːməlaɪˈzeɪʃən/

Definition

Organising database tables to reduce data redundancy and improve integrity by separating related data into distinct tables.

Example in context

"First normal form requires atomic values — no comma-separated lists in a single column."

Related terms

  • Foreign key — A column that references the primary key of another table, enforcing referential integrity between related data.
  • Denormalisation — Intentionally introducing redundancy into a database for read performance — trading consistency complexity for query speed.

Practice this term

Master Normalisation in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.

Practice in exercises → Browse all words

Frequently Asked Questions

What does "Normalisation" mean?

Organising database tables to reduce data redundancy and improve integrity by separating related data into distinct tables.

How do you pronounce "Normalisation"?

"Normalisation" is pronounced /ˌnɔːməlaɪˈzeɪʃən/.

Can you use "Normalisation" in a sentence?

"First normal form requires atomic values — no comma-separated lists in a single column."