(Solved) : Consider Database Consisting Two Tables Students S Registration R Students Sid Firstname Q30455800 . . . .

Consider a database consisting of two tables Students (S) andRegistration (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 toR400. Each page -of both tables- contains 200 records. We use thenotation S2:10 to denote the 10th record on the second page of theStudents table. R3:5 represents the 5th record on the third page ofthe Registration table.

Now, assume we want to use Multiple-granularity locking, with S,X, IS, IX and SIX locks. The used locking protocol has four levelsof granularity: database