Chapter 6, Problem 6.21RQ

Explanation of Solution

ACID:

The acronym stands for “Atomicity”, “Consistency”, “Isolation” and “Durability”. It is an important concept of DBMS which allows sharing of data safely. It is applied to all the transactions.

Atomicity:

Atomicity describes the first ACID property. This phase in atomicity specifies “all or nothing” that is when an update occurs either all the transactions are committed to the database or none of the transactions get updated in the database.

• Only a fragment of the update cannot be done into the database.
• It is retained in the presence of deadlocks
• It is maintained in the presence of database software failure or the application software failure.
• It is carried over when there is a disk failure or CPU failure.

Consistency:

This ensures that the transaction proceeds to the valid state of data or if any failure occurs it returns all the data to its state at the point where the transaction begins...