Question $2$:

$[8$ marks$]$

Consider the following two concurrent transactions in the scenario to update shared variable winner name and the

corresponding private variable prizemoney. Suppose these two transactions are executed concurrently, and TI

starts first. Each step of transaction is viewed

as below:

a$)$ State the final result values of the shared

variable winner$\_$name and its effect on private

variable winner.prizemoney in case of isolation

level setting:

i$)$ Level$-0$ Isolation $($Read uncommitted$)$

i$)$ Level$-1$ Isolation $($Read committed$)$

b$)$ Which type of concurrency problem may be

found here?