ACID property

ACID property is a database transaction property to provide guarantee for expected behavior of transaction in any failure case.

1. Atomicity: This property guarantees that a transaction composed of multiple operations is treated as a single unit. Either all operations of the transaction are executed or none of them is.
2. Consistency: This property guarantee that a transaction can only transaction the database from one valid state to another valid state adhere to all defined rules, such as integrity constraints, triggers, and relationships between data, ensuring that no violations occur.
3. Isolation: This property ensures that transaction are performed independent of other concurrent transaction.
4. Durability: This property guarantees that once a transition has been committed, it will remain committed even in the case of failure.