Transaction Processing & ACID A Level Resources

​​A Level Computer Science: ​​Transaction processing and ACID

This module contains:

  • An editable PowerPoint lesson presentation
  • Editable revision handouts
  • A glossary which covers the key terminologies of the module
  • Topic mindmaps for visualising the key concepts
  • Printable flashcards to help students engage active recall
  • A quiz with answer key to test knowledge and understanding of the module
Compatible with the following examination boards
Transaction Processing & ACID A Level Resources Image 1
Transaction Processing & ACID A Level Resources Image 2
Transaction Processing & ACID A Level Resources Image 3
Transaction Processing & ACID A Level Resources Image 4
Transaction Processing & ACID A Level Resources Image 5

Download →

​Transaction processing and ACID

​A transaction is a single logical operation in a database. Example: Booking a ticket in an airline ticket reservation system. A transaction consists of several actions.
Concurrency: Even though many users can access and edit data at the same time, a database ensures the changes are reflected to all of them.

This ​​A Level Computer Science module introduces ​​transaction processing and ACID to your students, explaining:

  • ​​ACID rules
  • Issues in multi-user database
  • Record locking
  • Deadlocks
  • How deadlocks can be prevented?

More ​​Exchanging data Modules

​​​​Transaction processing and ACID is one lesson in our ​Exchanging data module. ​The other theory lessons can be found below: