Skip to content

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

Notifications You must be signed in to change notification settings

mSharifHub/SQL_GYM_DB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 

Repository files navigation

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.

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

No packages published