QUESTION B3. [PROFICIENT/ADVANCED (9 marks) How does the recovery manager ensure that atomicity and durability of transactions survive a system crash? (b) (3 marks) Assume that immediate update recovery protocol with checkpointing is used in a database management system. The following transaction log shows a particu- lar schedule at the point of system crash for four transactions T, T2, T3 and T4 Describe the recovery process from the system crash. Specify which transactions are rolled back, which write operations in the log are redone and which (if any) are undone KR, T1, 200, 225 > K T2 starts> K T2 commits> K T3 starts> KP, T3, 125, 1015> K T4 starts> System Crash! (c) (3 marks) Briefly explain the difference between Network Attached Storage (NAS) and solutions is best suited for Storage Area Network (SAN). Which of these storage database applications, and why