The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is
A)Flight number
B)Flight number + place of departure
C)Flight number+ date
D)Flight number + destination

Question

Quizplus · Accepted Answer

The primary key must uniquely identify each record. A flight number alone does not suffice because the same flight number can be used on different dates. Combining the flight number with the date ensures each record is unique, as it specifies a particular flight on a specific day.

The Airline Reservation System, the Enables Are Date, Flight Number