The bank does not allow a balance above 10000.
- Add a CHECK constraint to
accountsthat keeps every balance at or below 10000. - Try to add 20000 to Ava's balance. Which ACID property stopped it?
Give the property name for each event:
- A transfer's second UPDATE fails. The first UPDATE is undone too.
- Liam's report runs while Ava's transfer is not yet committed. The report shows the old balances.
- The server crashes right after a COMMIT. After the restart, the change is there.