Section outline

    • week 10 Book

      Teaching and Learning Methods to be Employed

      1.    Illustrated lecture on transactions, ACID properties, and isolation levels

      2.    Concurrency problem demonstration with parallel transaction scenarios

      3.    Recovery mechanisms and log-based recovery exercise

      4.    Final course review and exam preparation session

       

      Learning Outcomes / Objectives

      By the end of this week, students should be able to:

      1.    Define a transaction and explain the ACID properties.

      2.    Describe the concurrency problems that arise when transactions execute simultaneously.

      3.    Explain lock-based and timestamp-based concurrency control protocols.

      4.    Describe transaction isolation levels and their trade-offs.

      5.    Explain the concept of database failure and recovery.

      6.    Describe log-based recovery and the ARIES algorithm concepts.

    • Course Discussion Forum
      Due: Thursday, 30 July 2026, 7:12 AM
    • COURSE EXAMINATION GUIDE AND COMPLETE REFERENCE LISTS Page

      Sample Examination Questions by Learning Outcome

      Not available unless: The activity Course Outline is marked complete