a transaction that transfers money from one bank account to another could lead to an inconsistent database
Fantastic news! We've Found the answer you've been seeking!
Question:
a transaction that transfers money from one bank account to another could lead to an inconsistent database state if it fails after withdrawing the money from first account, but before putting the money into the second account.
- What could be the consequences of such a failure?
- By embedding the steps into a transaction, in that scenario the
transaction can abort. What steps must it take then to fix the problem?
- Come up with another scenario in which a set of updates to a database
could result in an inconsistent state. Explain the inconsistencies that could result.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: