Banking Management (Project)

PADAMPUR PUBLIC SCHOOL, PADAMPUR
A PROJECT ON
BANKING MANAGEMENT SYSTEM
Submitted by : _________________
Class : XII (Science)
Roll No : _________________
Session : 2024 - 2025
Under the Guidance of :

________________________
Department of Computer Science
CERTIFICATE
CLASS: XII YEAR: 2024-2025
This is to certify that Investigatory Project is successfully

completed by ___________________________of Class: XII , Roll
no. : ______________for the academic year 2024-2025 in the
School Computer lab.
External Principal Internal

ACKNOWLEDGEMENT
I , ___________________________of class XIIth (science)
would like to express our sincere gratitude to my computer
science teacher ______________________ PGT COMPUTER
SCIENCE, for his/her vital support, guidance and
encouragement – without which this project would not have
come forth. We would also like to express our gratitude to
our school PADAMPUR PUBLIC SCHOOL, PADAMPUR for
letting us use the school laboratory.

INDEX
# Brief overview of project
# Need for computerization
# Software and Hardware requirement
# Advantages of project
# Source code in python
# Output screen
Brief Overview Of Project
This is a project based on bank management. The program helps us
to enter, display or alter the details of different accounts in the
bank.
Moreover and most importantly the program helps us to deposit
money in the account or close the account from the bank.
The program also helps us to know all the details of customers of
the bank.
It includes various function programs to do the above mentioned
tasks.
Data file handling has been effectively used in the program.
Database is a collection of interrelated data to serve multiple
applications, i.e. database programs create files of information. So
we see that files are worked with most inside the program itself.
DBMS
The software required for management of data is called DBMS. It
has three models
.Relation model: It stores information in form of rows(cardinality)
and columns(degree).
.Hierarchical model: In this type of model, we have multiple records
inside a single record.
. network model: In this , the data is represented by collections of
record and relationship is represented by associations.
CHARACTERISTICS OF DBMS:
. It reduces the redundancy
. Data sharing
. Data standardization
.Reduction of data in inconsistency
TYPES OF FILES BASED ON ACCESS:
. Sequential file
. Serial file
. Random file
. Text file
. Binary file
NEED FOR COMPUTERIZATION
The profile of Indian Banking has undergone a metamorphosis
in the post nationalization era. The change is characterized by
radical transformation in its role, scope and extent of business
operations and the industry has grown dramatically in size as
well as complexity of operations. The banks in India have also
emerged as effective catalytic agent of socio-economic change.
This massive expansion and diversification of the banking

system also brought its attendant strains. Housekeeping and
control functions got neglected owing to exponential increase
in business. The customer service tended to deteriorate and
attracted criticism. Bottlenecks developed in the flow of
information compromising control and monitoring on the one
hand and MIS based policy formulation on the other. This
massive growth in network of branches and volume of business
was achieved mostly by enlarging manpower resources. Then,
this industry entered into a phase with assent on consolidation
and qualitative improvement on its operations by using suitable
contemporary technological tools.
SOFTWARE AND HARDWARE
REQUIREMENTS
#Software Specification: -
Operating system: Windows 10/8/7
Platform : Python IDLE 3.8
Database : MySQL
Languages : Python
#Hardware specification: -
Processor : Dual core or above
Hard Disk : 40 GB
Ram : 1024MB
Advantages of project
In order to meet competition, avoid obsolescence, and seize
opportunities .A bank must be able to:
. Respond rapidly to new or changing information needs.

. Maintaining the past data to ensure the satisfaction of the
customer.
. Reduce error
. Provide better protection
. Make work easier
. Reduce manual labor
SOURCE CODE IN PYTHON

Import os
import platform
import mysql . connector
import pandas as pd
mydb = mysql . connector . connect(host="localhost",\

user="root",\
password="root",\
database="Bank")
my cursor = mydb . cursor ( )
def Acc Insert():

