VELAMMAL VIDYALAYA

ALAPAKKAM

ACADEMIC SESSION 2023-24

SUBJECT: COMPUTER SCIENCE
PARKING MANAGEMENT SYSTEM

SUBMITTED BY:
NAME : NUTIKA.N
CLASS & SEC: XII-F
EXAM NO :12F38

SUBMITTED TO:
TEACHER NAME: MS. G MOHANA SUNDARI M Tech, B. ed
DESIGNATION: PGT(CS)
 VELAMMAL EDUCATIONAL TRUST

VELAMMAL VIDYALAYA, ALAPAKKAM

Name: Batch No:

Class: Regd. No:

Certificate
Certified that this is a bonafide Record of Practical work done by
Mr/Miss. in the
Laboratory during the year

Teacher – In- Charge

MS. G MOHANA SUNDARI

Submitted for the Practical Examination in at

held on .

Principal Internal Examiners External Examiners

 ACKNOWLEDGEMENT

In the accomplishment of this project successfully, many people

have bestowed their blessings and heart pledged support upon
me, I take this opportunity to express my gratitude to all, who have
been instrumental in the successful completion of this project.

Primarily, I express my deep sense of gratitude to the luminary.

The Correspondent, Shri.M.V.M.VEL MOHAN, The Principal.
Ms. Y HEMALATHA, Senior Headmaster MR. PRAVEEN. for
providing the best of facilities and environment to bring out
innovation and spirit of inquiry through this venture.

I am deeply indebted to my teachers, without whose constructive

feedback, this project would not have been successful. The
valuable advice and suggestions for correction, modifications and
improvement did enhance the quality of the task.

I would also like to thank my parents, friends and all the members
who contributed to this project was vital for the success of the
project.

I am grateful for their constant support and help.

 CONTENTS

S.NO PARTICULARS PAGE NO

1 Introduction 5

2 Objectives of the Project 6

3 Feasibility of Study 7

4 Data Bases for Maintaining records of parts 8

and priced
5 Source Code 9

6 Output 15

7 Tools and Technologies Used 16

8 Conclusion 17

9 Bibliography 18
 INTRODUCTION

This is a project based on Parking Management. The program helps usto

enter, display or alter the details of vehicles in parking records.

Moreover & most importantly the program helps us The program also
helps us to know the present status of a parking detail, vehicle detail etc.

It includes various function programs to do the above mentioned tasks.

Data file handling has been effectively used in the program.

The database is a collection of interrelated data to serve multiple

applications. That is database programs create files of information. Sowe
see that files are worked with most, inside the program.
 OBJECTIVES OF THE PROJECT

• To create an intelligent and scalable parking management systemthat

leverages computer science principles such as datastructures,
algorithms, machine learning, and real-time processing to effectively
manage parking spaces, optimize traffic flow,minimize congestion, and
provide a user-friendly interface forboth administrators and users

• To design and develop a comprehensive parking management

system utilizing Python and MySQL to efficiently manage parking spaces,
facilitate seamless vehiecle entry/exit, implement payment processing,
generate real-time reports, and optimiz overallparking space utilization.”
 FEASIBILITY OF STUDY

The objective of feasibility study is to determine whether the project

system feasible. The feasibility is determined in terms of three aspects.
These are: -

➤ Economic Feasibility:
The Project is absolutely economical as it doesn’t really require time
toSpend. It had he utmost concentration on making the project moreuser
friendly. Thereby, it is made possible that anyonewith a normal device
with Python and MYSQL in it can use it.

➤ Technical Feasibility:
The Project must be technical feasible as to ensure that the project is
proceeding or not. It is takenutmost care use an ensuring platform
Python and MYSQL which is both developable and technological. As the
technologies used are safe and user friendly, the project is technically
feasible

➤ Operational Feasibility:
The project is checked to ensure that it is user friendly and the software
meets all the needs of a person to use, makes it a operationally feasible
one .
DATABASE DETAILS
 SOURCE CODE OF PROJECT

Import os
Import platform
Import mysql.connector
Mydb=mysql.connector.connect(host=”localhost”,user=”root”,password
=”ro ot”,database=’parking’)
Mycursor=mydb.cursor() defAdd_Record():
L=[]
Id1=int(input(“Enter the parking number : “))
L.append(id1)
Pname1=input(“Enter the Parking Name: “)
L.append(pname1)
Level1=input(“Enter level of parking : “)
L.append(level1)
Freespace1=input(“Is there any freespace or not :YES/NO “)
L.append(freespace1)
Vehicleno1=input(“Enter the Vehicle Number : “)
L.append(vehicleno1)
Nod1=int(input(“Enter total number of days for parking: “))
L.append(nod1)
If nod1==1:

Payment1=20 elif
nod1==2:
Payment1=40 elif
nod1==3:
Payment1=60 elif
nod1==4:
Payment1=80 elif
nod1==5:
Payment1=100 elif
nod1==6:
Payment1=120

