Exercise 5: Consider the schedule shown below. a) Is the schedule conflict serializable? Yes No If yes, give the equivalent serial schedule b) If Tz aborts after write(Y), which other transactions will be rolled back? c) If Ti aborts after write(X), which other transactions will be rolled back? d) Draw the wait-for graph that results from this schedule if all locks are only exclusive-locks (lock- x), no locks are released and the execution process runs to the point of lock-x(Y) in T1. T. T, TE Wait-for Graph e) Add lock-s(), lock-x() and unlock() instructions to the schedule below according to strict 2PL. Tz T T4 read(X) write(X) read() read(Y) write(Y) write(X) read() write(Y) Exercise 5: Consider the schedule shown below. a) Is the schedule conflict serializable? Yes No If yes, give the equivalent serial schedule b) If Tz aborts after write(Y), which other transactions will be rolled back? c) If Ti aborts after write(X), which other transactions will be rolled back? d) Draw the wait-for graph that results from this schedule if all locks are only exclusive-locks (lock- x), no locks are released and the execution process runs to the point of lock-x(Y) in T1. T. T, TE Wait-for Graph e) Add lock-s(), lock-x() and unlock() instructions to the schedule below according to strict 2PL. Tz T T4 read(X) write(X) read() read(Y) write(Y) write(X) read() write(Y)