please quickly thanks ! QUESTION 7Consider three transactions T1, T2, T3 and two data iterns X, YT1: R (X); R(Y); W (Y)T2: R (X); W (X)T3: R(Y); R (X); W (X)Given the following schedule of interleaved operations from T1, T2, and T3:S: R1 (X); R3 (Y); R3 (X); R1 (Y); R2 (X); W1 (Y); A1; W2 (X); C2; W3 (X); C3"A1" means transaction T1 aborts, "C2" (resp. "C3") means transaction 12 (resp. T3) commitsWhat anomalies occur in this schedule? Explain your answer.(1)(2)protocol.Two-Phase Locking (2PL) is widely used for concurrency control in relational database systems. Briefly describe the strict 2PL(3)For each transaction T1, T2, T3, insert all the lock and unlock operations to make the transaction satisfy the strict 2PL protocol.(Note: You can add a write lock directly if the transaction needs to both read and write a data item)Construct a wait-for-graph (WFG) for this schedule based on the strict 2PL protocol. Is there any deadlock in the schedule? Justify(4)your answer.Note: Here is an example about how to describe a wait-for-graph: T1-> T2 means there is an edge from transaction T1 to transaction T2 in the wait-for-graph.(5)Victim selection is used to decide which transaction should be aborted when a deadlock is detected. List at least three factors thatshould be considered in victim selection.Timeout is a mechanism for handling deadlocks. Explain the advantages and disadvantages of short timeout compared to long(6)timeoutAssume that transaction T1 is aborted to address the deadlock issue. Modify schedule S based on strict 2PL to prevent the anomaly(7)Justify your answer.ALTIEN 10 Mac)pro

“Since you have posted a question with multiple sub parts, we will provide the solution only to the…

Consider three transactions T1, T2, T3 and two data iterns X, Y T1: R (X); R(Y); W (Y) T2: R (X); W (X) T3: R(Y); R (X); W (X) Given the following schedule of interleaved operations from T1, T2, and T3 S: R1 (X); R3 (Y); R3 (X); R1 (Y); R2 (X); W1 (Y); Al; W2 (X); C2; W3 (X); C3 "A1" means transaction T1 aborts; "C2" (resp. "C3") means transaction 12 (resp. T3) commits (1) What anomalies occur in this schedule? Explain your answer (2) protocol. (3) For each transaction T1, T2, T3, insert all the lock and unlock operations to make the transaction satisfy the strict 2PL protocol. (Note: You can add a write lock directly if the transaction needs to both read and write a data item) Two-Phase Locking (2PL) is widely used for concurrency control in relational database systems. Briefly describe the strict 2PL