Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Check whether a table satisfies 1NF, 2NF, 3NF or BCNF.
- Name the specific anomaly each normal form rules out.
- Identify which normal form a given table violates, and why.
- Explain why BCNF is stricter than 3NF, with a concrete case where they differ.
Functional dependencies, from the previous module, are the measuring stick. This page is where that stick gets used: a sequence of increasingly strict rules, each one ruling out a specific, nameable kind of redundancy and the update problems it causes.