Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 22nd International Conference Dexa 2011 Toulouse France August/September 2011 Proceedings Part 1 Lncs 6860

Authors: Abdelkader Hameurlain ,Stephen W. Liddle ,Klaus-Dieter Schewe ,Xiaofang Zhou

2011th Edition

3642230873, 978-3642230875

More Books

Students also viewed these Databases questions

Question

4. Describe the factors that influence self-disclosure

Answered: 1 week ago

Question

1. Explain key aspects of interpersonal relationships

Answered: 1 week ago