need help with part c

(10 marks QUESTION B2 (a) (3 marks) Discuss the atomicity, durability, isolation, and consistency preservation (b) (4 marks) Consider a database with objects X and Y, and the following two transactions properties of a database transaction Tl and T2 involving those objects T2 begin transaction read (X); read (Y) XX+10; T1 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 been prevented