SWE4304 Databases Assessment 2 Brief 2026-27 | University of Great Manchester

SWE4304 Databases Assessment 2 Brief

Learning Outcomes Assessed:

• LO3: Produce a DDL construct to implement a relational data model meeting the given requirements
• LO4: Create DML constructs to manipulate a relational data model to meet given requirements

Assessment Brief

The assessment components for this assignment are an Implementation document, as mentioned below. You are required to submit an MS-Word document describing all stages of the implementation of the project. This should include all the steps you have followed to convert your design (assignment 1) into a fully functional database using MySQL Workbench. This is worth 50% of your overall grade for this module. Word Count for the coursework is: 1500 (+/- 10%)

Based on the case scenario of the Budget and Expense Tracking System for which you have produced a design document in assignment 1, you are now entering into the Physical Design stage in terms of developing a relational database for the given client. In this part, you will need to explain, with evidence, the process you followed to implement your database design. You need to show evidence of the ability to translate a design into a functional database.

Use your understanding of Structured Query Language studied in this module to accomplish the tasks below. You are free to include any assumptions for the scenario given to meet the requirements with justification.

Task 1: Video [LO3 & LO4]

Provide SQL statements for the following tasks. A suitable video is to be created to show the execution of the following tasks. Screenshots to be provided for task 2, and the discussion to be carried out as discussed in the video, with suitable in-text and detailed references. The link to the video will be provided in the Appendix. The SQL codes were created to be attached in the appendix, as well as a zip file.

Task 2: SQL Codes with Demonstration in the class [LO3 & LO4]

a. Implement the design created earlier in assignment 1 to show all the physical relations with the required attribute, data type, constraint and any other relevant details.

b. Display the details of Sources of income as the client wants to keep up to date in terms of finances