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., M.Phil., B.Ed.,

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

1.REGISTER

2.LOGIN

IF N=1 PROGRAM INSERTS DATA IN

THE DATABASE
IF N =2PROGRAM FETCHES DATA FROM DATABASE
MENU IS DISPLAYED
1.CREATE BANK ACCOUNT
2.TRANSACTION
3.CUSTOMER DETAILS
4.TRANSACTION DETAILS
5.DELETE ACCOUNT
6.QUIT
IF N= 3/4DATA IS FETCHED FROM THE
DATABASE

IF N= 1/2/5/6DATA IS
INSERTED IN THE DATABASE
 Source code

TABLE.PY

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',passwd='man

ager’ database='bank')

ifconn.is_connected():

print('connected succesfully')

cur = conn.cursor()

cur.execute('create table customer_details(acct_noint primary

key,acct_namevarchar(25) ,phone_nobigint(25) check(phone_no>11),address
varchar(25),cr_amt float )')

MENU.PY

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',passwd='man

ager', database='bank') cur = conn.cursor()

conn.autocommit = True
print('1.CREATE BANK ACCOUNT')

print('2.TRANSACTION') print('3.CUSTOMER

DETAILS') print(‘4.TRANSACTION DETAILS’)

print('5.DELETE DETAILS') print('6.QUIT')

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)+" ) "

cur.execute(V_SQLInsert)
print('Account Created Succesfully!!!!!')

conn.commit()

if n == 2:

acct_no=int(input('Enter Your Account Number='))

cur.execute('select * from customer_details where acct_no='+str

(acct_no) )

data=cur.fetchall()

count=cur.rowcount conn.commit()

if count == 0:

print('Account Number Invalid Sorry Try

Again Later’)

else:

print('1.WITHDRAW AMOUNT')

print('2.ADD AMOUNT')

x=int(input('Enter your CHOICE='))

if x == 1:

amt=int(input('Enter withdrawl amount='))

 cur.execute('update customer_details set cr_amt=cr_amt-'+str(amt) + '

where acct_no=' +str(acct_no) )

conn.commit()

print('Account Updated Succesfully!!!!!')

if x== 2:

amt=int(input('Enter amount to be added='))

cur.execute('update customer_details set cr_amt=cr_amt+'+str(amt) +

' where acct_no=' +str(acct_no) )

conn.commit()

print('Account Updated Succesfully!!!!!')

if n == 3:

acct_no=int(input('Enter your account number=')

cur.execute('select * from customer_details where acct_no='+str(acct_no) )

if cur.fetchone() is None:

print('Invalid Account number')

else:

cur.execute('select * from customer_details where

acct_no='+str(acct_no) )

data=cur.fetchall()

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()

cur.execute('select * from customer_detaills

where acct_no='+str(acct_no) )

if cur.fetchone() is None:

print()

print('Invalid Account number')

else:

cur.execute('select * from transactions where

acct_no='+str(acct_no) ) data=cur.fetchall()

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='))

cur.execute('delete from customer_details where acct_no='+str(acct_no) )

print('ACCOUNT DELETED SUCCESFULLY')

if n == 6:

quit()
 MAIN.PY

import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',passwd='man

ager' database='bank')

cur = conn.cursor()

cur.execute('create table user_table(username

varchar(25) primarykey,passwrdvarchar(25) not null )')
print('1.REGISTER')
print('2.LOGIN')

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 + " ') "

cur.execute(V_SQLInsert)

conn.commit()

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+ " ' "

cur.execute(V_Sql_Sel)

if cur.fetchone() 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

I.OPERATING 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

www.google.com
https://docs.python.org/3/tutorial/ www.code-projects.com
www.slideshare.net iki
di
www.wikipedia.c
om

**********************************************************