What is a surrogate key?

Approach: Distinguish between natural and generated keys.

A unique identifier for a row that is generated by the system (like an auto-incrementing integer) and has no inherent business meaning, unlike a natural key (like an SSN).

Follow-up: Why are they preferred in data warehouses?

Key concepts: primary key, auto-increment.