FIT CLUB Health Centre is a fitness centre with various facilities and has many branches across Australia. Every branch provides standard facilities of 24 hours gym and a swimming pool, and some additional facilities. A branch is called a club and supervised by a manager. The manager is responsible for the management
School of Business and Tourism llnioom zeit» Database Systems (CSC72001) Assignment 3: Enhanced Entity Relationship Diagram (10%) 3B – Develop a Database Prototype (20%) Due Date: 11.30 pm Monday Week 11 3B – 11.30pm Friday Week 13 Submission submit a report including an ERD design via MySCU 3B – submit a report and SQL script via MySCU. Submit Database on Infotech server Weight: 30% of overall unit assessment Overview In this assignment, you are a database analyst with the task to analyse a scenario, design, develop and test a database in MySQL using phpMyAdmin. 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. This assignment intends to give experience in database design and development. It is based on a fictitious scenario. Your focus will be to: Produce a fully normalised database design, modelled in an EERD, showing business rules; Develop entities (tables) with correct attributes included; Demonstrate supertypes and their associated subtypes; Demonstrate normalised relations; Make relational joins to ensure this prototype work…