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
E)day

Question

Quizplus · Accepted Answer

The airport code is the unique identifier for each airport and is unlikely to change, making it a strong candidate for a primary key. The other fields (address, city, state, day) are not likely to be unique and could change over time.

You Are Creating a Database to Store Temperature and Wind