[solved]-Transaction Locking Protocols Transaction 1 Wants R1x W10x R1 Y W1y W1x Transaction 2 Want Q39088863

Transaction (Locking Protocols) Transaction 1 wants to: R1X) W10X) R1(Y) W1Y) W1X) Transaction 2 wants to: W2(Y) R2(Z) W2(Z) Assume these two transactions try to submit requests in this order: R1(X) W1(X) R1(Y) W1(Y) w2(Y) R2(Z) W2(Z) W1(x) Please show the real schedule when 1. the 2-phase locking is used 2. the strick 2-phase locking is used Show transcribed image text Transaction (Locking Protocols) Transaction 1 wants to: R1X) W10X) R1(Y) W1Y) W1X) Transaction 2 wants to: W2(Y) R2(Z) W2(Z) Assume these two transactions try to submit requests in this order: R1(X) W1(X) R1(Y) W1(Y) w2(Y) R2(Z) W2(Z) W1(x) Please show the real schedule when 1. the 2-phase locking is used 2. the strick 2-phase locking is used

Expert Answer

---

Answer to Transaction (Locking Protocols) Transaction 1 wants to: R1X) W10X) R1(Y) W1Y) W1X) Transaction 2 wants to: W2(Y) R2(Z) W… . . .