The database serves as a gym management system and can be used as a web app application where the gym staff can add members, manage payments, ban members, process payments, schedule workouts, check list of members enrolled per gym membership type. Also, a gym manager can terminate employees. A good example is a gym staff, who is a manager, adds a new gym member and an account is created. In the account, gym staff can add a gym membership type, check payments related to account, check if account is active, and check which employee created the account by verifying the employee id. In the same scenario, a gym member can select group of workout plans offered by the membership type. The gym member can also submit a payment to be processed by an employee assigned as an accountant. If the gym member does not the membership bill, the accounting team can notify the manager who is allowed to deactivate the account and or ban the member. The employee can also check for how many accounts are enrolled in a specific membership, and work outs withing a specific workout plan. Each personal trainer is assigned to a workout and personal trainers can insert the schedule for the planned workout.
-
Notifications
You must be signed in to change notification settings - Fork 0
A Term Project for Introduction To Relational Databases. I designed a relational database using sql for a gym membership management system. the documentation contains the scheme, sql code, and the description of the rows and the values
mSharifHub/SQL_GYM_DB
About
A Term Project for Introduction To Relational Databases. I designed a relational database using sql for a gym membership management system. the documentation contains the scheme, sql code, and the description of the rows and the values
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published