CSE Roadmap

Core tier · about 2 hours · 5 parts

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.