DataBase - Concurrency Control protocols

Consider a multi-granularity locking system in concurrent execution of transactions environment, with lock modes S, X, IS, IX, and SIX possible at database-level, file-level, page-level and record-level as shown in the following figure. Provide the sequence of lock requests required to perform the following transactions and write necessary complete Lock operations in their correct order. 1. T1 wants to read record R5 in P2000. [1 Marks] 2. T2 want to read F1 and its children. [1 " A 3. T3 want to modify R1 in P1001