This exercise moves from Atomicity (all-or-nothing) to Consistency (the "C" in ACID)
Scenario 1:- The Direct Attack: Manual Negatives
In our first scenario, we attempted a direct UPDATE to set Alice's balance to -100.
Scenario 2:- The Transactional Tug-of-War
In our second scenario, we see a multi-step transfer: deducting 1200 from Alice and adding it to Bob within a BEGIN...COMMIT block.


Top comments (0)