Question
We consider the following context. A reservation transaction in an airline reservation system makes a reservation on a flight, reserves a seat on the plane,
We consider the following context. A reservation transaction in an airline reservation system makes a reservation on a flight, reserves a seat on the plane, issues a ticket, and debits the appropriate credit card account. Assume that one of the integrity constraints of the reservation database is that the number of reservations on each flight does not exceed the number of seats on the plane. (Of course, many airlines purposely over-book and so do not use this integrity constraint.) State whether each of the following statements could be an integrity constraint of a checking account database for a banking application. question(1):The value stored in the balance column of an account is greater than or equal to $0.(True or false ) question(2):The value stored in the balance column of an account is greater than it was last week at this time .(True or false ) question(3):The Social Security number column of an account is defined and contains a nine digit number.(True or false ) question(4):What is not an integrity constraint in the case of an air line reservation system?(may be more than one currect answers for this question) (a) The Captain should come to the airport before the flight attendants. (b) The number of reservations on each flight must not exceed the number of seats on the plane. (c) A passenger cannot order two meals. (d) The flight for which a person makes a reservation must be on the schedule. (e) The same seat on the plane must not be reserved for two passengers. ACID question(5):A reservation is made the system crashes ; the system forgets the reservation . This is violation of _____________________ (a) Isolation (b) Consistency (c) Durability (d) Atomicity question(6):Flight is over booked (More reservations than there are seats on the airplane).This is a violation of_________________________ (a) Durability (b) Isolation (c) Consistency (d) Atomicity question(7):A passenger makes a reservation and reserves a seat . The transaction records the reservarion but the systen crashes before it records the seat reservation. This is a violation of ____________________________ (a) Durability (b) Consistency (c) Isolation (d) Atomicity question(8):The same seat is given to two people because of a particular interleaving of the researvarion transactions.This is a violation of ______________________________ (a) Consistency (b) Atomicity (c) Durability (d) Isolation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started