Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Name the five kinds of key and say what makes each one a key.
- Pick a correct primary key for a table given its columns.
- Explain why a foreign key must reference a candidate key, not just any column.
- Build a composite key for a table that needs more than one column to stay unique.
A table without a key cannot reliably identify one row from another. Every later module assumes rows can be told apart this way. This page names each kind of key precisely, so later modules can simply say "primary key" or "foreign key" without re-explaining them.