ACID Properties in DBMS
Atomicity: Atomicity means all it's operations are execute it entirely or do not execute it at all.
There cannot be partial execution.
Consistency: The database must remain in a consistent state after execution of any transaction.Once the transaction is executed, it should move from one consistent state to another.
Isolation: In a database system where more than one transactions are being simultaneously executed. Transaction should be executed in isolation from other transactions (no Locks). During concurrent transaction should not affect the existence of any other transaction.
Durability: After successful completion of a transaction, the changes in the database should persist. Even in the case of system failures.