L.append(Payment1)
stud=(L)
Sql=’insert into
parkmaster12(pid,pnm,level,freespace,vehicleno,nod,payment)
values(%s,%s,%s,%s,%s,%s,%s)’ Mycursor.execute(sql,stud)
mydb.commit() defRec_View():
Print(“Select the search criteria : “)
print(“1. Parking Number”)
Print(“2. Parking Name”)

Print(“3. Level No”)

print(“4. All”)
Ch=int(input(“Enter the choice : “)) If
ch==1:
S=int(input(“Enter Parking no : “)) rl=(s,)
Sql=”select * from parkmaster12 where pid=%s”
mycursor.execute(sql,rl)
Res=mycursor.fetchall() elifch==2:
S=input(“Enter Parking Name : “)
rl=(s,)
Sql=”select * from parkmaster12 where pnm=%s”
mycursor.execute(sql,rl)
Res=mycursor.fetchall() elifch==3:
S=int(input(“Enter Level of Parking : “))
rl=(s,)
Sql=”select * from parkmaster12 where level=%s”
mycursor.execute(sql,rl)
Res=mycursor.fetchall() elifch==4:
Sql=”select * from parkmaster12” mycursor.execute(sql)
Res=mycursor.fetchall()
Print(“Details about Parking are as follows : “)
Print(“(Parking Id,ParkingName,Level,FreeSpace(Y/N),Vehicle No,No of
days for parking,Payment)”)
For x in res:
print(x)
Print(‘Task comple ted’) defVehicle_Detail():
L=[]
Vid1=int(input(“Enter Vehicle No : “))
L.append(vid1)
Vnm1=input(“Enter Vehicle Name/Model Name : “)
L.append(vnm1)
Dateofpur1=input(“Enter Year-Month-date of purchase : “)
L.append(dateofpur1)
Vdt=(L)
Sql=”insert into vehicle(pid,vnm,dateofpur) values(%s,%s,%s)”
mycursor.execute(sql,vdt) Mydb.commit() defVehicle_View():
Vid1=int(input(“Enter the vehicle number of the vehicle whose details
is to be viewed : “))
Sql=’select
parkmaster12.pid,parkmaster12.pnm,parkmaster12.vehicleno,
vehicle.pid,vehicle.vnm from parkmaster12 INNER JOIN vehicle ON
parkmaster12.pid=vehicle.pid and vehicle.pid=%s’

rl=(vid1,)
Print(‘The following are the detailes you wanted:’)
mycursor.execute(sql,rl) Res=mycursor.fetchall()
for x in res: Print(x)
 print(‘Task compelted’)
defremove():
Vid1=int(input(“Enter the vehicle number of the vehicle to be
deleted : “)) rl=(vid1,)
Sql=”Delete from vehicle where pid=%s” mycursor.execute(sql,rl)
Mydb.commit()
Print(‘Removed as per the command’) defMenu():
Print(“Enter 1 : To Add Parking Detail”)
print(“Enter 2 : To View Parking Detail “)
print(“Enter 3 : To Add Vehicle Detail “)
print(“Enter 4 : To Remove Vehicle Record”)
print(“Enter 5 : To see the details of Vehicle”)
Input_dt = int(input(“Please Select An Above
Option: “)) if(input_dt== 1):
Add_Record()
Elif (input_dt==2): Rec_View()
elif (input_dt==3): Vehicle_Detail()
elif (input_dt==4): Remove()
elif (input_dt==5):
Vehicle_View()
else:
Print(“Enter correct choice. “)
Menu() defrunAgain():
runAgn=input(‘\nwant to run Again Y/n:’)
while(runAgn.lower()==’y’):
if(platform.system()==’Windows’):
print(os.system(‘cls’))
else:
print(os.system(‘clear’))
Menu()
runAgn=input(‘\nwant to run Again Y/n:’) runAgain()
OUTPUT
 TOOLS AND TECHNOLOGIES USED

Hardware Requirements
I. Operating System: Windows 7 and
II. aboveProcessor: Any Processor
III. Ram: 4GB
IV. Hard dis: 300 MB and above
V. Monitor
VI. Keyboard and Mouse

Software Requirements
I. Windows OS
II. Python
III. MYSQL
IV. Notepad
 CONCLUSION

A well-designed parking management system in system offers

streamlined operations, efficient space utilization, enhanced user
experience, and improved revenue generation for parking facilities. By
leveraging technology, such a system optimizes parking space
allocation, implements user-friendly interfaces for booking and
payment, incorporates real-time monitoring and data analytics, and
ultimately contributes to a more sustainable and convenient urban
environment.
 BIBLIOGRAPHY

Textbooks:
Computer Science with python by SumitaArora
Computer Science with python by PreetiArora

Websites:
https://en.wikipedia.org/ http://python.mykvs.in/
19
20
21