PROJECT ON
BANKING:
CERTIFICATE
CLASS: Xii-a YEAR:2020-21
This is to certify that Investigatory Project is
successfully completed by Swastika Datta of
Class: XII, RollNo:…………for the academic year
2020-2021 .
External Examiner Internal
Examiner
Date: / / 20
Department : COMPUTER SCIENCE
Acknowledgement:
I, Swastika Datta of Class XII--A , Roll No……………… would like to
express my sincere gratitude to my computer science teacher, Sudip
Chakraborty for his vital support, guidance and encouragement – without
which this project would not have come forth.
INDEX
[Link] overview of project
[Link] for computerization
[Link] and Hardware requirement
[Link] of project
5. Source code in python
6. Output Screen
[Link]
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
TYPES OF FILES BASED ON ACCESS:
Text file
Binary file
Serial File
Random 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 [Link]
import pandas as pd
mydb=[Link](host="localhost",\
user="root",\
password="root",\
database="Bank")
mycursor=[Link]()
def AccInsert():
L=[]
Accno=int(input("Enter the Account number : "))
[Link](Accno)
name=input("Enter the Customer Name: ")
[Link](name)
age=int(input("Enter Age of Customer : "))
[Link](age)
occup=input("Enter the Customer Occupation : ")
[Link](occup)
Address=input("Enter the Address of the Customer : ")
[Link](Address)
Mob=int(input("Enter the Mobile number : "))
[Link](Mob)
Aadharno=int(input("Enter the Aadhar number : "))
[Link](Aadharno)
Amt=float(input("Enter the Money Deposited : "))
[Link](Amt)
AccType=input("Enter the Account Type (Saving/RD/PPF/Current) : ")
[Link](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)'''
[Link](sql,cust)
[Link]()
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"
[Link](sql,rl)
elif ch==2:
s=input("Enter Name : ")
rl=(s,)
sql="select * from account where Name=%s"
[Link](sql,rl)
elif ch==3:
s=int(input("Enter Mobile No : "))
rl=(s,)
sql="select * from account where Mob=%s"
[Link](sql,rl)
elif ch==4:
s=input("Enter Adhar : ")
rl=(s,)
sql="select * from account where Aadharno=%s"
[Link](sql,rl)
elif ch==5:
sql="select * from account"
[Link](sql)
res=[Link]()
print("The Customer details are as follows : ")
k=[Link](res,columns=['AcNo','Name','Age','Occn','Add','Mob','Aadh','Amt','Ac
cTy'])
print(k)
defAccDeposit():
L=[]
Accno=int(input("Enter the Account number : "))
[Link](Accno)
Amtdeposit=eval(input("Enter the Amount to be deposited : "))
[Link](Amtdeposit)
month=input("Enter month of Salary : ")
[Link](month)
cust=(L)
sql="Insert into amt(Accno,Amtdeposit,Month) values(%s,%s,%s)"
[Link](sql,cust)
[Link]()
defaccView():
print("Please enter the details to view the Money details :")
Accno=int(input("Enter Account number of the Customer whose amount is to be
viewed : "))
sql='''Select [Link], [Link],
[Link],[Link],[Link],[Link],[Link],Account.
Amt,[Link]
cType, sum([Link]), [Link] from Account INNER JOIN amt
ON
[Link]=[Link] and [Link] = %s'''
rl=(Accno,)
[Link](sql,rl)
res=[Link]()
for x in res:
print(x)
def closeAcc():
Accno=int(input("Enter the Account number of the Customer to be closed : "))
rl=(Accno,)
sql="Delete from amt where Accno=%s"
[Link](sql,rl)
sql="Delete from Account where Accno=%s"
[Link]()
defMenuSet():
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:
userInput = int(input("Please Select An Above Option: "))
except ValueError:
exit("\nHy! That's Not A Number")
else:
print("\n")
if(userInput == 1):
AccInsert()
elif (userInput==2):
AccView()
elif (userInput==3):
AccDeposit()
elif (userInput==4):
closeAcc()
elif (userInput==5):
accView()
else:
print("Enter correct choice. . . ")
MenuSet()
def runAgain():
runAgn = input("\nwant To Run Again Y/n: ")
while([Link]() == 'y'):
if([Link]() == "Windows"):
print([Link]('cls'))
else:
print([Link]('clear'))
MenuSet()
runAgn = input("\nwant To Run Again Y/n: ")
runAgain()
#OUTPUT
SCREEN :-
#MYSQL TABLE :-
# Limitation
1. Performance and Speed of execution is
not up to the mark.
2. It cannot perform all the required
function as bank required. It’s simply a
record of account of customer.
THANK YOU