ACID properties of transaction

Source: sqlserverhelpdotcom

• Atomicity : Either all operations are executed or none of the operations are executed.
• Consistency : All the data must be in a consistent state. There should be no transaction that has adverse effect on data residing in database.
• Isolation : If more than 1 transactions are executing simulataneously then every transaction should be executed as if no other transaction is running.
• Durability: The database system should be able to sustain the updates. Even if the system fails or restarts, the updates should be applied.