Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- State a functional dependency in the standard X → Y notation.
- Identify a functional dependency directly from a table's real data.
- Explain the three axioms that let new functional dependencies be derived from known ones.
- Explain why functional dependencies are the formal basis for the normal forms covered next.
The next module covers normal forms, which are defined entirely in terms of functional dependencies. This page gives that one underlying idea precisely, before using it as the measuring stick for good and bad designs.