Explain the ACID properties of a database transaction.

Atomicity: all statements in a transaction execute completely or none do. If any step fails, all previous steps in the transaction are rolled back. No partial transactions. Consistency: the database moves from one valid state to another valid state. All constraints (PK, FK, CHECK) are satisfied after commit. Isolation: concurrent transactions operate as if they were executed serially. Isolation le