Question

In database transaction concurrency, the lost update anomaly is said to occur if a transaction Tj reads a data item, then another transaction Tk writes the data item (possibly based on a previous read), after which Tj writes the data item. The update performed by Tk has been lost, since the update done by Tj ignored the value written by Tk
a. Give an example of a sequence showing the lost update anomaly
b. Give an example sequence to show that the lost update anomaly is possible with the read committed isolation level.
c. Explain why the lost update anomaly is not possible with the repeatable read isolation level.

Answer 1

Answer:

The answer is attached in the document file.

Explanation:

The explanation is given in the attached file.

                             

Download docx