Answer the following questions.

(a) For a user operation, how transaction will be processed? Draw a state diagram and discuss the typical states that a transaction goes through during execution. (b) What is the transaction commit points, and why are they important? What is the system log used for? What are the typical kinds of records in a system log for instructions? (c) Consider the below mention Schedule & items ( X=20,Y=30 as initial values), Answer the following, (i). Derive the possible values of data items X and Y, for both T1 T2 and T2 T1. (ii). Verify, whether above mention schedule follows 2phase locking protocol? If yes explain the order and data item values for the sequence, otherwise justify your