Lab: Database Transactions

Key	Value
Course Code	MCS 8104, BBT1202, MIT 8107, and DAT 2201
Course Names	MCS 8104: Database Management Systems BBT 1202: Advanced Database Systems MIT 8107: Advanced Database Systems DAT 2201: Database Design and SQL
Semester	May to August 2026
Lecturer	Allan Omondi
Contact	aomondi@strathmore.edu
Note	The lecture contains both theory and practice. This notebook forms part of the practice. It is intended for educational purposes only. Recommended citation: BibTex

Technology Stack

System Architecture

Main Concept

Repository Structure

.
├── 0_admin_instructions
│ ├── 0_instructions_for_project_setup.md
│ ├── 1_instructions_for_python_installation.md
│ └── 2_instructions_for_project_cleanup.md
├── Docker-Compose.yaml
├── LICENSE
├── README.md
├── RecommendedCitation.bib
├── assets
│ └── images
│ ├── concurrency_problems.png
│ ├── isolation_levels.png
│ └── receipt_sections.png
├── database_transactions.md
├── full_database_transaction_script.sql
├── images
│ ├── apache-httpd-plus-php
│ │ └── Dockerfile
│ ├── mysql
│ │ └── Dockerfile
│ └── ubuntu
│ └── Dockerfile
├── lab_submission_bbt3104
│ └── lab_submission.md
├── lab_submission_dat2201
│ └── lab_submission.md
├── lab_submission_mcs8104
│ └── lab_submission.md
├── lab_submission_mit8107
│ ├── transaction1_CLI.sql
│ ├── transaction2_PHP.php
│ └── transaction2_python.py
├── pos_transaction_demo.py
├── requirements
│ ├── base.txt
│ ├── colab.txt
│ ├── constraints.txt
│ ├── dev.inferred.txt
│ ├── dev.lock.txt
│ ├── dev.txt
│ └── prod.txt
├── requirements.txt
└── script_python
└── transaction.py
14 directories, 31 files

Setup Instructions

• Setup Instructions

Lab Manual

Refer to the files below for more details:

1. database_transactions.md
2. pos_transaction_demo.py

Lab Submission Instructions

Refer to the end of the file below for more details:

• database_transactions.md

Teardown Instructions (to be done after submitting the lab)

Refer to the file below for more details:

• Teardown Instructions