VAIRAMS PUBLIC SCHOOL (CBSE)
PERUMANADU, PUDUKKOTTAI
CBSE AFFILIATION NUMBER-1930376
COMPUTERSCIENCE (083) PROJECT
BANK MANAGEMENT SYSTEM (BMS)
A dissertation submitted to Vairams Public School (CBSE),Perumanadu,
Pudukkottai for the CBSE Senior Secondary Examination
Class XII of COMPUTER SCIENCE
SUBMITTED BY:
Rubinaath KP Roll Number-:
UNDER THE SUPERVISION AND GUIDANCE of
Mrs. MADEENA BEGUM K, MCA., [Link]., [Link].,
Department of Computer Science
Vairams Public School (CBSE), Perumanadu, Pudukkottai
January, 2024
BONAFIDE CERTIFICATE
Certified to be the Bonafide project of work done by Master/Miss
________________________________________________________________
Register No._________________of Class XII in Vairams Public School (CBSE),
Perumanadu, Pudukkottai during the academic year 2023–2024. Submitted for AISSCE
Practical Examination held in the Computer Science Laboratory at Vairams Public School
(CBSE), Perumanadu, Pudukkottai.
Date:Internal Examiner
PrincipalExternal Examiner
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my
gratitude to the people who have been instrumental in the successful completion of
this project.
I express deep sense of gratitude to almighty God for giving me strength for the
successful completion of the project.
I would like to express my special thanks of gratitude to my teachers as well as to
our Principal and our school management who gave me the golden opportunity to
do this wonderful project on the topic study on BANK
MANAGEMENT SYSTEM (BMS) which also helped me in doing a lot of
research and I came to know about so many new things I am really thankful to
them.
Secondly I would also like to thank my parents and friends who helped me a lot in
finalizing this project within the limited time frame.
KP Rubinaath
INDEX
1. PROBLEM DEFINITION
1. INTRODUCTION
"BANK MANAGEMENT SYSTEM" This project is useful for the bank employees as well as
customers to keep a track of account details. The emerging of digital system made information
available on finger tips. By automating the transactions one can view the details as and when
required in no time. This project emphases on creation of new customer accounts, managing the
existing account holders in the bank, by making digital system one can generate daily reports,
monthly reports and annual reports which can enhance the system.
1.2 OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the programming knowledge into a real- world
situation/problem and exposed the students how programming skills helps in developing a good
software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when developing small to medium sized
projects.
3. Write effective procedural code to solve small to medium sized problems.
4. Students will demonstrate a breadth of knowledge in computer science, as exemplified in the
areas of systems, theory and software development.
5. Students will demonstrate ability to conduct a research or applied Computer Science project,
requiring writing and presentation skills which exemplify scholarly style in computer science.
2. PROBLEM ANALYSIS
2.1 EXISTING SYSTEM
Manual Entry
Hard to Maintain
More Time
2.2 PROPOSED SYSTEM
Not Time Consuming
Free of cost
Easy Access
Easy Retrieve
24x7 Service
FLOW CHART
[Link]
[Link]
IF N=1 PROGRAM INSERTS DATA IN
THE DATABASE
IF N =2PROGRAM FETCHES DATA FROM DATABASE
MENU IS DISPLAYED
[Link] BANK ACCOUNT
[Link]
[Link] DETAILS
[Link] DETAILS
[Link] ACCOUNT
[Link]
IF N= 3/4DATA IS FETCHED FROM THE
DATABASE
IF N= 1/2/5/6DATA IS
INSERTED IN THE DATABASE
Source code
[Link]
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='man
ager’ database='bank')
ifconn.is_connected():
print('connected succesfully')
cur = [Link]()
[Link]('create table customer_details(acct_noint primary
key,acct_namevarchar(25) ,phone_nobigint(25) check(phone_no>11),address
varchar(25),cr_amt float )')
[Link]
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='man
ager', database='bank') cur = [Link]()
[Link] = True
print('[Link] BANK ACCOUNT')
print('[Link]') print('[Link]
DETAILS') print(‘[Link] DETAILS’)
print('[Link] DETAILS') print('[Link]')
n=int(input('Enter your
CHOICE='))
if n == 1:
acc_no=int(input('Enter your ACCOUNT
NUMBER='))
acc_name=input('Enter your ACCOUNT
NAME=') ph_no=int(input('Enter your
PHONE NUMBER=')) add=(input('Enter your
place='))
cr_amt=int(input('Enter your credit amount='))
V_SQLInsert="INSERT INTO customer_details values (" + str (acc_no) + ",' "
+ acc_name + " ',"+str(ph_no) +
",' " +add + " ',"+ str (cr_amt)+" ) "
[Link](V_SQLInsert)
print('Account Created Succesfully!!!!!')
[Link]()
if n == 2:
acct_no=int(input('Enter Your Account Number='))
[Link]('select * from customer_details where acct_no='+str
(acct_no) )
data=[Link]()
count=[Link] [Link]()
if count == 0:
print('Account Number Invalid Sorry Try
Again Later’)
else:
print('[Link] AMOUNT')
print('[Link] AMOUNT')
x=int(input('Enter your CHOICE='))
if x == 1:
amt=int(input('Enter withdrawl amount='))
[Link]('update customer_details set cr_amt=cr_amt-'+str(amt) + '
where acct_no=' +str(acct_no) )
[Link]()
print('Account Updated Succesfully!!!!!')
if x== 2:
amt=int(input('Enter amount to be added='))
[Link]('update customer_details set cr_amt=cr_amt+'+str(amt) +
' where acct_no=' +str(acct_no) )
[Link]()
print('Account Updated Succesfully!!!!!')
if n == 3:
acct_no=int(input('Enter your account number=')
[Link]('select * from customer_details where acct_no='+str(acct_no) )
if [Link]() is None:
print('Invalid Account number')
else:
[Link]('select * from customer_details where
acct_no='+str(acct_no) )
data=[Link]()
for row in data:
print('ACCOUNT NO=',acct_no)
print('ACCOUNT NAME=',row[1])
print(' PHONE NUMBER=',row[2])
print('ADDRESS=',row[3])
print('cr_amt=',row[4])
if n== 4:
acct_no=int(input('Enter your account
number='))
print()
[Link]('select * from customer_detaills
where acct_no='+str(acct_no) )
if [Link]() is None:
print()
print('Invalid Account number')
else:
[Link]('select * from transactions where
acct_no='+str(acct_no) ) data=[Link]()
for row in data:
print('ACCOUNT NO=',acct_no)
print()
print('DATE=',row[1])
print()
print(' WITHDRAWAL AMOUNT=',row[2])
print()
print('AMOUNT ADDED=',row[3])
print()
if n == 5:
print('DELETE YOUR ACCOUNT')
acct_no=int(input('Enter your account
number='))
[Link]('delete from customer_details where acct_no='+str(acct_no) )
print('ACCOUNT DELETED SUCCESFULLY')
if n == 6:
quit()
[Link]
import [Link] as sql
conn=[Link](host='localhost',user='root',passwd='man
ager' database='bank')
cur = [Link]()
[Link]('create table user_table(username
varchar(25) primarykey,passwrdvarchar(25) not null )')
print('[Link]')
print('[Link]')
n=int(input('enter your choice='))
if n== 1:
name=input('Enter a Username=') passwd=int(input('Enter a 4 DIGIT
Password='))
V_SQLInsert="INSERT INTO user_table (passwrd,username) values (" + str
(passwd) + ",' " + name + " ') "
[Link](V_SQLInsert)
[Link]()
print('USER created
succesfully')
if n==2 :
name=input('Enter your Username=') passwd=int(input('Enter
your 4 DIGIT Password='))
V_Sql_Sel="select * from user_table where passwrd='"+str
(passwd)+"' and username= ' " +name+ " ' "
[Link](V_Sql_Sel)
if [Link]() is None:
print('Invalid username or password')
else:
import main
OUTPUT
MAIN PAGE
MENU PAGE
- CREATE BANK ACCOUNT
CUSTOMER DETAILS
TRANSCATION
TRANSACTION DETAILS
HARDWARE AND SOFTWARE REQUIREMENTS
[Link] SYSTEM : WINDOWS 7 AND ABOVE
II. PROCESSOR: PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUALCORE)
III. MOTHERBOARD:1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIAK8M800+8237R PLUS CHIPSET FOR AMD ATHALON
IV. RAM:512MB+
V. Hard disk:SATA 40 GB OR ABOVE
VI. CD/DVD r/w multi drive combo: (If back up required)
VII. FLOPPY DRIVE 1.44 MB:(If Backup required)
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse
X. Printer:(if print is required – [Hard copy])
SOFTWARE REQUIREMENTS:
Windows OS
Python
7. Bibliography
Computer science With Python - Class XII By : SumitaArora
Computer science With Python - Class XII By : PreetiArora
8. Webliography
[Link]
[Link] [Link]
[Link] iki
di
[Link].c
om
**********************************************************
