Computer Science Projects
Computer Science Projects
1
PROJECT ON ATM MACHINE MANAGEMENT SYSTEM
INTRODUCTION
Note:
pg. 2
OBJECTIVES OF THE PROJECT
pg. 3
PROPOSED SYSTEM
pg. 4
made their work faster and easier. Now only this software
pg. 5
SOURCE CODE
SOLUTION:
Import mysql. Connector as zql
conn—sql.connect{host—’locolhost',user—'root', password
—’manager’,database—' ATM_MACHlNE’)
pg. 6
print(”
BANK“)
print(“1.Tocreateaccount“)
print(”2.Tologin“)
print(”3.Exit“)
pg. 7
op——int(input(“Enteryourchoice “))
vwhile c ——”y ’:
f
m——int(input(“Entera4digitnumber
asaccontnumber“))
cb——"ce/ect* fromrecordzwhere
ACCONT_NO——{)“.format(m)
ct.execute(cb) d——
ct. fetchall() data——
ct.rowcount ifdata
————1
pg. 8
print(”Thizaccountnumber
alreadyexists “)
c——input(”Doyouwanttocontinue
continue
eice"
print(“Thankyou.“)
print(“Vizitagain
pg. 9
else“
name——input(“Enteryourname ’ /
f
passw——int(input(”Enteryourpass
word “))
ab——“inseKinto
records(ACCONT_NO,PASSWORD,NAME
) va/ues({),{),’{)’)“.format(m,passw,name)
ct.execute(ab)
pg. 10
print(’ AccountsucessfuIIy
(
created“)
print(’ Theminimumba/anceis
(
/000 ' J
f
s——int(input(“Enterthemoneyto
bedeposited”’))
zr——“updaterecordzzet
CR_AMT——{) where ACCONT_NO
——{) ’.format(z,m)
f
pg. 11
ct.execute(zr)
conn.commit()
ef——“updaterecordzzet
balance——cr_amt-withdrawlwhere
ACCONT_NO——{) ’.format(m)
f
ct.execute(e(
conn.commit()
print(”cucezcfullydepozited“)
print(”Thankyou”)
print(”Vizitagain“)
break
whiley=——“y“
pg. 12
acct——int(input(”Enteryouraccount
number “))
cb——’ise/ect* fromrecordswhere
ACCONT_NO——{)“.format(acct)
ct.execute(cb)
ct.fetcha/l() data
——ct.rowcount
ifdata————1-
pas——int(input(“Enteryour
password “))
e——”celectpazzwordfromrecordz
whereACCONT_NO——{)”.format(acct)
ct.execute(e)
pg. 13
a——ct. fetchone()
d——lizt(a)
ifpaz————d{0]
print(“correct“)
print(”1.Depozitngmoney
print(“£. withdrawingmoney“)
print(“3. Tranzferingmoney“)
print(“4.Checkingbalance“)
print(”5.ChangingAccount
number“)
r——int(input(“Enteryourchoice
pg. 14
amt——int(input(“Enterthe
moneytobedeposited “))
sr——”updaterecordsset CR_AMT——
CR_AMT+{) where ACCONT_NO——
{)“.format(amt,acct)
ct.execute(sr)
pg. 15
ef——”updaterecordccet balance
——cr amt-withdrawlwhere ACCONT_NO——
{)“.format(acct)
ct.execute(ef)
print(“cuceccfuliy
deposited“)
I——input(“Doyouwantto
continuey/n -”)
continue
else’
pg. 16
print(”Thankyou“)
amt——int(input(“Enterthe
moneytowithdraw-”’))
ah——”select BALANCE
fromrecordswhere accont_no——
{)”.format(acct)
ct.execute(ah) m——
ct. fetchone()
ifamt>m{0]
print(”Yourarehaving
less then ,amr)
f
print(”P/easetry
again
pg. 17
e/se:
cr——”updaterecordccet
balance——balance -{} where
ACCONT_NO——{)“.format(amt,acct)
ed——“updaterecordz
zet WITHDRAWL ——{) where
ACCONT_NO——{)“.format(amt,acct)
ct.execute(ed)
ct.execute(sr)
print(”3ucezzfu//y
updatad“)
y——input(“doyouwantto
continuey/n -“)
pg. 18
continue
elze’
print(“Thankyou“)
act——int(input(“Enterthe
accontnumbertobetransterrsd “))
ct.execute(cb)
ct.fetcha/I()
pg. 19
data——ct.rowcount
ifdata————1
print(act,“number
exists“)
m——int(input(“Enterthe
moneytobetransferred “))
ah——“select BALANCE
fromrecordswhere
accont_no——()”.format(acct)
ct.execute(ah) c——
ct. fetchone() ifm>c{0]
pg. 20
print(“Yourare
havinglezzthan“,m)
print(“Pleacetry
again
e/se:
av——’update
recordzzetbalance——ba/ance-{)where
ACCONT_NO——{}“.format(m,acct)
cv——“update
recordzzetbalance——balance+{} where
ACCONT_NO——{)”.format(m,act)
w——“updaterecordz
zetwithdrawl——withdrawl+(} where accont_no——
(}”.format(m,acct)
pg. 21
t——“updaterecordz
zet CR_AMT——CR_AMT+{} where
accont_no——{}“.format(m,act)
ct.execute(av)
ct.execute(cv)
ct.execute(w)
ct.execute(t)
conn.commit()
print(“ifiucezzfully
transfered“)
y——input(”doyouwant
tocontinuey/n -“)
/ // •
continue
e/se’
print(“Thankyou”)
ifr————4-
pg. 22
ma——”ceiectbalancefrom
recordswhereaccont_no——{) ’.format(acct)
f
ct.execute(ma) k
——ct. fetchone()
print(“BaIanceinyour
y——input(“doyouwantto
continuey/n -”)
continue
elze’
print(”Thankyou“)
pg. 23
i——int(input(“Enteryour
newaccountnumber:“))
cb——”ce/ect* fromrecords
whereACCONT_NO——(}”.format(i)
ct.execute(cb)
ct.fetchall() data
——ct.rowcount
ifdata————1s
print(”Thisnumber
already'exists ?
f
print(”Tryagain”)
y——input(”doyouwant
tocontinuey/n -“)
/ // •
continue
else“
pg. 24
print(“Thankyou”)
e/se:
name——input(“Enter
yourname
ar——“Updaterecordc
zetaccont_no——{) wherename——’()’and
password——{}”.format(i,name,pac)
ct.execute(ar)
print(”Yournew
accountnumberis”,i)
e/se’
print(”Wrongpassword“)
pg. 25
y——input(“doyouwantto
continuey/n -”)
e/se:
print(“yourAccountdoesnot
exists“)
iLOp——!$-’
print((lExiting“)
ct.c/ose()
pg. 26
pg. 27
1.T0 create aCC0\let
C0H2Ct
1,0ep0sÎtnq noney
2.vit£dra›inq c0ney
3,Traisfeiing n0neș
tttc ing b
5.ttanqing 1.cc0unt niaber
sfcessfull) dep0sited
DO }08 V6ftt tO COEtinte y/țl -
pg. 28
, l.fieøsitn9
. i0iey
1.«ittAa›in§
n0ney
3.Traisfeiin§
i0ney
fnter y0ttE
C#0ice:2
Sucessfilly iØatad
d0 ]01 Y6It t0 C0ntinyt
y/A -y
Enter ¿ovE ax0tnt
naIer:6f6J
l.fi8JJ0sitn§
n0ney
!.t1ecling
balance 5,tlaging
£«0int nuainr
pg. 29
pg. 30
pg. 31
Eni.eï ;0Jf rÏcice:I
pg. 32
CODE COMPLETENESS EVALUA1ON
pg. 33
HARDWARE AND SOFTWARE REQUIREMENTS
PLUS
CHIPSET FOR AMD ATHALON
X. Printer required
SOFTWARE REQUIREMENTS:
I. Windows OS
II. Python
pg. 34
BIBLIOGRAPHY
• v»uDsize- hbps://www.w3resource.com
• h pN e wik eda.or /
pg. 35