DAV PUBLIC SCHOOL, DHORI

AISSCE EXAMINATION : 2024-25

COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

INDEX

1. Certificate

2. Acknowledgement

3. Introduction to Python

4. Introduction to MySQL

5. System Requirement Specification

6. System Development Life Cycle (SDLC)

7. Introduction to Project

8. Coding

9. Output

10. Bibliography
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

CERTIFICATE

This is to certify that __________________________________ of

Class ______ Roll No. ______________ in the Session

________________ of DAV Public School, Dhori has been

completed the project work on the topic “PARKING

MANAGEMENT SYSTEM”. He has taken proper care and shown

utmost sincerity in completion of this project.

I certify that this project is up to my expectation and as per

the guidelines issued by CBSE, New Delhi.

I wish him a grand success in future.

H.O.D. of Computer Science Principal

DAV Public School, Dhori DAV Public School, Dhori
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

ACKNOWLEDGEMENT

I sincerely thank Mr. Rajeev Kumar Ranjan, In-

charge of our Computer Department for his support
and guidance in completing the project in Python
on “PARKING MANAGEMENT SYSTEM”
successfully. I also thank Mr. Amitava Dasgupta,
Principal, DAV Public School, Dhori for his kind
support to add facilities for completing the project.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

INTRODUCTION TO PYTHON
Python is an interpreted, object-oriented, high-level programming language with dynamic
semantics. Its high-level built in data structures, combined with dynamic typing and dynamic
binding; make it very attractive for Rapid Application Development, as well as for use as a
scripting or glue language to connect existing components together. Python's simple, easy to
learn syntax emphasizes readability and therefore reduces the cost of program maintenance.
Python supports modules and packages, which encourages program modularity and code
reuse. The Python interpreter and the extensive standard library are available in source or
binary form without charge for all major platforms, and can be freely distributed.
History of Python:
Python is a widely used general-purpose, high-level programming language. It was initially
designed by Guido van Rossum in 1991 and developed by Python Software Foundation. It
was mainly developed for emphasis on code readability, and its syntax allows programmers
to express concepts in fewer lines of code.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

INTRODUCTION TO MYSQL
MySQL is an open-source, fast reliable, and flexible relational database management
system used for managing the relational database. It is open-source database software,
which is supported by Oracle Company. It is fast, scalable, and easy to use database
management system in comparison with Microsoft SQL Server and Oracle Database. It is
commonly used in conjunction with PHP scripts for creating powerful and dynamic
server-side or web-based enterprise applications.

MySQL is a Relational Database Management System (RDBMS) software that provides

many things, which are as follows:
 It allows us to implement database operations on tables, rows, columns, and indexes.
 It defines the database relationship in the form of tables (collection of rows and
columns), also known as relations.
 It provides the Referential Integrity between rows or columns of various tables.
 It allows us to updates the table indexes automatically.
 It uses many SQL queries and combines useful information from multiple tables for
the end-users.
MySQL follows the working of Client-Server Architecture. This model is designed for
the end-users called clients to access the resources from a central computer known as a
server using network services. Here, the clients make requests through a graphical user
interface (GUI), and the server will give the desired output as soon as the instructions are
matched. The process of MySQL environment is the same as the client-server model.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

SYSTEM REQUIREMENT SPECIFICATION

HARDWARE REQUIREMENT:

 Printer- to print the required documents of the project.

 Compact Drive
 Proccesor: Pentium III and above
 RAM: 256 MB(minimum)
 Hard-Disk : 20 GB(minimum)

SOFTWARE REQUIREMENT:

 Windows 7 or higher.
 My-SQL server 5.5 or higher(as backend).
 Python idle 3.6 or higher or spyder (as frontend).
 Microsoft Word 2010 or higher for documentation.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

SYSTEM DEVELOPMENT LIFECYCLE

Purpose

The purpose of an SDLC methodology is to provide IT Project Managers with the tools to
help ensure successful implementation of systems that satisfy University strategic and
business objectives. The documentation provides a mechanism to ensure that executive
leadership, functional managers and users sign-off on the requirements and implementation
of the system. The process provides University Project Managers with the visibility of design,
development, and implementation status needed to ensure delivery on time and within
budget.

Scope

This Guideline applies to all major application projects, both new applications and upgrades
of existing applications.

Goals

