Data modelling - Standard
ACID
(Atomicity, Consistency, Isolation, Durability)
Rules that help database transactions remain reliable even when things go wrong
What's it for?
Helps keep stored information correct when several changes happen together or something fails halfway through.
For example…
A bank transfer updates both account balances completely; if one update fails, the whole transaction is undone rather than leaving the accounts inconsistent
Two customers try to buy the last item at once; ACID rules help the database avoid selling the same stock twice