Question 6 Consider a database consisting of two tables Students (S) and Registration (R) Students(sid, firstName, lastName) . Registration(rid, cid, uid, credit) The table Students is stored in 300 pages labeled S1 to S300, and the table Registration is stored in 400 pages labeled R1 to R400. Each page notation S2:10 to denote the 10th record on the second page of the Students table. R3:5 represents the 5th record on the third page of the Registration table -of both tables- contains 200 records. We use the Now, assume we want to use Multiple-granularity locking, with S. X, IS, IX and SIX locks. The used locking protocol has four levels of granularity: database level, table level, page level, and record level. For instance IS(D) shows a database-level lock. X(R3:10) shows a records-level X lock for the 10th record of third page of the Registration table. And S(S2:23 S4:45) shows a request for record-level S lock from the 23th record of 23th page of the Student table. s on the second page of the Students table to 45th record For each of the following operations, indicate the sequence of lock requests that must be gener- ated by a transaction that wants to execute these operations (a) Read all records on all pages of the Students table (b) Read all records on page S12 through S56, and modify the record S18:5 (c) Increase the value of the credit field of the first record of every page of the Registration table by one (blind writes independent of the original value) (d) Increase the value of the credit field of all records in the Registration table by one (e) Delete all records of the Students and Registration tables