BUXI JAGABANDHU ENGLISH MEDIUM SCHOOL -II

SATYABHAMAPUR

COMPUTER SCIENCE PROJECT

ON

“ATM Management System”

FOR

ALL INDIA SENIOR SCHOOL CERTIFICATE

EXAMINATION 2021 – 2022

BY

Satyam Rana

CLASS – XII

UNDER THE GUIDANCE OF

Mr. Ansuman Swain

P.G.T Computer Science

 BIODATA
NAME – Satyam Rana

DATE OF BIRTH – 28.11.2003

CLASS – XII

ROLL NO –

SUBJECT – Computer science

TEACHER – Mr. Ansuman swain

SCHOOL – B.J.E.M.S - II

NAME OF THE EXAMINATION – All India Senior School Certificate

Examination

ACADEMIC YEAR – 2021-2022

PROJECT TOPIC – ATM Management System

 ACKNOWLEDGEMENT
Being a student of class XII, I undertook a computer science project
for the fulfillment of examination of computer practical. I choose
“ATM Management System”

In spite of time constraints and other hindrances, I was and thanks

able to complete the project on time. I express my deep gratitude and
thanks to my teacher of computer science, Mr. Anshuman Swain
and my parents for their inspiration, guidance, and keen interest in
this piece of work.

Suvankar Panda
Class– XII
DECLARATION
I “Satyam Rana” of class – XII, bearing roll no. of BuxiJagabandhu

English Medium School-II, Satyabhamapur I am submitting this copy

of computer science project as evidence of my work in computer

laboratory.

Satyam Rana

Class-XII

Section-C

School- BuxiJagabandhu English Medium School-II

BONAFIDE CERTIFICATE

This is to certify that “Satyam Rana” of class – XII has successfully

prepared the project on “UPSC Registration Information system” for
AISSCE under the guidance Mr. Ansuman Swain’s in the computer
science department of BuxiJagabandhu English Medium School-II,
Satyabhamapur for the academic session 2021-22.

Sign of Examiner Mr. Ansuman Swain

P.G.T Computer Science

B.J.E.M.S II

Satyabhamapur
INTRODUCTION

This programme helps the users to add a DATA of customers of all those who
does shopping . Today’s world is full of completions and the only winner of this
race is the one who challenges everybody in that specific field.

This program is one example of how one shop can be deferent in function from

the other.             

  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.

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 out-dated 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

muchsophisticated 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 paperwork has to be done but now software production 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 beobtained by clicking the

button. Moreover, nowit’s an age of computers of and automatingsuch an

organization gives the better look

ADVANTAGES AND DISADVANTAGES

The black box tester has no "bonds" with the code, and a tester's
perception is very simple: a code must have bugs. Using the principle, "Ask and
you shall receive," black box testers find bugs where programmers don't. But,
on the other hand, black box testing has been said to be "like a walk in a dark
labyrinth without a flashlight," because the tester doesn't know how the
software being tested was actually constructed.
That's why there are situations when (1) a black box tester writes many
test cases to check something that can be tested by only one test case, and/or (2)
some parts of the back end are not tested at all. Therefore, black box testing has
the advantage of "an unaffiliated opinion," on the one hand, and the
disadvantage of "blind exploring," on the other.
HARDWARE AND SOFTWARE REQUIREMENTS

Hardware Required
1. PROCESSOR: Intel Core i3 7th gen
2. Printer: To print the required documents

3.Ram: 4GB OR More

4.Hard disk: 1TB OR More

5. Monitor: More than 14.1 inch

6. Keyboard: (For typing the input)

7. Mouse: (For pointer)

Software Required
1.Operating system: Windows 7 or above

2.Python IDLE 3.9

3.MS Word for presentation of output

SOURCE:(table creation)
import mysql.connector as sql

conn=sql.connect(host='localhost',user='root',password='manager',database='

ATM_MACHINE')

if conn.is_connected():

print("sucessfully connected")

c1=conn.cursor()

mn="CREATE TABLE RECORDS( ACCONT_NO INT(4) primary key,PASSWORD INT(3),NAME

VARCHAR(20),CR_AMT INT default(0),WITHDRAWL INT default(0),BALANCE INT default(0))"

c1.execute(mn)

print("Sucessfulluy created"

SOURCE:(main)
import mysql.connector as sql

conn = sql.connect(host='localhost', user='root', password='123456', database='ssdb')

c1 = conn.cursor()
print("===============================================================================
=")

print(" WELCOME TO OUR ATM

")

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(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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")
print(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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")
print(" PLEASE CLOSE THIS FILE BEFORE EXITING")

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")
print(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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")
print(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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")
print(" PLEASE CLOSE THIS FILE BEFORE EXITING")
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")
print("Please close this file before exiting.")
c1.close()

BIBLIOGRAPHY
1.Sumit Arora Computer science with python-class xii.
2.Arihant All in One.

***