VIVEKANAND SCHOOL
COMPUTER SCIENCE PROJECT FILE
(2024-2025)
~BANK MANAGEMENT SYSTEM~
Submitted by-
Yash Jain
XII D
Submitted to-
Mrs. Teena sharma
CERTIFICATE
This is to certify that I, YASH JAIN, a student of class: XII-D of
VIVEKANAND SCHOOL has successfully completed the project on
BANK MANAGEMENT SYSTEM under the supervision of MRS.
TEENA SHARMA during the year 2024-25 in fulfillment of Computer
Science project.
I certify this project up to my expectation and as per guidelines
issued by CBSE, NEW DELHI.
Signature of
PRINCIPAL
Signature of Signature of
INTERNAL EXTERNAL
ACKNOWLEDMENT
It is with pleasure that I acknowledge my sincere gratitude to our
teacher, MRS. TEENA SHARMA who taught and undertook the
responsibility of teaching the subject computer science. I have
been greatly benefited from her classes.
I am especially indebted to our Principal MRS. POONAM SHARMA
who has always been a source of encouragement and support and
without whose inspiration this project would not have been a
successful I would like to place on record heartfelt thanks to her.
Finally, I would like to express my sincere appreciation for all the
other students for my batch their friendship & the fine time that we
all shared together.
HARDWARES AND SOFTWARE REQUIRED:
HARDWARE
● Desktop / Laptop
● Windows 11
SOFTWARE
● Python
● MySQL
● Python Connector Module
CONTENTS
S.no Topic
1. Certificate
2. Acknowledgment
3. Hardware and software required
4. Introduction
5. Python Source Code
6. MySQL Database
7. Outputs
8. References
INTRODUCTION
The project Bank Management System presented here represents a
pivotal solution in the realm of financial management, blending the
sophistication of MySQL as the database backend with the dynamic
capabilities of Python. This amalgamation results in a comprehensive
system that caters to both administrative and user functionalities,
streamlining processes related to account management, feedback
collection, and loan tracking.
Evolution of Management Systems using Python and MySQL
Connector
The evolution of management systems, especially in the banking sector,
has witnessed a paradigm shift with the advent of powerful programming
languages like Python and robust database management systems such
as MySQL. Python, recognized for its simplicity, readability, and
versatility, serves as the ideal frontend language for developing
user-friendly interfaces. MySQL, on the other hand, provides a reliable
and scalable database solution, ensuring the secure storage and
retrieval of crucial banking information.
The integration of these technologies facilitates a seamless flow of data,
enabling real-time interactions between users and the banking system.
The dynamic connectivity offered by the MySQL Python Connector
ensures efficient communication between the Python application and the
MySQL database
Purpose of the Bank Management System
The Bank Management System project aims to address several key
challenges in traditional banking operations. By leveraging Python's
intuitive programming features and MySQL's robust data management
capabilities, the system provides an agile and user-centric platform for
both customers and administrators.
User Functions
•Add Account: Users can easily open new accounts by providing
essential details, streamlining the account creation process.
•View Balance: Account holders can check their account balance in
real-time, fostering transparency and financial awareness.
•Give Feedback: The system facilitates a channel for users to provide
feedback, ensuring continuous improvement based on user input.
•View TransactionHistory:Users have access to their transaction history,
aiding in financialrecord-keeping and reconciliation.
Admin Functions
•Add New Accounts: Administrators can add new accounts to the
system, streamlining the process of on boarding new customers.
•View Loan Details: Admin have access to comprehensive loan details,
enabling effective management and decision-making.
•Update Loan Status: The system empowers administrators to update
the status of loans, tracking repayments and ensuring accurate
record-keeping.
•View Loan Defaulters: Admin can identify and view details of customers
who have defaulted on loan payments for a specified period.
•View User Feedback: The system consolidates user feedback,
providing valuable insights into user experiences and concerns.
Modules Used
Mysql.connector: This module enables python program to access MySql
databases.
Random: it generates random module generated by list by start-stop
skipping within a specific range.
PYTHON SOURCE CODE
MYSQL DATABASE
USE OF DATABASE AND SHOW ALL TABLE IN THE DATABASE :
DATA IN ACCOUNT HOLDER TABLE :
DESCRIBE ADMIN TABLE :
DATA IN ADMIN TABLE :
DESCRIBE FEEDBACK TABLE :
SHOW FEEDBACK OF USER:
DESCRIBE LOAN DETAILS TABLE:
DATA IN LOAN DETAILS TABLE:
DESCRIBE TRANSACTION TABLE:
SHOW TRANSACTION HISTORY OF THE USERS:
DESCRIBE USER_DATA:
DATA IN USER TABLE :
DESCRIBE ACCOUNT HOLDER TABLE :
OUTPUT
MAIN MENU:
ADMIN MENU:
ADDING THE DATA OF NEW ACCOUNT:
FOR VIEWING DATA OF ACCOUNT HOLDERS LOAN:
FOR UPDATING STATUS OF LOAN LEND:
FOR VIEWING DETAILS OF LOAN DEFAULTERS:
FOR VIEWING FEEDBACK OF USERS:
ADDING THE DATA OF NEW ACCOUNTS INTO LOAN ACCOUNTS:
USER MENU:
FOR VIEWING YOUR BANK :
FOR UPDATING THE NAME:
FOR UPDATING THE MAIL:
FOR UPDATING THE PHONE NUMBER:
FOR UPDATING THE ADDRESS:
FOR GIVING FEEDBACK:
REFERENCES
1. PYTHON
2. MY SQL
3. ARIHANT COMPUTER SCIENCE WITH PYTHON
4. WIKIPEDIA
