Consider the Schedule Below Here R ft and W

Assignment Task

Consider the schedule below. Here, R(*) and W(*) stand for 'Read' and 'Write', respectively. T1, T2, T3, T4 and T5 represent five transactions and to represent a time slot.

Questions

1) Assume a checkpoint is made between ts and to, what should be done to the five transactions when the crash happens between t12 and t13? 

2) Is the transaction schedule conflict serializable? Give the full precedence graph to justify your answer.

3) Construct a schedule (which is different from the above) of these five transactions which cause a deadlock when using two-phase locking protocol. You should clearly indicate all the locks and the corresponding unlocks in your schedule. If no such schedule exists, explain why.

This IT and Computer Science has been solved by our PHD Experts at My Uni Paper.