c$)$ Assume that undo$/$redo recovery algorithm with checkpoint is being used. The

database crashes immediately after statement $23.[2$ Marks$]$

$($i$)$ Which transactions would have to be undone?

$($ii$)$ Which transactions would have to be redone?

$($iii$)$ Which transactions will be ignored?

$($iV$)$ What are the values of S and T after recovery on the disk? a$)$ Show the undo$/$redo log file entries that would be generated by this execution b$)$ Assume that the undo$/$redo recovery algorithm with checkpoints is being used.

The database crashes immediately after statement $7.[1$ Marks$]$

$($i$)$ Which transactions would have to be undone?

$($ii$)$ Which transactions would have to be redone?generated by this

execution.