Answer to Question #270172 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Check whether the given schedules are conflict serializable or not

 S1 : R2(B)W2(A)R1(A)R3(A)W1(B)W2(B)W3(B)

S2:R3(Y)W3(Z)R1(X)W1(X)W3(Y)W3(Z)R2(Z)R1(Y)W1(Y)R2(Y)W2(Y)

Answer 1

The schedule is conflict serializable as the schedule can be transformed into a serial schedule after swapping of non-conflicting operations