A Project Report On
VEHICLE PARKING MANAGEMENT SYSTEM
Submitted in Partial Fulfillment of the Requirements of
SSCE – Senior School Certificate Examination
2025 – 2026
In
Computer Science (083)
By
ABBHINAV.V.R
Under the Guidance of
[Link] [Link].(Software Engineering)
PGT – COMPUTER SCIENCE
Department of Computer Science
SAKTHI VINAYAKAR HINDU VIDYALAYA
CBSE Sr. Sec. School, Thoothukudi.
Department of Computer Science
SAKTHI VINAYAKAR HINDU VIDYALAYA
CBSE Sr. Sec. School, Thoothukudi.
CERTIFICATE
This is to certify that the work contained in the project titled VEHICLE
PARKING MANAGEMENT SYSTEM by ABBHINAV.V.R has been
carried out under my supervision and that this work has not been submitted
elsewhere for a SSCE.
Date:
Register No:
Signature of Internal Signature of External Signature of Principal
Examiner Examiner
ACKNOWLEDGEMENT
In the accomplishment of this project successfully, many people have owned upon me
their blessings and the heart pledged support, this time I am utilizing to thank all the
people who have been concerned with this project.
I would like to thank my Computer Science teacher [Link], [Link].(Software
Engineering), whose valuable guidance has been the ones that helped me to patch this
project and make it full proof success. Her suggestions and her instructions have served
as the major contribution towards the completion of the project.
I express my deep sense of gratitude to the luminary, Our Principal
[Link], M.A., [Link]., [Link]., who have been continuously motivating us.
Then I would like to thank my parents, friends and classmates who have helped me with
their valuable suggestions and guidance which have been helpful in various phases of the
project. I am grateful for their constant support and help.
INDEX
[Link]. TOPICS Page No.
1 INTRODUCTION 01
2 OBJECTIVE OF THE PROJECT 01
3 PROPOSED SYSTEM 01
4 HARDWARE REQUIREMENTS 02
5 SOFTWARE REQUIREMENTS 02
6 MySQL TABLE STRUCTURE 02
7 TABLE CREATED IN MySQL 04
8 SOURCE CODE 05
9 OUTPUT 09
10 FUTURE ENHANCEMENT 11
11 CONCLUSION 11
12 BIBLIOGRAPHY 11
1. INTRODUCTION:
Vehicle Parking Management System is a Python and MySQL based application designed
to manage vehicle parking records efficiently.
In places like schools, offices, malls, and apartments, maintaining parking details
manually can lead to confusion, data loss, and time consumption.
This system automates the process of recording vehicle entry and exit details, parking slot
allocation, and fee management, making parking operations simple, fast, and reliable.
2. OBJECTIVE OF THE PROJECT:
The objectives of the Vehicle Parking Management System are:
To maintain vehicle parking records systematically
To reduce manual work and paperwork
To store vehicle details securely in a database
To allow easy insertion, display, search, and deletion of records
To demonstrate Python–MySQL connectivity
To develop a menu-driven program as per CBSE syllabus
3. PROPOSED SYSTEM:
The proposed system is a menu-driven Python application connected to a MySQL
database.
Main Features:
Add vehicle entry details
Display all parked vehicles
Search vehicle by vehicle number
Delete vehicle record on exit
Simple and user-friendly interface
Secure data storage using MySQL
1
4. HARDWARE REQUIREMENTS:
Processor: Intel i3 or higher
RAM: Minimum 4 GB
Hard Disk: 20 GB free space
Keyboard and Mouse
Monitor
5. SOFTWARE REQUIREMENTS:
Operating System: Windows 10 / Linux
Programming Language: Python 3.x
Database: MySQL
Python Module: mysql-connector-python
IDE: IDLE / PyCharm / VS Code
6. MYSQL TABLE STRUCTURE:
Database Name: parkingdb
Field Name Data Type Description
vehicle_no VARCHAR(15) (PK) Vehicle Registration Number
owner_name VARCHAR(30) Owner Name
vehicle_type VARCHAR(15) Car / Bike
entry_time VARCHAR(10) Entry Time
slot_no INT Parking Slot Number
Parking Slot Details
Purpose: To store parking slot availability information.
2
Field Name Data Type Description
slot_no INT (PRIMARY) Parking Slot Number
slot_type VARCHAR(10) Car / Bike
status VARCHAR(10) Occupied / Free
Parking Fee Details
Purpose: To calculate parking charges based on vehicle type.
Field Name Data Type Description
vehicle_type VARCHAR(10) Car / Bike
charge_per_hr INT Parking Fee per Hour
Vehicle Exit Details
Purpose: To maintain exit and billing records.
Field Name Data Type Description
vehicle_no VARCHAR(15) Vehicle Number
exit_time VARCHAR(10) Exit Time
total_hours INT Total Parked Hours
total_fee INT Total Parking Fee
3
7. TABLE CREATED IN MYSQL:
CREATE DATABASE parkingdb;
USE parkingdb;
CREATE TABLE parking (
vehicle_no VARCHAR(15) PRIMARY KEY,
owner_name VARCHAR(30),
vehicle_type VARCHAR(15),
entry_time VARCHAR(10),
slot_no INT
);
CREATE TABLE slots (
slot_no INT PRIMARY KEY,
slot_type VARCHAR(10),
status VARCHAR(10)
);
CREATE TABLE parking_fee (
vehicle_type VARCHAR(10) PRIMARY KEY,
charge_per_hr INT
);
CREATE TABLE exit_details (
vehicle_no VARCHAR(15),
exit_time VARCHAR(10),
total_hours INT,
total_fee INT
);
4
8. SOURCE CODE (PYTHON + MYSQL):
import [Link]
# Database connection
con = [Link](
host="localhost",
user="root",
password="root",
database="parkingdb"
)
cur = [Link]()
# ---------------- FUNCTIONS ----------------
def add_vehicle():
vno = input("Enter Vehicle Number: ")
name = input("Enter Owner Name: ")
vtype = input("Enter Vehicle Type (Car/Bike): ")
time = input("Enter Entry Time: ")
slot = int(input("Enter Slot Number: "))
[Link](
"INSERT INTO parking VALUES (%s,%s,%s,%s,%s)",
(vno, name, vtype, time, slot)
)
[Link](
"UPDATE slots SET status='Occupied' WHERE slot_no=%s",
(slot,)
)
[Link]()
print("Vehicle Entry Added Successfully")
5
def display_vehicles():
[Link]("SELECT * FROM parking")
for row in [Link]():
print(row)
def display_slots():
[Link]("SELECT * FROM slots")
print("Slot No | Slot Type | Status")
print("-----------------------------")
for row in [Link]():
print(row[0], " | ", row[1], " | ", row[2])
def search_vehicle():
vno = input("Enter Vehicle Number to Search: ")
[Link]("SELECT * FROM parking WHERE vehicle_no=%s", (vno,))
data = [Link]()
if data:
print(data)
else:
print("Vehicle Record Not Found")
def vehicle_exit():
vno = input("Enter Vehicle Number: ")
exit_time = input("Enter Exit Time: ")
hours = int(input("Enter Total Hours Parked: "))
[Link]("SELECT vehicle_type, slot_no FROM parking WHERE vehicle_no=%s",
(vno,))
data = [Link]()
if data:
6
vtype, slot = data
[Link]("SELECT charge_per_hr FROM parking_fee WHERE
vehicle_type=%s", (vtype,))
rate = [Link]()[0]
fee = rate * hours
[Link](
"INSERT INTO exit_details VALUES (%s,%s,%s,%s)",
(vno, exit_time, hours, fee)
)
[Link]("DELETE FROM parking WHERE vehicle_no=%s", (vno,))
[Link]("UPDATE slots SET status='Free' WHERE slot_no=%s", (slot,))
[Link]()
print("Vehicle Exit Recorded Successfully")
print("Total Parking Fee: Rs.", fee)
else:
print("Vehicle Not Found")
def display_exit_details():
[Link]("SELECT * FROM exit_details")
for row in [Link]():
print(row)
# ---------------- MAIN MENU ----------------
while True:
print("\n--- VEHICLE PARKING MANAGEMENT SYSTEM ---")
print("1. Add Vehicle Entry")
7
print("2. Display Parked Vehicles")
print("3. Display Parking Slots")
print("4. Search Vehicle")
print("5. Vehicle Exit & Fee")
print("6. Display Exit Details")
print("7. Exit")
ch = int(input("Enter your choice: "))
if ch == 1:
add_vehicle()
elif ch == 2:
display_vehicles()
elif ch == 3:
display_slots()
elif ch == 4:
search_vehicle()
elif ch == 5:
vehicle_exit()
elif ch == 6:
display_exit_details()
elif ch == 7:
break
else:
print("Invalid Choice")
[Link]()
8
9. OUTPUT:
Main Menu
--- VEHICLE PARKING MANAGEMENT SYSTEM ---
1. Add Vehicle Entry
2. Display Parked Vehicles
3. Search Vehicle
4. Delete Vehicle (Exit)
5. Exit
Add Vehicle Entry
Enter Vehicle Number: TN09AB1234
Enter Owner Name: Ramesh
Enter Vehicle Type (Car/Bike): Car
Enter Entry Time: 10:30 AM
Enter Slot Number: 12
Vehicle Entry Added Successfully
Display Parked Vehicles
('TN09AB1234', 'Ramesh', 'Car', '10:30 AM', 12)
Search Vehicle
('TN09AB1234', 'Ramesh', 'Car', '10:30 AM', 12)
Delete Vehicle
Vehicle Record Deleted Successfully
Display Parking Slot Details
Input:
Enter your choice: Display Slots
Output:
9
Slot No | Slot Type | Status
-----------------------------
1 | Car | Free
2 | Car | Occupied
3 | Bike | Free
4 | Bike | Occupied
Display Parking Fee Details
Input:
Enter your choice: Display Parking Fee
Output:
Vehicle Type | Charge per Hour
------------------------------
Car | 50
Bike | 20
Vehicle Exit and Fee Calculation
Input:
Enter Vehicle Number: TN09AB1234
Enter Exit Time: 01:30 PM
Enter Total Hours Parked: 3
Output:
Vehicle Exit Recorded Successfully
Total Parking Fee: Rs. 150
Display Exit Records
Input:
Enter your choice: Display Exit Details
Output:
('TN09AB1234', '01:30 PM', 3, 150)
10
Slot Status Updated
Output:
Slot Number 12 is now marked as Free
Invalid Search
Input:
Enter Vehicle Number to Search: TN01XY9999
Output:
Vehicle Record Not Found
10. FUTURE ENHANCEMENT
Add parking fee calculation
Add entry and exit time difference
GUI using Tkinter
User login system
Automatic slot allocation
Report generation
11. CONCLUSION:
The Vehicle Parking Management System successfully automates the management of
parking records using Python and MySQL.
It reduces manual effort, improves accuracy, and ensures secure data storage.
This project fulfills the CBSE Grade 12 Computer Science practical requirements and
enhances understanding of database applications.
12. BIBLIOGRAPHY
NCERT Computer Science Textbook
[Link]
[Link]
[Link]
11