This assignment requires you to demonstrate the knowledge and skills you have acquired throughout Unit: Databases - Spring 2024 by designing and creating a back-end database application that addresses the tasks given below.
In order to complete this assignment, you should choose an appropriate organization on which to conduct research and base your database application.
This assignment is split into THREE (3) tasks and accounts for 100% of the overall coursework mark for this unit.
Step 1: Select an industry in which you have an interest.
For example, commercial airlines, commercial banking, retail, beauty, digital, manufacturing, healthcare, fitness, publishing, marketing, hospitality, leisure and tourism, automotive, production, construction, etc.
Step 2: From the industry selected, you should investigate the different types of data that they hold and the types of transactions they carry out.
For example, an educational establishment will hold data about: – Students – Attendance – Staff – Rooms – Units – Assessments – Results – Staff wages/salary – Equipment
Their transactions might include: – Adding new students – Adding new staff – Deleting staff who leave – Adding student attendance information – Adding students to units – Allocating staff to teach units – Allocating rooms to units – Allocating different assessments to units and recording the results for each assessment the student undertakes – Increase or decrease the salary of a member of staff – Buy new equipment – Delete equipment that has been used or damaged
Produce the following documents:
a) Introduction, outline, and
