Computer Science: An Overview: Global Edition (12th Edition)

Published by Pearson Higher Education
ISBN 10: 1292061162
ISBN 13: 978-1-29206-116-0

Chapter 9 - Database Systems - Chapter Review Problems - Page 454: 46

Answer

See the explanation

Work Step by Step

To achieve a final balance of 100USD: 1. Transaction 1: Withdraw 100USD (resulting in a balance of 100USD). 2. Transaction 2: Add 100USD (no effect as the balance is already 100USD). To achieve a final balance of 300USD: 1. Transaction 2: Add 100USD (resulting in a balance of 300USD). 2. Transaction 1: Withdraw 100USD (no effect as the balance is still 300USD). So we have: T1 reads → T2 reads → T2 writes → T1 writes $\$300$ (T1 overwrites T2) T1 reads → T2 reads → T1 writes → T2 writes $\$100$ (T2 overwrites T1)
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.