CSE Roadmap

Common tier · about 3 hours · 5 parts

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.