A. Overview Your task is to analyse a scenario, and design, develop and test a database in MySQL using PhpMyAdmin. You are provided with the scenario (below) and supporting documents (on MySCU). It is your job to analyse the data requirements provided in the scenario and design and develop a relational database to meet the client needs. You will also need to add data and create SQL queries to provide results suitable for reporting. The intent of this assignment is to give you experience in design and development. It is based on a fictitious scenario. Your focus will be to: • produce a correctly normalised database design, modelled in an EERD, showing business rules; • Develop entiti
Assignment 4A – Enhanced Entity Relationship Diagram (20%) 4B – Develop a Database Prototype, Test and Evaluate (25%) Both 4A and 4B should be submitted in one report. Due Date: 4A – 14 Dec 2020 11:00 PM 4B – 14 Dec 2020 11:00 PM Submission: Submit Part A via MySCU Submit Part B report and […]