Assume that there are 3 data items x, y and z in the database. Consider the following three transactions T1, T2 and T3 with their operations coming in the given order (from left to right): Provide the schedules that can be generated by (a) 2 PL [0.3 points] (b) Resource ordering (with order:x y z) [0.3 points] (c) Wait-Die Rule [0.3 points] (d) Wound-Wait Rule [0.3 points] Note that (b), (c) and (d) should be used in combination with 2PL. For (c) and (d), you are not required to show the restart of aborted transactions. Also, assume that we do not kill a transaction that has not actually started; just let it wait until the next earliest possible time to start, keeping its original starting/arriving time. Whenever possible, requests should be accommodated based on first-come-first-service and locks should be released as soon as possible. You may stop when a deadlock occurs.
