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

question 17

Multiple Choice

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.
-Anna asks if it is manageable to fetch records using a field or combination of fields that is not unique. Emily tells her that it is possible using one type of key. Identify the type of key used here.

• A) Primary key
• B) Secondary key
• C) Foreign key
• D) Super key

---

Definitions:

(R)-2-Butyl Tosylate

A chiral organic compound where a butyl group is attached to a para-toluene sulfonate, used as an intermediate in organic synthesis.

Sodium Iodide

A salt with the formula NaI, used in organic synthesis, and as a dietary supplement.

TsCl

P-toluenesulfonyl chloride, an organic compound used as a reagent in organic synthesis to introduce tosyl groups.

(R)-Pentan-2-Ol

An optically active form of pentanol where the hydroxyl group is attached to the second carbon atom in the pentane chain.