CSE Roadmap

Core tier · about 4 hours · 5 parts

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.