10/20/24, 11:14 AM 436357274 Parking Management System
PYTHON PROJECT
PARKING MANAGEMENT SYSTEM
SUBMITTED BY- Mr.Alok Patil
Mr.Mohit Patel
about:blank 1/21
10/20/24, 11:14 AM 436357274 Parking Management System
Acknowledgement
I , S .KARTHIKEYAN of class XIITH A roll no 12127
would like to express my sincere gratitude to my
computer science teacher Ms.APARNA DHIRDE,PGT
COMPUTER SCIENCE, for her vital support, guidance and
encouragement –
without which this project would not have come forth.
I would also like to express my gratitude to my school
KENDRIYA VIDYALAYA AMBARNATH for letting me use
the school
laboratory.
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 2/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 3/21
10/20/24, 11:14 AM 436357274 Parking Management System
This is a project based on Parking Management. The
program helps us to 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. So we see that files are worked with most, inside
the program.
DBMS
The software required for the management of data is called
as DBMS. It has 3 models
• Relation model
• Hierarchical model
• Network model
RELATIONAL MODEL It’s based on the concept on
relation. Relation is the table that consists of rows and columns.
The rows of the table are called tuple and the columns of the
table are called attribute. Numbers of rows in the table is
called as cardinality. Number of columns in the table is called as
degree.
about:blank
10/20/24, 11:14 AM 436357274 Parking Management System
4/21
10/20/24, 11:14 AM 436357274 Parking Management System
HIERARCHICAL MODEL: In this type of model, we have
multiple records for each record. A particular record has one
parent
record. No chide record can exist without parent record. In
this, the records are organized in tree (like structure
NETWORK MODEL:- In this, the data is represented by
collection of records and relationship is represented by (ink or
association.
CHARACTERISTICS OF DB MS: -
• It reduces the redundancy
• Reduction of data in inconsistency
• Data sharing
• Data standardization
DIFFERENT TYPES OF FILES: -BASED ON ACCESS:-
• Sequential file
• Serial file
• Random (direct access) file BASED ON STORAGE:-
• Text file
• Binary File
Need Of Computerization
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 5/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 6/21
10/20/24, 11:14 AM 436357274 Parking Management System
Software & Hardware
Requirement
SOFTWARE SPECIFICATION: -
Operating System: Windows 7
Platform: Python IDLE 3.7
Database: MySQL
Language: Python
HARDWARE SPECIFICATION: -
Processor: Dual Core & Above
Hard Disk: 40GB
RAM: 1024MB
Note: For Python-MySQL connectivity, following data have
been used:-
Host- localhost, user- root, password- root, database- school
about:blank 7/21
10/20/24, 11:14 AM 436357274 Parking Management System
Advantages Of Project
. There is a greater sense of security due to the fact that
patrons do not actually walk to and from their own space.
. It is highly feasible for extremely small sites that are unable
to accommodate a conventional ramped parking structure.
. There is high parking efficiency (i.e. sf/space and cf/space).
. There is no need for driving while looking for an available
space.
. Emissions are greatly brought down and reduced.
. The patrons wait for their car in a highly
controlled environment.
. There are less chances for vehicle vandalism.
. There is a minimal staff requirement if it is used by
known parkers.
. It is possible that the retrieval time is lower than
the combined driving/parking/walking time in
conventional ramped parking
structures. There is an easier facade integration since
there are no ramping floors or openings in exterior walls.
about:blank 8/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 9/21
10/20/24, 11:14 AM 436357274 Parking Management System
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:
about:blank 10/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 11/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 12/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 13/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 14/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 15/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 16/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 17/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 18/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 19/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 20/21
10/20/24, 11:14 AM 436357274 Parking Management System
about:blank 21/21
