State ?ve (possible) integrity constraints for the database in an airline reservation system.

What will be an ideal response?

1. The ?ight for which a person makes a reservation must be on the schedule.
2. The number of reservations on each ?ight must not exceed the number of seats on the plane.
3. A passenger cannot order two meals
4. The number of meals ordered must equal the number of passengers who ordered meals
5. The same seat on the plane must not be reserved for two passengers.

Computer Science & Information Technology

You might also like to view...

Optical drives use a(n) ________ to store and read data on a CD or DVD

Fill in the blank(s) with correct word

Computer Science & Information Technology

What restriction does the array-based implementation of a stack place on the push operation?

What will be an ideal response?

Computer Science & Information Technology