1. Consider a database with objects X, Y, Z and assume that there are three transactions T1, T2, and T3.

- Transaction T1 reads objects X and Y and then writes objects X and Y.

i.e., T1: R(X), R(Y), W(X), W(Y)

Transaction T2 reads and writes objects X, then reads and writes objects Z.

i.e., T2: R(X), W(X), R(Z), W(Z)

- Transaction T3 reads objects Y and Z, writes objects Z, reads objects Y once more, and writes objects Y.

i.e., T3: R(Y), R(Z), W(Z), R(Y), W(Y)

Question :

a.Give an example schedule with actions of transactions T1 and T2 on objects X, Y, and Z that result in a write-read conflict. Explain your reasoning.

b. Give an example schedule with actions of transactions T1 and T3 on objects X, Y, and Z that result in a read-write conflict. Explain your reasoning.

c. Give an example schedule with actions of transactions T2 and T3 on objects X, Y, and Z that result in a write-write conflict. Explain your reasoning.

d.For each of the three schedules, show how Strict 2PL disallows the schedule using the notation and explanation for each action