A superkey is one or more table columns whose combined values uniquely identify a row. It may include columns that are not needed for uniqueness. section 4.3 section 6.2
Place superkeys in the larger key hierarchy:
- A candidate key is a minimal superkey: removing any column would stop it from uniquely identifying a row. section 4.3 section 6.2
- A primary key is the candidate key selected for the table. section 4.3 section 6.2
Surrogate keys in transaction tables
The purchase table uses purchase_id as an autoincrementing surrogate primary key, while payment_method uses payment_id. Each identifier uniquely identifies a row; adding an unnecessary column would still produce a superkey, but not a minimal candidate key. section 4.3
Superkeys also support normalization work: identifying keys helps check whether columns depend on a key and whether a table satisfies normal-form requirements. section 6.2

