The following course learning outcomes are assessed by completing this assessment: • K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams,...

The following course learning outcomes are assessed by completing this assessment:
•    K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation
•    K5. describe relational algebra and its relationship to Structured Query Language (SQL);
•    A1. design and implement a relational database using a database management system;
Project Specification
You have been commissioned to create a database for TopFit, a company that runs a gym in Albury. TopFit offers a variety of fitness, strength and conditioning courses for members at various times. The gym provides top quality teachers and excellent equipment for the training of members.
All of TopFit’s courses consist of several classes, taught by TopFit staff. Each course has a number of classes with a maximum number of participants and some courses have prerequisites (for example, to enrol in “Advanced Cardio-fit”, members have to have successfully completed “Introductory Cardio-fit”). Anyone can sign up as a member and enrol in one or more courses at TopFit. Members can pay by different methods, either by monthly membership, or per day (they can attend as many classes as they wish on any given day).
The following business rules and information gathered about the current business activities will allow you to derive entities. Your submission is not expected to have many to many relationships left unresolved.  You may add entities or attributes as you see fit. Assumptions can be made to include further entities and their relationships, but referential integrity and normalisation processes must be adhered to. Reasons should be given for any relation that is not maintained in 3NF.