PM SHRI KENDRIYA
VIDYALAYABERHAMPUR
COMPUTER SCIENCE PROJECT
2023-24
BANK MANAGEMENT SYSTEM
SUMBITTED BY:-
NAME:-OMM DIBYA JYOTI NAHAK
CLASS:- XII-A
CBSE ROLL NO:-
SUBMITTED TO:-
MR. SAROJ KANTA MISRA,
PGT(CS)
CERTIFICATE
This is to certify that, PRINCE YADAV a student of
class: XII-COMMERCE of OM SHANTI SHIKSHA
SADAN has successfully completed the project on
BANK MANAGEMENT SYSTEM under the
supervision of MRS.SUJATA
WADHWAduring 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,(CENTRAL
BOARD OF SECONDARY EDUCATION
Signature of PRINCIPAL
(Mr.Rajesh Kumar Gupta)
Signature of Signature of
INTERNAL EXTERNAL
ACKNOWLEDMENT
It is with pleasure that I acknowledge my
sincere gratitude to our teacher, MRS. SUJATA
WADHWA who taught and undertook the
responsibility of teaching the subject
computer science. I have been greatly
benefited from his classes.
I am especially indebted to our Principal MR.
RAJESH KUMAR GUPTA 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 him.
Finally, I would like to express my sincere
appreciation for all the other students
HARDWARES AND SOFTWARES
REQUIRED
HARDWARES
1. Desktop Computer/Laptop
2. Windows 10
SOFTWARES
1.Python
2.MySQL
3.Python Connector Module
CONTENTS
SL.NO TOPIC
1. Certificate
2. Acknowledgement
3. Hardware and
software required
4. Introduction
5. Python Source Code
6. MySQL Databases
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.
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 :
MAIN MENU:
ADMIN MENU:
ADDING THE DATA OF NEW ACCOUNT:
FOR VIEWING DATA OF ACCOUNT HOLDERS LOAN:
FOR UPDATING STATUS OF LEND
FOR VIEWING DETAILS OF LOAN DEFAULTERS:
FOR VIEWING ACCOUNT INFORMATION
ADDING THE DATA OF NEW ACCOUNTS INTO LOAN
ACCOUNTS:
USER MENU:
FOR VIEWING THE BANK :
FOR UPDATING THE NAME:
FOR UPDATING THE MAIL:
FOR UPDATING THE PHONE NUMBER:
FOR UPDATING THE ADDRESS:
FOR GIVING FEEDBACK:
1.PYTHON
2.MY SQL
3.ARIHANT COMUTER SCIENCE WITH PYTHON
CLASS 11 AND 12
4.WIKIPEDIA
