LearnViz CompSci
Home / Learn / Databases / Normalization

Intermediate Topic 21 of 51 Databases

Normalization

Organizing tables to reduce redundancy.

How it works

Normalization organizes tables to reduce redundancy and avoid update, insert and delete anomalies by ensuring each fact is stored once, in the place where it belongs. It works by decomposing tables according to functional dependencies, so that non-key attributes depend only on the key. Designs go through successive normal forms, from first to third, and Boyce-Codd normal form is commonly targeted for transactional systems.

Step-by-step walkthrough

  1. A single wide table repeats customer data on every order.
  2. Duplicates cause update, insert and delete anomalies.
  3. Split the data into tables with one fact each.
  4. Orders and products get their own tables.
  5. Foreign keys link them, so each fact is stored once.

Where it is used

Operational databases for orders, accounts and inventory use normalization so that changing a customer's address requires updating one row, keeping data consistent.

Common pitfall

Over-normalizing creates many tiny tables and expensive joins. Under-normalizing leads to duplicated data that diverges. Normalize by understanding the real dependencies, not by memorizing rules. For analytics or read-heavy workloads, selective denormalization may be appropriate. Check design with typical queries and update scenarios.

Where it fits in the course

Normalization is topic 21 of 51 in Databases, rated Intermediate. It follows Indexes. The next topic is Normal Forms.

Practice and explore

How to study this topic

  1. Read the explanation above and restate the definition in your own words.
  2. Open the interactive lesson and answer its mini quiz.
  3. Read the common pitfall, then write a short example that avoids it.
  4. Check your understanding in the Databases quiz, and revisit the topic if you miss a question.

Frequently asked questions

What is Normalization?
Organizing tables to reduce redundancy. It belongs to Databases and is an intermediate-level topic.
Where do people use Normalization?
Operational databases for orders, accounts and inventory use normalization so that changing a customer's address requires updating one row, keeping data consistent.
What is the most common mistake with Normalization?
Over-normalizing creates many tiny tables and expensive joins.
What should I learn before this topic?
Start with Indexes, the topic just before it in Databases.
How can I practice it?
Answer the mini quiz in the interactive lesson, then take the Databases quiz.
Is Normalization hard to learn?
It is an Intermediate topic. Be comfortable with the Beginner topics in this area first, then read the common pitfall carefully, since it is where most mistakes happen.
How long does it take to learn Normalization?
Most learners can read the explanation and finish the interactive lesson in under an hour. Fluency comes from applying the idea, so plan a few short practice sessions with the quiz.
Which topics are related to Normalization?
Indexes, Normal Forms, Views are closely connected. The full list is in the related topics section of this page.
What should I study after Normalization?
Continue with Normal Forms, the next topic in Databases.

Related topics