L=[ ]
Acc no=int(input("Enter the Account number : "))
L .append(Acc no)
name=input("Enter the Customer Name: ")
L .append(name)
age =int(input("Enter Age of Customer : "))
L .append(age)
occup=input("Enter the Customer Occupation : ")
L .append(occup)
Address=input("Enter the Address of the Customer : ")
L .append(Address)
Mob=int(input("Enter the Mobile number : "))
L .append(Mob)
Aadhar no=int(input("Enter the Aadhar number : "))
L .append(Aadharno)
Amt=float(input("Enter the Money Deposited : "))
L .append(Amt)
Acc Type=input("Enter the Account Type (Saving/RD/PPF/Current) :
")
L .append(AccType)
cust=(L)
sql='''Insert into ACCOUNT(Accno
,Name,Age,occu,Address,Mob,Aadharno,amt,AccType)
values(%s,%s,%s, %s,%s,%s, %s,%s,%s)'''
mycursor.execute(sql,cust)
mydb.commit()
defAccView():
print("Select the search criteria : ")
print("1. Acc no")
print("2. Name")
print("3. Mobile")
print("4. Adhar")
print("5. View All")
ch=int(input("Enter the choice : "))
if ch==1:
s=int(input("Enter ACC no : "))
rl=(s,)
sql="select * from account where Accno=%s"
mycursor.execute(sql,rl)
elifch==2:
s=input("Enter Name : ")
rl=(s,)
sql="select * from account where Name=%s"
elif ch==3:
s=int(input("Enter Mobile No : "))
rl=(s,)
sql="select * from account where Mob=%s"
elif ch==4:
s=input("Enter Adhar : ")
rl=(s,)
sql="select * from account where Aadharno=%s"
my cursor.execute(sql,rl)
elif ch==5:
sql="select * from account"
my cursor.execute(sql)
res=mycursor.fetchall()
print("The Customer details are as follows : ")
k=pd.DataFrame(res,columns=['AcNo','Name','Age','Occn','Add','Mo
b','Aadh','Amt','AccTy'])
print(k)
def Acc Deposit():

L=[ ]
Acc no=int(input("Enter the Account number : "))
L .append(Acc no)
Amt deposit=eval(input("Enter the Amount to be deposited : "))
L .append(Amt deposit)
month=input("Enter month of Salary : ")
L .append(month)
cust=(L)
sql="Insert into amt(Accno,Amtdeposit,Month) values(%s,%s,%s)"
my cursor.execute(sql,cust)
my db.commit()
def accView():
print("Please enter the details to view the Money details :")
Acc no=int(input("Enter the Account number of the Customer whose
amount is to be viewed : "))
sql='''Select Account.Accno, Account.Name,
Account.Age,Account.occu,Account.Address,Account.Mob,Account.
Aadharno,Account.Amt,Account.Ac
cType, sum(amt.Amtdeposit), amt.month from Account INNER JOIN
amt ON
Account.Accno=amt.Accno and amt.Accno = %s'''
rl=(Accno,)
res=mycursor.fetchall()
for x in res:
print(x)
def closeAcc():
Acc no=int(input("Enter the Account number of the Customer to be
closed : "))
rl=(Accno,)
sql="Delete from amt where Accno=%s"
sql="Delete from Account where Accno=%s"
my db.commit()
def MenuSet():
print("Enter 1 : To Add Customer")
print("Enter 2 : To View Customer ")
print("Enter 3 : To Deposit Money ")
print("Enter 4 : To Close Account")
print("Enter 5 : To View All Customer Details")
try:
user Input = int(input("Please Select An Above Option: "))
except ValueError:
exit("\nHy! That's Not A Number")
else:
print("\n")
if(userInput == 1):
Acc Insert()
elif (userInput==2):
Acc View()
Acc Deposit()
close Acc()
acc View()
else:
print("Enter correct choice. . . ")
Menu Set()
Def runAgain():
Run Agn = input("\nwant To Run Again Y/n: ")
while(runAgn.lower() == 'y'):
if(platform.system() == "Windows"):
print(os.system('cls'))
else:
print(os.system('clear'))
Menu Set()
Run Agn = input("\nwant To Run Again Y/n: ")
Run Again()
#OUTPUT SCREEN:-
#MYSQL TABLE :-
FUTURE ENHANCEMENT
The future of banking technology is driven by consumers,
especially Gen Zers, who see technology as something that
enhances their lives. A common trend in banking technology
is using an application programming interface(API) to make
proprietary data available to anyone who has the consumer’s
permission to access it.
Future development in artificial intelligence(AI), machine

learning(ML),blockchain and other cutting-edge technologies
have the potential to completely transform Indian banking.
This change will improve client experiences, increase security,
assure regulatory compliance and improve operational
efficiency.
CONCLUSION
In conclusion, bank management systems are essential
software systems for financial institutions to manage their
operations effectively. The system provides various
functionalities, including customer management, account
management, transaction management and reporting.
Banking holds a crucial role in our day-to-day life. We must

adhere to the banking system as responsible citizens. The
banking system acts as a crucial base for the financial system
as well as the entire economic system of the country. It
provides a base to the market and the companies.

Banking Management (Project)

Uploaded by

Copyright:

Available Formats

Banking Management (Project)

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Banking Management (Project)

Uploaded by

Copyright:

Available Formats

PADAMPUR PUBLIC SCHOOL, PADAMPUR

Under the Guidance of :

CLASS: XII YEAR: 2024-2025

This is to certify that Investigatory Project is successfully

External Principal Internal

I , ___________________________of class XIIth (science)

would like to express our sincere gratitude to my computer

science teacher ______________________ PGT COMPUTER

SCIENCE, for his/her vital support, guidance and

encouragement – without which this project would not have

come forth. We would also like to express our gratitude to

our school PADAMPUR PUBLIC SCHOOL, PADAMPUR for

letting us use the school laboratory.

# Need for computerization

# Software and Hardware requirement

# Source code in python

This massive expansion and diversification of the banking

Operating system: Windows 10/8/7

Platform : Python IDLE 3.8

Processor : Dual core or above

. Respond rapidly to new or changing information needs.

SOURCE CODE IN PYTHON

mydb = mysql . connector . connect(host="localhost",\

def Acc Insert():

def Acc Deposit():

Future development in artificial intelligence(AI), machine

Banking holds a crucial role in our day-to-day life. We must

You might also like