Data modelling - Record
Transaction
A set of data changes treated as one complete unit
What's it for?
Keeps several related changes together so they either all succeed or none of them are kept.
For example…
Moving £50 between bank accounts is one transaction: the debit and credit either both succeed or neither is kept
Creating an order may be one database transaction that writes the order and its line items together so a partial order is not left behind