Case 9-2
Emily is functioning with her customer, Anna, on the design of a new database. She describes to Anna that key fields are utilized to access, coordinate, and preserve the data records.
-Emily tells Anna that a primary key is a field or combination of fields that individually and minimally recognizes a specific entity. She mentions that there may be an option of fields or field combinations to use as the primary key. Which of the following is the term used for a feasible primary key?
A) Candidate key
B) Ancillary key
C) Foreign key
D) Multifaceted key

Question

Case 9-2
​Emily is functioning with her customer, Anna, on the design of a new database. She describes to Anna that key fields are utilized to access, coordinate, and preserve the data records.
-Emily tells Anna that a primary key is a field or combination of fields that individually and minimally recognizes a specific entity. She mentions that there may be an option of fields or field combinations to use as the primary key. Which of the following is the term used for a feasible primary key?
A) Candidate key
B) Ancillary key
C) Foreign key
D) Multifaceted key

Quizplus · Accepted Answer

A feasible primary key is referred to as a candidate key. This is a group of one or more fields that could potentially serve as the primary key, and it must have the characteristics of uniqueness and minimalism. Ancillary keys and foreign keys are not related to primary keys, and there is no such thing as a multifaceted key.

Case 9-2 ​Emily Is Functioning with Her Customer, Anna, on the Design

Case 9-2 Emily Is Functioning with Her Customer, Anna, on the Design