Give an example of a schedule of two transactions that preserves database consistency (the database satisfies its integrity constraints), but nevertheless yields a final database that does not reflect the effect of both transactions.
What will be an ideal response?
Two interleaved deposit transactions of |S10:
r1(bal) r2(bal) w1(bal = bal + |S10) w2(bal = bal + |S10)
The integrity constraint is bal ? 0, and the update made by transaction T1 is lost.
Computer Science & Information Technology
You might also like to view...
The default Normal style includes the Times New Roman font, 10 pt font size, and 0 pt spacing after a paragraph
Indicate whether the statement is true or false
Computer Science & Information Technology
Chart layouts focus on location of components, whereas styles focus more on the color coordination and effects of the components
Indicate whether the statement is true or false.
Computer Science & Information Technology