CS-16 Object Oriented Systems June-2002
Qus5 In an Airline Reservation System, there could be a ternary relationship between flight, seat and passenger. What are the candidate keys of the relationship under the following conditions?
{i) A given seat on a given flight is assigned to Zero or One passenger. A passenger may travel “on many flights but must have exactly one seat on a travelled flight and must be sitting in it during the flight.
(ii) A given seat on a given flight is assigned to Zero or One passenger, as in the previous. A passenger may travel on many flights and may have several seats on a travelled flight, as long as the extra seats are paid for.
(Some passengers may be willing to pay for the extra elbow room, or may have some delicate electronic equipment that they want to strap into a seat)
