Match the descriptions to these key design terms: Candidate key, Superkey, Surrogate key, Natural key.

Key designConcept relationships

Choose a match for every item. Use each answer once.

Removing any attribute from a candidate key would make it lose its uniqueness guarantee.

A superkey provides uniqueness but need not be minimal.

Surrogate keys separate technical row identification from changing business data.

A natural key uses domain data and must remain suitable for uniqueness and change management.