A determinant that determines all the other columns in a relation is a ________.
A)record
B)field
C)foreign key
D)candidate key
E)surrogate key

Question

Quizplus · Accepted Answer

A determinant that determines all the other columns in a relation is called a candidate key, which is a unique identifier for each record in a table. It is different from a foreign key, which is a column in a table that links to the primary key of another table. A field is a column in a table that contains a specific type of data, and a surrogate key is a substitute for a natural key that is often generated by the system.

A Determinant That Determines All the Other Columns in a Relation