A surrogate key is an artificial column that is added to a relation to be its primary key.

Question

Quizplus · Accepted Answer

A surrogate key is indeed an artificial column that is added to a relation to serve as its primary key. This is typically done when there is no natural key or when the natural key is complex, and a simpler primary key is needed. Surrogate keys are often generated automatically by the system and have no meaning outside of the database.

A Surrogate Key Is an Artificial Column That Is Added