ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my Computer Science
teacher for providing me with the opportunity to work on this
project titled "Gym Management System". Their valuable guidance,
encouragement, and continuous support helped me successfully
complete this project.
I am also thankful to my school for providing the necessary facilities
and resources required for the completion of this project. I extend
my heartfelt thanks to my parents and friends for their constant
support, motivation, and cooperation throughout the project work.
This project has helped me gain practical knowledge of Python
programming, MySQL database management, and their real-life
applications. I am truly grateful to everyone who directly or indirectly
contributed to the successful completion of this project.
CERTIFICATE
This is to certify that Saurav Gupta, a student of Class XII, has
successfully completed the Informatics Practices project titled “Gym
Management System” using Python and MySQL during the academic
session 2025-26 under my guidance.
This project is an original work carried out by the student and is
submitted in partial fulfillment of the requirements for the CBSE
Class XII Informatics Practices practical examination. The project
demonstrates the student’s understanding of database management
concepts, Python programming, and their practical implementation.
I wish him all the best for his future endeavors.
_________________
Internal Examiner
_________________
External Examiner
_________________
Principal
INTRODUCTION
A Gym Membership Management System is a comprehensive
software solution designed to streamline the administrative
processes and enhance the operational efficiency of fitness centres
and gyms. This system is specifically tailored to meet the unique
needs of managing memberships, services, and interactions within a
fitness facility. The primary goal is to provide a centralized platform
that automates various tasks related to member registration,
attendance tracking, payment processing, and communication. At its
core, the Gym Membership Management System acts as a digital hub
that facilitates the seamless administration of membership- related
activities. The system often integrates with access control
mechanisms, allowing gyms to regulate entry based on membership
status and permissions. A Gym Membership Management System
serves as a powerful tool for gym owners and staff, streamlining day-
to-day operations, ensuring accurate record-keeping, and ultimately
contributing to a positive and efficient experience for both fitness
facility administrators and their members.
OBJECTIVE
• To facilitate the data storage, data maintenance and its
retrieval for the gym in an igneous way.
• To simplify the member management process.
• To engage members and increase retention.
• To make well-informed financial decisions and know the inner
workings of the business.
• To leverage the data through increased efficiency, speed, and
quality of service.
• To produce clear reports that allow track all transactions easily.
• To consolidate all billing management into one location.
• To monitor member data and activity.
• To provide reports across the business in an easy-to- digest
format.
• To address concerns and continuously make improvements as
per the requirements and feedbacks.
FEATURES
CUSTOMER SITE AND MEMBER APP:
Having an easy-to- navigate customer site and member app, where
customers can book on the go, can eliminate the lengthy and manual
process of signing up new members in person at any establishment.
In turn, by saving more time on the on boarding process, this time
can be used to learn about the new customer and how to best
engage with them. Moreover, this feature automatically gathers and
records essential information about you’re the such as their personal
bio, preferences, and demands.
GYM SOFTWARE BOOKING AND SCHEDULING
SOLUTIONS:
One of the essential features in a gym booking software is the
booking and scheduling feature. This feature allows customers to
reserve a time slot for their indoor or outdoor workout at the gym or
grab a spot in their online or live stream classes. With this feature,
how many people can enter the gym or join the classes at a time can
be regulated.
RELIABLE GYM MANAGEMENT REPORTING AND
ANALYTICS:
Leveraging data and analytics can push the Business to become even
more competitive. This is why getting a software with a robust data
and analytics function should be considered. Also, by coupling this
feature with a report generation function, the software can convert
raw data into digestible and summarized reports in the form of
graphs, charts, or analytics dashboards. This will allow you to gain
valuable insights in just a few glances.
ACCESSIBILITY AND FLEXIBILITY:
This feature follows that the gym management software should be
compatible across various platforms. This allows for greater mobility
and flexibility for both the gym and the customers.
AUTOMATED BILLING AND PAYMENT:
This feature allows streamline billing and payment process by
automating it. It can automate recurring membership payments,
manage accounts, and keep track of bills. Moreover, a software that
can support various payment methods such as credit/debit card
processing, cash, checks, or even digital wallet options is essential.
FUNCTIONALITIES
Member Registration:
Capture and store member information during the Registration
process. Assign unique identification numbers. Or membership
Payment Processing:
Facilitate secure payment transactions for membership fees,
renewals, and additional services. Support various payment methods
and recurring billing.
Attendance Tracking:
Record and monitor member attendance for classes, sessions, or
general gym use. Generate attendance reports for analysis.
Scheduler and Booking:
Enable members to schedule classes, sessions, or appointments.
Manage reservations and optimize facility usage.
Access Control:
Integrate with access systems to control entry permissions based on
membership [Link] and manage member access to specific
areas or services.
Communication Tools:
Provide channels for announcements, notifications, and
communication between staff and members. Send automated
reminders for upcoming classes or membership renewals.
Reporting and Analytics:
Generate reports on key performance indicators, financial metrics,
and member engagement. Analyse data to make informed business
decisions.
Renewal Management:
Automate membership renewal processes. Send renewal reminders
to members before their memberships expire.
Fitness Tracking:
Offer features for members to track and log their fitness activities
and progress.
Mobile Accessibility:
Provide a mobile-friendly interface or app for members to access
their accounts, book classes, and receive notifications.
Integration with Other Systems:
Coordinate with accounting, CRM, or marketing systems to ensure
data consistency. Streamline business operations by integrating
Various processes.
Security Measures:
Implement data security measures to protect member information.
Ensure compliance with privacy regulations.
User Management:
Allow gym staff to manage member profiles, handle inquiries, and
provide customer support. Enable members to update their personal
information and preferences.
EXISTING SYSTEM
o Lack of security of data
o More man power
o Time consuming
o Needs manual calculations
o No direct role for the higher officials
PROPOSED SYSTEM
The aim of proposed system is to develop a system of improved
facilities. The proposed system can overcome all the limitations of
the existing system. The system provides proper security and
reduces the manual work.
o Security of data
o Ensure data accuracy
o Proper control of the higher officials
o Minimize manual data entry
o Minimum time needed for the various processing
o Greater efficiency
o Better service
o User friendliness and interactive
HARDWARE REQUIREMENTS
OF GYM MANAGEMENT SYSTEM
The hardware required for the development of the Project is:
▪ Processor: Intel P-IV System
▪ Processor Speed: 833 MHzH
▪ RAM: 512 Mb Ram
▪ Hard Disk: 40 Gb
SOFTWARE REQUIREMENTS
OF GYM MANAGEMENT SYSTEM
The software required for the development of the Project is:
▪ Operating System: Windows 2000 Professional
▪ Environment: Visual Studio .NET 2002
▪ Net Framework: Version 1.0
▪ Language: Visual Basic
▪ Backend: SQL Server 2000
DATABASE DESIGN
The database is designed to store and manage all information related
to gym members, trainers, payments, and attendance in a structured
manner. A relational database approach is used to ensure data
integrity, reduce redundancy, and enable easy retrieval of
information.
• Entities Used
• Members
• Trainers
• Membership Plans
• Payments
• Attendance
MODULES USED
User Defined Modules
a) add_member()
b) update_member()
c) delete_member()
d) show_members()
e) process_payment()
f) attendance_entry()
System Defined Modules
a. [Link]
b. datetime
c. sys
ABOUT PYTHON
Python is a high-level, interpreted, and general-purpose
programming language known for its simplicity and readability. It is
widely used in application development, data handling, automation,
and database connectivity. Python supports multiple programming
paradigms such as procedural, object-oriented, and functional
programming.
In this project, Python is used as the front-end programming
language to interact with the MySQL database. Using Python’s
[Link] module, the program performs various database
operations such as inserting, updating, deleting, and retrieving
records related to gym members, payments, and attendance.
Python’s easy syntax and powerful libraries make it an ideal choice
for developing database management systems. It helps in reducing
development time, minimizing errors, and improving overall
efficiency of the system.
ABOUT SQL
SQL (Structured Query Language) is a standard language used for
managing and manipulating relational databases. It is used to store,
retrieve, update, and delete data efficiently. SQL allows users to
create databases, define table structures, and establish relationships
between different tables.
In this project, SQL is used as the back-end database language to
store gym-related information such as member details, membership
plans, payments, and attendance records. SQL commands like
CREATE, INSERT, SELECT, UPDATE, and DELETE are used to manage
the data.
SQL ensures data accuracy, integrity, and security by using
constraints such as primary keys and foreign keys. It enables fast
data retrieval and helps in generating meaningful reports required
for effective decision-making in the Gym Membership Management
System.
DATA TABLES
Mysql table structure:
Fees table:
Login table:
Member table:
Sno table:
Trainer table:
SOURCE CODE
import [Link]
print("""
_________________________________
GYM MANAGEMENT
_________________________________
""")
mydb = [Link](host="localhost", user="root",
password="1234")
mycursor = [Link]()
# Creating database and tables
[Link]("CREATE DATABASE IF NOT EXISTS gym")
[Link]("USE gym")
[Link]("CREATE TABLE IF NOT EXISTS fees(silver INT, gold
INT, platinum INT)")
[Link]("CREATE TABLE IF NOT EXISTS login(username
VARCHAR(25), password VARCHAR(25) NOT NULL)")
[Link]("CREATE TABLE IF NOT EXISTS member(id INT
AUTO_INCREMENT PRIMARY KEY, name VARCHAR(25), gender
VARCHAR(20), category VARCHAR(25), amount INT)")
[Link]("CREATE TABLE IF NOT EXISTS sno(trainer_id INT,
member_id INT)")
[Link]("CREATE TABLE IF NOT EXISTS trainer(id INT
AUTO_INCREMENT PRIMARY KEY, name VARCHAR(25), age
VARCHAR(25), gender VARCHAR(10), salary INT)")
[Link]()
# Inserting initial data
def initialize_data():
[Link]("SELECT * FROM login")
if not [Link]():
[Link]("INSERT INTO login VALUES('im__siranjeevi',
'1234')")
[Link]()
[Link]("SELECT * FROM sno")
if not [Link]():
[Link]("INSERT INTO sno VALUES(0, 0)")
[Link]()
[Link]("SELECT * FROM fees")
if not [Link]():
[Link]("INSERT INTO fees VALUES(700, 600, 500)")
[Link]()
initialize_data()
# Function for user login
def login():
username = input("Enter username: ")
password = input("Enter password: ")
[Link]("SELECT * FROM login WHERE username=%s AND
password=%s", (username, password))
if [Link]():
print("Login successful!")
return True
else:
print("Invalid username or password.")
return False
# Function to modify plans, trainer info, and member info
def modify_info():
while True:
print("""
1. Plans
2. Trainer Info
3. Member Info
4. Go Back
""")
ch = int(input("Enter your choice: "))
if ch == 1: # Modify Plans
print("""
1. Platinum
2. Gold
3. Silver
""")
ch2 = int(input("Enter your choice: "))
amount = int(input("Enter amount per month to update: "))
if ch2 == 1:
[Link]("UPDATE fees SET platinum=%s", (amount,))
[Link]()
print("Platinum plan updated successfully.")
elif ch2 == 2:
[Link]("UPDATE fees SET gold=%s", (amount,))
[Link]()
print("Gold plan updated successfully.")
elif ch2 == 3:
[Link]("UPDATE fees SET silver=%s", (amount,))
[Link]()
print("Silver plan updated successfully.")
elif ch == 2: # Trainer Info
trainer_id = int(input("Enter ID to modify: "))
[Link]("SELECT * FROM trainer WHERE id=%s",
(trainer_id,))
trainer = [Link]()
if trainer:
print(f"\nCurrent Trainer Details:")
print(f"ID: {trainer[0]}, Name: {trainer[1]}, Age: {trainer[2]},
Gender: {trainer[3]}, Salary: {trainer[4]}")
print("""
1. Name
2. Age
3. Gender
4. Salary
""")
modify_choice = int(input("Enter your choice: "))
if modify_choice == 1:
name = input("Enter updated name: ")
[Link]("UPDATE trainer SET name=%s WHERE
id=%s", (name, trainer_id))
[Link]()
print("Name updated successfully.")
elif modify_choice == 2:
age = input("Enter updated age: ")
[Link]("UPDATE trainer SET age=%s WHERE
id=%s", (age, trainer_id))
[Link]()
print("Age updated successfully.")
elif modify_choice == 3:
gender = input("Enter updated gender (m/f): ")
[Link]("UPDATE trainer SET gender=%s WHERE
id=%s", (gender, trainer_id))
[Link]()
print("Gender updated successfully.")
elif modify_choice == 4:
salary = int(input("Enter updated salary: "))
[Link]("UPDATE trainer SET salary=%s WHERE
id=%s", (salary, trainer_id))
[Link]()
print("Salary updated successfully.")
else:
print("ID Not Found.")
elif ch == 3: # Member Info
member_id = int(input("Enter ID to modify: "))
[Link]("SELECT * FROM member WHERE id=%s",
(member_id,))
member = [Link]()
if member:
print(f"\nCurrent Member Details:")
print(f"ID: {member[0]}, Name: {member[1]}, Gender:
{member[2]}, Category: {member[3]}, Amount: {member[4]}")
print("""
1. Name
2. Gender
3. Category
""")
modify_choice = int(input("Enter your choice: "))
if modify_choice == 1:
name = input("Enter updated name: ")
[Link]("UPDATE member SET name=%s WHERE
id=%s", (name, member_id))
[Link]()
print("Name updated successfully.")
elif modify_choice == 2:
gender = input("Enter updated gender (m/f): ")
[Link]("UPDATE member SET gender=%s WHERE
id=%s", (gender, member_id))
[Link]()
print("Gender updated successfully.")
elif modify_choice == 3:
print("""
1. Platinum
2. Gold
3. Silver
""")
[Link]("SELECT * FROM fees")
fees = [Link]()
print(f"Current Fees: Platinum: {fees[2]}, Gold: {fees[1]}, Silver:
{fees[0]}")
category_choice = int(input("Enter your choice: "))
if category_choice == 1:
category = "Platinum"
amount = fees[2]
elif category_choice == 2:
category = "Gold"
amount = fees[1]
elif category_choice == 3:
category = "Silver"
amount = fees[0]
[Link]("UPDATE member SET category=%s,
amount=%s WHERE id=%s", (category, amount, member_id))
[Link]()
print("Category and amount updated successfully.")
else:
print("ID Not Found.")
elif ch == 4: # Go Back
break
# Function to add a trainer
def add_trainer():
while True:
name = input("Enter Name: ")
age = input("Enter Age: ")
gender = input("Enter Gender (m/f): ")
salary = int(input("Enter Salary: "))
[Link]("INSERT INTO trainer (name, age, gender, salary)
VALUES (%s, %s, %s, %s)", (name, age, gender, salary))
[Link]()
print(f"\nTrainer added successfully with the following details:")
[Link]("SELECT LAST_INSERT_ID()") # Get the last
inserted ID
trainer_id = [Link]()[0]
print(f"ID: {trainer_id}, Name: {name}, Age: {age}, Gender: {gender},
Salary: {salary}\n")
another = input("Do you want to add another trainer? (y/n): ")
if [Link]() != 'y':
break
# Function to add a member
def add_member():
while True:
name = input("Enter Name: ")
gender = input("Enter Gender (m/f): ")
print("""
1. Platinum -------------> amount -> 8400 [per month 700]
2. Gold -----------------> amount -> 7200 [per month 600]
3. Silver ---------------> amount -> 6000 [per month 500]
""")
plan_choice = int(input("Enter your choice: "))
[Link]("SELECT * FROM fees")
fees = [Link]()
if plan_choice == 1:
category = 'Platinum'
amount = fees[2]
elif plan_choice == 2:
category = 'Gold'
amount = fees[1]
elif plan_choice == 3:
category = 'Silver'
amount = fees[0]
[Link]("INSERT INTO member (name, gender, category,
amount) VALUES (%s, %s, %s, %s)", (name, gender, category, amount))
[Link]()
print(f"\nMember added successfully with the following details:")
[Link]("SELECT LAST_INSERT_ID()") # Get the last
inserted ID
member_id = [Link]()[0]
print(f"ID: {member_id}, Name: {name}, Gender: {gender}, Category:
{category}, Amount: {amount}\n")
another = input("Do you want to add another member? (y/n): ")
if [Link]() != 'y':
break
# Function to remove a trainer
def remove_trainer():
while True:
trainer_id = int(input("Enter Trainer ID to remove: "))
[Link]("DELETE FROM trainer WHERE id=%s", (trainer_id,))
[Link]()
print("Trainer removed successfully.")
another = input("Do you want to remove another trainer? (y/n): ")
if [Link]() != 'y':
break
# Function to remove a member
def remove_member():
while True:
member_id = int(input("Enter Member ID to remove: "))
[Link]("DELETE FROM member WHERE id=%s",
(member_id,))
[Link]()
print("Member removed successfully.")
another = input("Do you want to remove another member? (y/n): ")
if [Link]() != 'y':
break
# Main program loop
if login(): # User login
logged_in = True
while logged_in:
print("""
1. Add Trainer
2. Add Member
3. Remove Trainer
4. Remove Member
5. Modify Info
6. Change Password
7. Logout
""")
choice = int(input("Enter your choice: "))
if choice == 1: # Add Trainer
add_trainer()
elif choice == 2: # Add Member
add_member()
elif choice == 3: # Remove Trainer
remove_trainer()
elif choice == 4: # Remove Member
remove_member()
elif choice == 5: # Modify
modify_info()
elif choice == 6: # Change Password
new_password = input("Enter new password: ")
[Link]("UPDATE login SET password=%s",
(new_password,))
[Link]()
print("Password changed successfully.")
elif choice == 7: # Logout
logged_in = False
OUTPUT SCREENSHOTS
GYM MANAGEMENT:
• Logging In:
• Adding Trainer:
• Adding Member:
• Removing Trainer:
• Removing member:
• Modifying plans:
1. Modifying trainer:
• Modifying trainer’s name:
• Modifying trainer’age:
• Modifying trainer’s gender:
• Modifying trainer’s salary:
2. Modifying member:
• Modifying member’s name:
• Modifying member’s gender:
• Modifying member’s category:
3. Going back from modifying:
• Changing password:
• Logging Out:
BENEFITS OF THE SYSTEM
The gym management system provides an efficient and organized
method to manage daily gym operations. It replaces the traditional
manual record-keeping system with a computerized database, which
reduces paperwork and saves time. All important data related to
trainers, members, membership plans, and fees is stored securely in
a MySQL database, ensuring accuracy and easy retrieval of
information.
The system allows the admin to add, delete, and modify records
quickly, reducing human errors and duplication of data. The login
and password authentication feature ensures that only authorized
users can access and modify sensitive information. Overall, the
system increases productivity, improves data management, and
ensures smooth functioning of gym activities.
CONCLUSION
While developing this project, the Gym Management System
teaches us how to effectively manage gym operations,
including trainer and member management. This system,
created using Python, provides a clear structure for handling
essential tasks while visualizing data for better analysis.
The script comprises several key modules:
1. Main Module: This serves as the control center for all other
modules, coordinating their functions.
2. Trainer Information Module: This displays all relevant
data about trainers, making it easy to manage their profiles.
3. Member Information Module: Similar to the trainer
module, this provides a comprehensive overview of members
and their details.
4. Fee Management Module: This allows for easy updates and
modifications to membership fees.
5. User Authentication Module: This ensures secure access
through a login system, protecting sensitive data.
Overall, this Gym Management System enhances operational
efficiency and improves the user experience for both staff and
members..
BIBLIOGRAPHY
• Computer science with PYTHON textbook for
class XI and XII by SUMITA ARORA.
• https//[Link]
• https//[Link]
• https//[Link]