(Solved): Consider a DBMS using ARIES protocol for logging records. Its transaction recovery log contains log ...

Consider a DBMS using ARIES protocol for logging records. Its transaction recovery log contains log records of the following form: The log also contains checkpoint begin, checkpoint end, transaction begin, transaction commit, transaction end and undo action records. The database contains four objects (i.e., X, Y, Z and W). The DBMS sees records in the log on disk after a crash. Notice that there are no dirty pages nor active transactions, during the first and only checkpoint. LSN ARIES Record 1. ?BEGIN CHECKPOINT> 2. ?END CHECKPOINT> 3. $?\mathrm{T}1,\mathrm{X},1,2?$ 4. $?\mathrm{T}2,\mathrm{Y},3,4?$ 5. ?T1 COMMIT> 6. $?\mathrm{T}1\mathrm{END}>$ 7. $?\mathrm{T}3,\mathrm{Z},5,6?$ 8. $?\mathrm{T}4,\mathrm{W},5,6?$ 9. $?\mathrm{T}2$ COMMIT $>$