$(2)(1$ mark$)$

Consider the database transactions listed below.Assume that the initial values of the persistent data items x$,$y and z are the following: x$=1,$y$=2$ and z$=2.$

Show a sample concurrent execution of the transactions T$1,$ and T$2$ that is view serializable and it is NOT conflict serializable.

Prove that the execution is view serializable and it is NOT conflict serializable.

To prove that the execution is view serializable and it is NOT conflict serializable use a technique of two$-$dimensional diagrams presented to you during the lecture classes, for example, see a presentation $10$ Introduction to Transaction Processing $(1),$ slide $9.$

Deliverables

A file solution$1.$pdf with:

$(1)$ a visualization of a sample concurrent execution of the transactions $T1,T2,$ and T $3$ that is NOT conflict serializable, and a proof that sample concurrent execution of the transactions T$1,$ T$2,$ and T$3$ is NOT conflict serializable.

$(2)$ a visualization of a sample concurrent execution of the transactions T$1$ and T$2$ that is view serializable and that is NOT conflict serializable, and a proof that sample concurrent execution of the transactions T$1$ and T$2$ is view serializable and it is NOT conflict serializable.