Advanced Databases / SQL

Transaction S:

read(a);

a=a+10;

write(a);

read(b);

b=b*5;

write(b);

Transaction T:

read(a);

a=a*2;

write(a);

1) Write a concurrent schedule for transactions S and T that illustrates the lost update problem.

2) Apply the standard two-phase locking protocol to the schedule you devised in step previous step. Will the protocol allow the execution of that schedule? Does deadlock occur?