Consistency — ACID
Definition: In ACID, consistency means a transaction moves the database from one valid state to another valid state while respecting defined rules and constraints.
For example, a database constraint saying an account balance cannot be negative must remain satisfied after a successful transaction.
Examples:
- A foreign key cannot reference a nonexistent user.
- An order cannot reference an invalid product.
- A bank transaction cannot violate a database constraint.