A ________ key is a unique identifier that should be created and used when designing a database for each type of entity,in order to store and retrieve data accurately.
A) foreign
B) surrogate
C) primary
D) super
E) candidate

Question

Quizplus · Accepted Answer

A primary key is a unique identifier that should be created and used when designing a database for each type of entity in order to store and retrieve data accurately. It uniquely identifies each record in the table and is used as a reference key for other tables that may contain references to the primary key. Foreign keys are used to create relationships between tables and reference primary keys in other tables. Surrogate keys are artificial keys assigned by the system to provide a unique identifier when a natural key may not be available. Super keys are sets of attributes that can be used to identify a record in a table. Candidate keys are a subset of the super key that can uniquely identify a record in a table.

A ________ Key Is a Unique Identifier That Should Be