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: