[SOLVED] Database Architecture Design 42 2025 Assignment 1 - Transaction Management SQL

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