Give an example of a schedule of consistent transactions that is not serializable but maintains the correctness of any integrity constraint that might conceivably be associated with the database.
What will be an ideal response?
The schedule contains a lost update. For example,
r1(x) r2(x) w2(x) w1(x)
T2’s update is lost, and the result of the schedule is the same as if only T1 had
executed and T2 had never executed. Since T1 is assumed to be consistent, the
schedule maintains all possible integrity constraints. However, the final database might
be incorrect. since T2’s update has been lost
Computer Science & Information Technology
You might also like to view...
You CANNOT insert charts from a spreadsheet into a Word document
Indicate whether the statement is true or false
Computer Science & Information Technology
The ____ print style prints a page for each contact.
A. Card B. Memo C. Phone Directory D. Small Booklet
Computer Science & Information Technology