You are creating a database to store temperature and wind data from national airport locations. 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

Question

Quizplus · Accepted Answer

The airport code is a unique identifier for each specific airport and therefore is the most suitable choice for a primary key in the Airport table. The address or city fields can have duplicates and may change over time, and the state field is not specific enough to identify a particular airport.

You Are Creating a Database to Store Temperature and Wind