LearnViz CompSci
Home / Learn / Databases / Normal Forms

Intermediate Topic 22 of 51 Databases

Normal Forms

Progressive rules 1NF through BCNF for table design.

How it works

Normal forms are progressively stricter rules for table design. First normal form requires atomic values and no repeating groups. Second normal form also requires that non-key attributes depend on the whole of a composite key, not part of it. Third normal form removes transitive dependencies, so non-key attributes depend only on the key. Boyce-Codd normal form requires every determinant to be a candidate key; higher forms deal with multivalued and join dependencies.

Step-by-step walkthrough

  1. 1NF: each cell holds one atomic value.
  2. 2NF: every non-key column depends on the whole key.
  3. 3NF: non-key columns depend only on the key, not on each other.
  4. BCNF: every determinant is a candidate key.
  5. Each step removes more redundancy.

Where it is used

Database designers use them as a checklist to find redundancy and anomalies, and to explain why a schema should be split.

Common pitfall

Memorizing definitions without applying them to concrete dependencies leads to mistakes. Not every schema must reach the highest form; practical designs stop at third normal form or BCNF and denormalize deliberately for performance. Identify candidate keys first, then list dependencies, and test with sample data to see anomalies.

Where it fits in the course

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

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 Normal Forms?
Progressive rules 1NF through BCNF for table design. It belongs to Databases and is an intermediate-level topic.
Where do people use Normal Forms?
Database designers use them as a checklist to find redundancy and anomalies, and to explain why a schema should be split.
What is the most common mistake with Normal Forms?
Memorizing definitions without applying them to concrete dependencies leads to mistakes.
What should I learn before this topic?
Start with Normalization, 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 Normal Forms 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 Normal Forms?
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 Normal Forms?
Normalization, Denormalization, Indexes are closely connected. The full list is in the related topics section of this page.
What should I study after Normal Forms?
Continue with Denormalization, the next topic in Databases.

Related topics