Database Architecture & Design 4.2 (2025)
Assignment 1 - Transaction Management
“A Transaction is a group of SQL statements that you combine into a single logical unit of work. ”
You must design and implement a Relational Database, based on a topic of your own choosing to demonstrate Transaction Management in MySQL.
The database must have a minimum of 3 tables.
You must implement at least 3 different SQL Transactions to show your understanding of Transaction Management.
You must also write a 1000-word report explaining the ACID principles in relation to Transaction Management and explaining how your transactions adhere to the principles.
Your report should also include a Transaction State Diagram, using your Transactions to illustrate the stages.
Finally, you must create a ScreenCast (max 7 minutes) explaining in detail your Transaction Management solution and showing a demonstration of your Stored Procedures working.
Deliverables
• SQL file containing all the code to create your database, create tables, populate with sample data (minimum of 10 records) and stored procedure code.
• 1000-word report
• Screencast