FlexTrainer

FlexTrainer is a database application for a Health and Fitness Club Management System that stores and manages information for three types of users: Members, Trainers, and Staff. It includes various features for members such as setting fitness goals, registering for classes and personal training, and tracking workout progress. Trainers can view all members, enter notes after a fitness class, and create workout programs. Lastly, the administrative staff has access to all the classes, rooms, bookings, equipment, and transactions that the system manages.

Youtube link

https://youtu.be/3wgxKx8V5UU

Team members

• Fabrice Mikobi - 101196480
• Ahmed Abdou - 101176667

Contributions

• Fabrice Mikobi: SQL statements, database creation, project report
• Ahmed Abdou: ER Diagram, database schema, project report

Repository organization

• ddl.sql: The DDL file to create all the tables in the FlexTrainer database
• dml.sql: The DML file to fill the tables with initial data for testing purposes
• sql statements.sql: The DQL file to test various queries (e.g., SELECT, INSERT, UPDATE, DELETE)
• ER_Diagram_-_3005_Project.pdf: the ER Diagram
• Fitnes_schema not normalized.pdf: Database schema before normalization
• Fitness_schema normalized.pdf: Database schema after normalization
• COMP3005 Project Report.pdf: Project report

Getting started

1. Run the ddl file to create the tables in the database
2. Run the dml file to fill the table with data
3. Run the queries in the dql file to test the database

Tables

1. Members

2. Trainers

3. Staff

4. Classes

5. Rooms

6. Equipment

7. Workouts

8. Exercises

9. Fitness_goals

10. Transactions

11. Member_classes

12. Goal_type

13. Workout_history

14. Bookings

15. Class_history