Question: 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...

Question:

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.