The goals of this SDLC approach are to:

 Deliver quality systems which meet or exceed customer expectations when promised and
within cost estimates.

 Provide a framework for developing quality systems using an identifiable, measurable,

and repeatable process.

 Establish a project management structure to ensure that each system development project
is effectively managed throughout its life cycle.

 Identify and assign the roles and responsibilities of all involved parties, including
functional and technical managers, throughout the system development life cycle.

 Ensure that system development requirements are well defined and subsequently
satisfied.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

Objectives

The SDLC methodology will help to achieve these goals by:

 Establishing appropriate levels of management authority to provide timely direction,

coordination, control, review, and approval of the system development project.

 Ensuring project management accountability.

 Documenting requirements and maintaining trace ability of those requirements

throughout the development and implementation process.

 Ensuring that projects are developed within the current and planned information
technology infrastructure.

 Identifying project risks early

Guidelines & Procedures

A software application typically undergoes several development lifecycles, corresponding to

its creation and subsequent upgrades. Each such development lifecycle constitutes a project.
Such projects continue until the underlying technology ages to the point where it is no longer
economical to invest in upgrades and the application is considered for either continued as-is
operation or retirement.

The SDLC Phases

SDLC includes six phases, during which defined work products and documents are created,
reviewed, refined, and approved. Not every project will require that the phases be
subsequently executed and may be tailored to accommodate the unique aspects of a projects.
These phases are described in more detail in the following paragraphs.

Initiation Phase
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

The Initiation Phase begins when management determines that it is necessary to enhance a
business process through the application of information technology. The purposes of the
Initiation Phase are to:

 Identify and validate an opportunity to improve business accomplishments of the

University or a deficiency related to a business need

 Identify significant assumptions and constraints on solutions to that need

 Recommend the exploration of alternative concepts and methods to satisfy the need.

Feasibility Phase

The Feasibility Phase is the initial investigation, or brief study of the problem to determine
whether the systems project should be pursued. A feasibility study established the context
through which the project addresses the requirements expressed in Business Case and
investigates the practicality of a proposed solution. The feasibility study is used to determine
if the project should get the go-ahead. If the project is to proceed, the feasibility study will
produce a project plan and budget estimates for the future stages of development.

Requirements Analysis Phase

This phase formally defines the detailed functional user requirements using high-level
requirements identified in the Initiation and Feasibility Phases. The requirements are defined
in this phase to a level of detail sufficient for systems design to proceed. They need to be
measurable, testable, and relate to the business need or opportunity identified in the Initiation
Phase.

The purposes of this phase are to:

 Complete business process reengineering of the functions to be supported, e.g., verify

what information drives the business process, what information is generated, who
generates it, where does the information go, and who processes it.

 Develop detailed data and process models including system inputs and outputs.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

 Develop the test and evaluation requirements that will be used to determine acceptable
system performance.

Design Phase

During this phase, the system is designed to satisfy the functional requirements identified in
the previous phase. Since problems in the design phase can be very expensive to solve in later
stages of the software development, a variety of elements are considered in the design to
mitigate risk. These include:

 Identifying potential risks and defining mitigating design features

 Performing a security risk assessment

 Developing a conversion plan to migrate current data to the new system

 Determining the operating environment

 Defining major subsystems and their inputs and outputs

 Allocating processes to resources

Development Phase

Effective completion of the previous stages is a key factor in the success of the Development
phase. The Development phase consists of:

 Translating the detailed requirements and design into system components

 Testing individual elements (units) for usability

 Preparing for integration and testing of the IT system.

Integration, system, security, and user acceptance testing is conducted during this phase as
well. The user, with those responsible for quality assurance, validates that the functional
requirements are met by the newly developed or modified system.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

Implementation Phase

This phase is initiated after the system has been tested and accepted by the user. In this phase,
the system is installed to support the intended business functions. System performance is
compared to performance objectives established during the planning phase. Implementation
includes user notification, user training, installation of hardware, installation of software onto
production computers, and integration of the system into daily work processes. This phase
continues until the system is operating in production in accordance with the defined user
requirements.

Operations and Maintenance

The system operation is ongoing. The system is monitored for continued performance in
accordance with user requirements and needed system modifications are incorporated.
Operations continue as long as the system responds to the organization’s needs. When
modifications are identified, the system may reenter the planning phase.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

INTRODUCTION TO THE PROJECT

