ACID test

• Atomicity
• transaction as smallest unit of processing
• transactions complete entirely or not at all
• consequences of partial completion in flight example
• Consistency
• complete execution preserves database constrained state/integrity
• e.g. Should a transaction create an entity with a foreign key then the reference entity must exist (see 4 constraints)