Question: Hello this quesion is related to Database Management Please don't answer with your handwriting thank you Consider the following four transactions . Transaction T1: read
Hello
this quesion is related to Database Management
Please don't answer with your handwriting
thank you


Consider the following four transactions . Transaction T1: read item(A); read item(D); write item(D); . Transaction T2: read item(B); write item(B); read item(D); write item(D) . Transaction T3: read item(C); write item(C): . Transaction T4: read item(D); write_item(D); read item(A); write_item(A); Following is a log corresponding to a particular schedule at the point of a system crash. [start_transaction, T1] read item, T1, A] [read item, T1, D] write item, T1, D, 20,25 commit, T1 [checkpoint start_transaction, T2] [read item, T2, B] write item, T2, B, 12, 18] start transaction, T4] [read item, T4, D write item, T4, D, 15,25] start transaction, T3 [write_item, T3, C, 30, 40] [read_item, T4, A] write_item, T4, A, 30, 20] commit, T4 read item, T2, D] write_item, T2, D, 15, 251 System Crash
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
