Chapter 10, Problem 4RQ

Explanation of Solution

List of transaction properties:

The transaction process has the list of properties in each individual transaction. The transaction must display these properties for consistent state. They are:

• Atomicity
• Consistency
• Isolation
• Durability

These above four transactions are referred as ACID test. The other additional transaction property is “Serializability”.

Explanation of transaction properties:

Atomicity:

• This property requires all part of the transaction (SQL commands) must be completed. Otherwise, the transaction is aborted. \
• For example: if the transaction T2 has three SQL commands, all three commands must successfully complete in the transaction. If not it is considered as inconsistent state. Hence, the atomicity property ensures the consistent state of the transaction.

Consistency:

• The property indicates the permanence of database consistency. If the transaction is completed, the database will move one consistent state to another consistent state.

Isolation:

• This property is used for database transaction and the data item is accessed but one transaction cannot be accessed by any other transactions until the first one ends...