INTRODUCTION

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.

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.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

 There is an easier facade integration since there are no ramping floors or openings in
exterior walls.

Limitations of Project

 There is a greater construction cost per space (but this may be offset by the chance for
lesser land costs per space and the system manufacturers say that the operating and
maintenance cost will be lower as compared to a conventional ramped parking structure).
 Use of redundant systems will result in a greater cost.
 It may be a bit confusing for unfamiliar users.
 It is not recommended for high peak hour volume facilities.
 There may be a fear of breakdown (How do I get my car out?).
 There is an uncertain building department review and approval process.
 It requires a maintenance contract with the supplier.
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

PROGRAM CODE
import os
import platform
import [Link]
mydb=[Link](host="localhost",user="root",pass
word="root",database='parking')
mycursor=[Link]()
def Add_Record():
L=[]
id1=int(input("Enter the parking number : "))
[Link](id1)
pname1=input("Enter the Parking Name: ")
[Link](pname1)
level1=input("Enter level of parking : ")
[Link](level1)
freespace1=input("Is there any freespace or not :YES/NO ")
[Link](freespace1)
vehicleno1=input("Enter the Vehicle Number : ")
[Link](vehicleno1)
nod1=int(input("Enter total number of days for parking:
"))
[Link](nod1)
if nod1==1:
Payment1=20
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

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

[Link](Payment1)
stud=(L)
sql='insert into
parkmaster12(pid,pnm,level,freespace,vehicleno,nod,payment)
values(%s,%s,%s,%s,%s,%s,%s)'
[Link](sql,stud)
[Link]()
def Rec_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"
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

[Link](sql,rl)
res=[Link]()
elif ch==2:
s=input("Enter Parking Name : ")
rl=(s,)
sql="select * from parkmaster12 where pnm=%s"
[Link](sql,rl)
res=[Link]()
elif ch==3:
s=int(input("Enter Level of Parking : "))
rl=(s,)
sql="select * from parkmaster12 where level=%s"
[Link](sql,rl)
res=[Link]()
elif ch==4:
sql="select * from parkmaster12"
[Link](sql)
res=[Link]()
print("Details about Parking are as follows : ")
print("(Parking Id,Parking
Name,Level,FreeSpace(Y/N),Vehicle No,No of days for
parking,Payment)")
for x in res:
print(x)
print('Task comple ted')
def Vehicle_Detail():
L=[]
vid1=int(input("Enter Vehicle No : "))
[Link](vid1)
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

vnm1=input("Enter Vehicle Name/Model Name : ")

[Link](vnm1)
dateofpur1=input("Enter Year-Month-date of purchase : ")
[Link](dateofpur1)
vdt=(L)
sql="insert into vehicle(pid,vnm,dateofpur)
values(%s,%s,%s)"
[Link](sql,vdt)
[Link]()
def Vehicle_View():
vid1=int(input("Enter the vehicle number of the vehicle
whose details is to be viewed : "))
sql='select
[Link],[Link],[Link],
[Link],[Link] from parkmaster12 INNER JOIN vehicle
ON [Link]=[Link] and [Link]=%s'
rl=(vid1,)
print('The following are the detailes you wanted:')
[Link](sql,rl)
res=[Link]()
for x in res:
print(x)
print('Task compelted')
def remove():
vid1=int(input("Enter the vehicle number of the vehicle to
be deleted : "))
rl=(vid1,)
sql="Delete from vehicle where pid=%s"
[Link](sql,rl)
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

[Link]()
print('Removed as per the command')
def Menu():
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()
def runAgain():
runAgn=input('\nwant to run Again Y/n:')
while([Link]()=='y'):
if([Link]()=='Windows'):
print([Link]('cls'))
else:
print([Link]('clear'))
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

Menu()
runAgn=input('\nwant to run Again Y/n:')
runAgain()

OUTPUT
DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM
DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM
 DAV PUBLIC SCHOOL, DHORI
AISSCE EXAMINATION : 2024-25
COMPUTER SCIENCE (083) PROJECT
PARKING MANAGEMENT SYSTEM

BIBLIOGRAPHY

BOOKS:

 COMPUTER SCIENCE WITH PYTHON-BY SUMITA ARORA

 COMPUTER SCIENCE WITH PYTHON-BY PREETI ARORA
 PYTHON COOKBOOK

WEBSITES:

 [Link]
 [Link]
 [Link]