acid principles sql code example

Example: acid property db

A - Atomicity      transactions either take place or they dont. ('all or nothing' property)
C - Consistency	   Db must be consistent before and after a transaction.
I - Isolation      multiple transaction don't interfere with each other.
D - Durability     changes survive eventual failures of the system.