You are creating a database to store temperature and wind data from various airports.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?
A)Address
B)City
C)Airport code
D)State
E)Day

Question

Quizplus · Accepted Answer

The airport code is a unique identifier for each airport, and therefore is the best choice for a primary key in the Airport table. Using other fields such as address, city, state, or day may result in duplicate entries or inconsistencies in the data.

You Are Creating a Database to Store Temperature and Wind