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 - Section 9.4 - Maintaining Database Integrity - Questions & Exercises - Page 437: 3

Answer

A balance of $\$100$ would result if the transactions were executed one at a time. A balance of $\$200$ would result if the first transaction were executed after the second transaction retrieved the original balance and before that second transaction stored its new balance. A balance of $\$300$ would result if the second transaction were executed after the first retrieved the original balance and before the first transaction stored its new balance.

Work Step by Step

A balance of $\$100$ would result if the transactions were executed one at a time. A balance of $\$200$ would result if the first transaction were executed after the second transaction retrieved the original balance and before that second transaction stored its new balance. A balance of $\$300$ would result if the second transaction were executed after the first retrieved the original balance and before the first transaction stored its new balance.
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.