need help with b and c

(a) (3 marks) Discuss the atomicity, durability, isolation, and consistency preservation properties of a database transaction (b) (4 marks) Consider a database with objects X and Y, and the following two transactions Tl and T2 involving those objects T1 begin transaction T2 read (X) read (Y) begin transaction read (X); read (Y); write (X) read (Y) write(X) rite (Y) (i) Give an example of a schedule involving transactions Tl and T2 that results in (ii) Add lock and unlock instructions to the ransaction T1 and T2 so that they (iii) Explain how the use of two-phase locking protocol can resolve the conflict you a read-write conflict (unrepeatable read) observe the two-phase locking protocol (2PL) identified in part (2) above (c) (3 marks) (i) Discuss whether any concurrent execution of these two transactions Tl and T2 shown in part (b) can result in a deadlock. (ii) Verify whether the lock/unlock instructions that you introduced in part b(ii) above lead to a deadlock. If there is a deadlock, explain how it could have beern prevented