KENDRIYA VIDYALAYA
BARGARH
ACADEMIC YEAR : 2020-21
COMPUTER SCIENCE PROJECT ON:
“ATM MACHINE”
PROJECT SUBMITTED BY:
SANAT KUMAR SETH
KHAGESWAR DEHERI
UNDER THE GUIDANCE OF:
MRS. PRITI
BONAFIDE CERTIFICATE
This is to certify that Candidates SANAT KUMAR
SETH Roll No:36 and KHAGESWAR DEHERI Roll No:
has successfully completed the project Work entitled
"ATM MACHINE MANAGEMENT SYSTEM." in the
subject Computer Science (083) laid down in the rule
and regulations of CBSE for the purpose of Practical
Examination in class XII.
INTERNAL EXAMINER : DATE :
EXTERNAL EXAMINER : PRINCIPAL :
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 express my deep sense of gratitude to the luminary
Mr H.P.CHAND The Principal, Kendriya Vidyalaya
Bargarh who has been continuously motivating and
extending their helping hand to us.
My sincere thanks to Mrs. PRITI, Master In-charge, A
guide, Mentor and all the above a friend, who
critically reviewed my project and helped in solving
each and every problem, occurred during
implementation of the project.
I express my gratitude to my parents for constant
encouragement while carrying out this project.
TABLE OF CONTENTS
SR.NO DESCRIPTION PAGE NO
01 ACKNOWLEDGEMENT
02 INTRODUCTION
03 OBJECTIVES OF THE PROJECT
04 PROPOSED SYSTEM
05 FLOW CHART
06 SOURCE CODE
07 OUTPUT
08 INSTALLATION PROCEDURE
09 HARDWARE AND SOFTWARE
REQUIREMENTS
10 BIBLIOGRAPHY
PROJECT ON ATM MACHINE MANAGEMENT SYSTEM
INTRODUCTION :
The ATM MACHINE SOFTWARE is device which is as
same as normal Atm machine . It allows the user to
create account, deposit money, withdraw money,
Transfer the money and check Balance.
Note :
• Allow the user to input their question.
• Show an in progress message.
• Create 10/20 responses, and show a random
response.
• Allow the user to ask another question/advice
or quit the software.
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.
• Write programs utilizing modern software
tools.
• Apply object oriented programming principles
effectively when developing small to medium
sized projects.
• Write effective procedural code to solve small
to medium sized problems.
• Students will demonstrate a breadth of
knowledge in computer science, as
exemplified in the areas of systems, theory
and software development.
• 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.
PROPOSED SYSTEM :
Today one cannot afford to rely on the fallible human
beings of be really wants to stand against today’s
merciless competition where not to wise saying “to
err is human” no longer valid, it’s outdated to
rationalize your mistake. So, to keep pace with time,
to bring about the best result without malfunctioning
and greater efficiency so to replace the unending
heaps of flies with a much sophisticated hard disk of
the computer.
One has to use the data management software.
Software has been an ascent in atomization various
organisations. Many software products working are
now in markets, which have helped in making the
organizations work easier and efficiently. Data
management initially had to maintain a lot of ledgers
and a lot of paper work has to be done but now
software product on this organization has made their
work faster and easier. Now only this software has to
be loaded on the computer and work can be done.
This prevents a lot of time and money. The work
becomes fully automated and any information
regarding the organization can be obtained by
clicking the button. Moreover, now it’s an age of
computers of and automating such an organization
gives the better look.
FLOW-CHART:
START
CONN = SQL .CONNECT ( HOST =' LOCALHOST ', USER =' ROOT ', PASSWORD =' MANAGER ', DATABASE =
'ATM_MACHINE')
IMPORT MYSQL.CONNECTOR AS SQL
C1=CONN.CURSOR()
Print(“Welcome to our bank”)
Print(“1. TO CREATE ACCOUNT”)
Print(“2. TO LOGIN”)
Print(“3. TO EXIT”)
OP=INT(INPUT(“ENTER YOUR
CHOICE :”))
if OP==1:
c="y"
M =INT ( INPUT ("ENTER A 4 DIGIT NUMBER AS ACCO UNT number:"))
While c==”Y”
cb="select * from records where ACCONT_NO={}".format(m)
IF NO CREATE ACCOUNT
CHECK WHETHER THE NUMBER EXISTS
IF OP==2
print("1.Depositng money")
IF CH==1,WITHDRAW
print("2.withdrawing THE MONEY money")
money") print("3.Transfering
print("4.Checking balance") print("5.Changing Account number")
IF CH==1,DEPOSIT THE MONEY
stop
SOURCE CODE :
Create a Python project of a ATM MACHINE
MANAGEMENT SYSTEM .
Note :
• Display the options and ask the user to
enter the choice.
• Show an in progress message.
• Create appropriate response.
• Allow the user to continue/ or quit the game.
SOLUTION:
import mysql.connector as sql
conn=sql.connect(host='localhost',user='root',password
='manager',database=' ATM_MACHINE')
c1=conn.cursor()
print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$")
print("WELCOME TO OUR BANK ")
print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$")
print("1.To create account")
print("2.To login")
print("3.Exit")
print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$")
op=int(input("Enter your choice :"))
print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$")
if op==1:
c="y"
while c=="y":
m=int(input("Enter a 4 digit number as
accont number:"))
cb="select * from records where
ACCONT_NO={}".format(m)
c1.execute(cb)
d=c1.fetchall()
data=c1.rowcount
if data==1:
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
print("This account number already
exists:")
c=input("Do you want to continue y/n
-")
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
if c=="y":
continue
else:
print("Thank you.")
print("Visit again.")
print("$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$")
else:
name=input("Enter your name:")
passw=int(input("Enter your pass
word:"))
ab="insert into
records(ACCONT_NO,PASSWORD,NAME)
values({},{},”{}“)".format(m,passw,name)
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
c1.execute(ab)
conn.commit()
print("Account sucessfully created")
print("The minimum balance is 1000
")
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
s=int(input("Enter the money to be
deposited :"))
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
sr="update records set CR_AMT={}
where ACCONT_NO={}".format(s,m)
c1.execute(sr)
conn.commit()
ef="update records set
balance=cr_amt-withdrawl where
ACCONT_NO={}".format(m)
c1.execute(ef)
conn.commit()
print("sucessfully deposited")
print("Thank you")
print("Visit again")
break
if op==2:
y="y"
while y=="y":
acct=int(input("Enter your account
number:"))
cb="select * from records where
ACCONT_NO={}".format(acct)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
pas=int(input("Enter your
password :"))
print("$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$")
e="select password from records
where ACCONT_NO={}".format(acct)
c1.execute(e)
a=c1.fetchone()
d=list(a)
if pas==d[0]:
print("correct")
print("1.Depositng money")
print("2.withdrawing money")
print("3.Transfering money")
print("4.Checking balance")
print("5.Changing Account number
")
print("$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$")
r=int(input("Enter your choice:"))
print("$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$")
if r==1:
amt=int(input("Enter the
money to be deposited:"))
print("$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$")
sr="update records set
CR_AMT=CR_AMT + {} where
ACCONT_NO={}".format(amt,acct)
c1.execute(sr)
conn.commit()
ef="update records set
balance=cr_amt-withdrawl where
ACCONT_NO={}".format(acct)
c1.execute(ef)
conn.commit()
print("sucessfully deposited")
t=input("Do you want to
continue y/n -")
print("$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$")
if t=="y":
continue
else:
print("Thank you")
if r==2:
amt=int(input("Enter the
money to withdraw:"))
print("$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$")
ah="select BALANCE from
records where accont_no={}".format(acct)
c1.execute(ah)
m=c1.fetchone()
if amt >m[0]:
print("Your are having less
than",amt)
print("Please try again")
print("$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$")
else:
sr="update records set
balance=balance - {} where
ACCONT_NO={}".format(amt,acct)
ed="update records set
WITHDRAWL ={} where
ACCONT_NO={}".format(amt,acct)
c1.execute(ed)
c1.execute(sr)
conn.commit()
print("Sucessfully updatad")
y=input("do you want to
continue y/n -")
if y=="y":
continue
else:
print("Thank you")
if r==3:
act=int(input("Enter the accont
number to be transferrsd :"))
print("$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$")
cb="select * from records
where ACCONT_NO={}".format(act)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
print(act ,"number exists")
m=int(input("Enter the
money to be transferred :"))
print("$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$")
ah="select BALANCE from
records where accont_no={}".format(acct)
c1.execute(ah)
c=c1.fetchone()
if m > c[0]:
print("Your are having
less than",m)
print("Please try again")
print("$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$")
else:
av="update records set
balance=balance-{} where
ACCONT_NO={}".format(m,acct)
cv="update records set
balance=balance+{} where
ACCONT_NO={}".format(m,act)
w="update records set
withdrawl=withdrawl+{} where
accont_no={}".format(m,acct)
t="update records set
CR_AMT=CR_AMT+{} where
accont_no={}".format(m,act)
c1.execute(av)
c1.execute(cv)
c1.execute(w)
c1.execute(t)
conn.commit()
print("Sucessfully
transfered")
y=input("do you want to
continue y/n -")
if y=="y":
continue
else:
print("Thank you")
if r==4:
ma="select balance from
records where accont_no={}".format(acct)
c1.execute(ma)
k=c1.fetchone()
print("Balance in your
account=",k)
print("$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$")
y=input("do you want to
continue y/n -")
if y=="y":
continue
else:
print("Thank you")
if r==5:
i=int(input("Enter your new
account number:"))
cb="select * from records
where ACCONT_NO={}".format(i)
c1.execute(cb)
c1.fetchall()
data=c1.rowcount
if data==1:
print("This number already
exists")
print("Try again")
y=input("do you want to
continue y/n -")
if y=="y":
continue
else:
print("Thank you")
else:
name=input("Enter your
name")
ar="Update records set
accont_no={} where name='{}' and
password={}".format(i,name,pas)
c1.execute(ar)
conn.commit()
print("Your new account number is ",i)
else:
print("Wrong password")
print("$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$$$$$$$$$$$$$$$$$$$")
y=input("do you want to continue y/n -")
else:
print("your Account does not exists")
if op==3:
print("Exiting")
c1.close()
INSTALLATION PROCEDURE
A TM MACHINE
Pre-Requisites :
1. You have to have the following softwares for the successful
running of this software, which are:
I) Python (Only for the First time), it is downloadable
from “www.python.org”.
II) MySQL (Only for the First time), it is downloadable
from “www.mysql.org”.
Installation :
1. There will be two folders namely 'Python Files' and 'EXE
files' in the folder 'Source Code'.
2. The folder 'Python Files' will contain the source code of the
software in python language. If you are running the software
by the 3rd step mentioned below you have to pre install the
following modules :-
I) mysql.connector /pymysql.
II) matplotlib.
3. Open the files in any python editors and run it to start and
work on the software.
4. The folder 'EXE files' will contain two files namely
'main.exe' and 'Tables_in_mysql.exe'.
5. First run the 'Tables_in_mysql.exe' to create the tables in
MySQL.
6. Then run the file 'main.exe' to start and work on the
software.
CAUTION :
If you are running the software through running the python
files or by running the .exe files ; first run the file named
“Tables_in_mysql”.
The .exe file will take some time to run; so be PATIENT.
HARDWARE AND SOFTWARE
REQUIREMENTS
I.OPERATING SYSTEM : WINDOWS 7 AND ABOVE
II. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON(3800+-
4200+ DUAL CORE)
III. MOTHERBOARD : 1.845 OR 915,995
FOR PENTIUM 0R
MSI K9MM-V VIA
K8M800+8237R
PLUS
CHIPSET FOR
AMDATHALON
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 : required
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python.
BIBLIOGRAPHY :
• Computer science With Python - Class XII By : Sumita
Arora.
• A Project Report On Blood Bank Management System
(BBMS).
(By : Praveen C ADHIYAMAAN)
• Website: https://www.w3resource.com.
• https://en.wikipedia.org/.
***
