Mini Project Report
On
“Car Rental System”
Submitted By
Aniket Kamble B-14
Aniket Londhe B-31
Prajval Kamble A-52
Under the
guidance
of
Prof. [Link]
DEPARTMENT OF Artificial Intelligence And Data Science
GENBA SOPANRAO MOZE COLLEGE OF
ENGINEERING, BALEWADI, PUNE-411041
SAVITRIBAI PHULE PUNE
UNIVERSITY [Year:2025-
2026]
1
CERTIFICATE
This is to certify that the mini project report entitles
“Car Rental System”
Submitted by
Devraj Kanki B-01
Ravindra Bedade A-11
Prajval Kamble A-52
has successfully completed his/her Project work on “Car Rental System” at Genba
Sopanrao Moze College of Engineering, Balewadi, Pune in the partial fulfillment of
Bachelor’s Degree in Artificial Intelligence And Data Science
Prof. [Link] Prof. Dr. Nilesh Suryawanshi
Guide, Head,
Department of Artificial Intelligence And Data Science Department of Artificial Intelligence And Data Science
Dr. Ratnaraj Kumar
Jambi Principal,
Genba Sopanrao Moze College of Engineering Pune – 45
Place :
Pune Date :
2
ACKNOWLEDGEMENT
It gives us immense pleasure to present this Mini Project report as part of the curriculum of
[Link] Intelligence And Data Science. This work would not have been possible without the
guidance, encouragement, and support we received from several individuals.
We are deeply grateful to our guide, [Link],for her valuable guidance, constant
encouragement, and constructive suggestions throughout the completion of this project. Her expertise and
support have been a great source of inspiration.
We also extend our sincere thanks to our Head of Department, Prof. Dr. Nilesh Suryawanshi, for
her continuous support, motivation, and for providing us with the necessary facilities to carry out
this work successfully.
We take this opportunity to express our gratitude to all the faculty members and staff of the
Department of Artificial Intelligence And Data Science , Genba Sopanrao Moze College of
Engineering, for their cooperation and assistance.
Devraj Kanki B-01
Ravindra Bedade A-11
Prajval kamble A-52
3
LIST OF FIGURES
Figure No. Figure Name Page No.
1. System Architecture 11
2. ER Diagram 11
3. Frontend Outputs 18
4. PhpMyAdmin 20
5. Test Data Connection API 22
4
LIST OF TABLES
Table No. Table Name Page No.
1 Booking 20
2 Cars 20
3 Cars Management 21
4 Bookings Management 21
5
ABSTRACT
The Car Rental System is a web-based application developed using HTML5, CSS3, and
JavaScript for the frontend, [Link] with [Link] for the backend, and MySQL as the database
management system. The system provides a comprehensive platform for customers to browse
available cars, make bookings, and for administrators to manage the entire rental operations.
This system addresses the challenges of traditional car rental processes by offering an
automated, user-friendly interface that streamlines vehicle selection, booking management, and
customer administration. Customers can easily view available cars with detailed specifications,
check rental prices, and make online bookings with real-time price calculation. Administrators
have full control over car inventory, booking management, and customer data with search, edit,
and delete functionalities.
Furthermore, the system ensures data accuracy. It also enhances user experience with
dynamic content rendering and optimized page performance. The application is scalable and can
be easily integrated with third-party payment gateways and cloud-based services for future
expansion. The overall goal of this project is to provide a reliable, efficient, and secure digital
platform that simplifies the car rental process for both customers and administrators, reducing
manual effort while improving operational transparency and convenience.
6
TABLE OF CONTENTS
A CERTIFICATE 2
B ACKNOWLEDGMENT 3
C LIST OF FIGURES 4
D LIST OF TABLES 5
E ABSTRACT 6
1 INTRODUCTION 8
2 PROBLEM DEFINITION AND SCOPE 9
2.1 Problem Definition 9
2.2 Scope 10
3 SYSTEM OVERVIEW 11
3.1 System Architecture 11
3.2 ER Diagram 11
4 PROGRAM & OUTPUTS 12
4.1 Program 12
4.2 Output 14
5 DATABASE CONNECTIVITY 15
5.1 CMD 15
5.2 PhpMyAdmin 16
5.3 Admin Panel 16
6 CONNECTION API 17
7 CONCLUSION 18
8 REFERENCES 19
7
Introduction to Car Rental System
The Car Rental System is a comprehensive web-based application developed
using modern full-stack technologies including HTML5, CSS3, JavaScript for the
frontend, [Link] with [Link] framework for the backend server, and MySQL as
the relational database management system. The primary objective of this system is
to digitalize and streamline the entire car rental process, providing an efficient
platform for both customers and administrators.
In traditional car rental businesses, operations are often manual and paper-
based, leading to inefficiencies, booking errors, inventory mismanagement, and poor
customer experience. This system eliminates these challenges by offering a digital
solution that automates key processes including vehicle browsing, availability
checking, online booking, price calculation, and administrative management.
Built with a three-tier architecture, the system ensures clear separation of concerns:
1. Presentation Layer (Frontend) - Responsive web interfaces built with HTML,
CSS, and JavaScript
2. Business Logic Layer (Backend) - RESTful APIs handling business rules and
data processing using [Link] and [Link]
3. Data Layer (Database) - Secure and structured data storage using MySQL
with proper relationships
4. Key features include real-time price calculation, booking management, admin
panel with CRUD operations, search functionality, and a responsive design
that works across various devices. The system demonstrates practical
implementation of web development concepts and provides a foundation for
scalable car rental operations.
8
Problem Definition
The car rental industry traditionally relies on manual processes and legacy systems that
present numerous challenges for both businesses and customers. Conventional rental operations
involve physical paperwork, manual availability checks, price calculations, and booking
management, leading to several significant problems:
Inefficient Booking Process: Customers need to visit rental offices physically or make
phone calls to check availability and prices, resulting in time consumption and potential
miscommunication.
Inventory Management Issues: Rental companies struggle to maintain accurate real-time
information about car availability, leading to double bookings or unavailability despite
reservations.
Manual Price Calculation: Rental costs calculated manually based on duration and car types
are prone to errors and inconsistencies.
Data Management Challenges: Difficulty in tracking booking history, customer preferences,
and generating reports for business analysis.
The Car Rental System addresses these challenges by providing an automated, web-based
solution that streamlines the entire rental process from vehicle selection to booking management
and administrative control.
Furthermore, the proposed system minimizes human intervention by automating price
calculations, availability checks, and record maintenance. It provides real-time access to vehicle
data, allowing users to make informed booking decisions efficiently. The system also enables
administrators to manage cars, customers, and bookings through an interactive dashboard.
9
Scope of the project
The Car Rental System is a web-based application with comprehensive functionality covering
both customer-facing and administrative operations:
Functional Scope:
Customer Module:
Browse available cars with detailed specifications and images
View car details including type, seating capacity, transmission, and pricing
Calculate rental costs based on selected dates
Make online bookings with personal information
Real-time availability checking
Admin Module:
View and manage complete car inventory
Access all booking records with customer details
Edit booking information and customer data
Delete bookings and manage records
Search functionality for specific bookings
Monitor rental operations and status
The system provides a solid foundation for future enhancements including user
authentication, payment gateway integration, advanced reporting, mobile application
development, and multi-branch support.
10
Architecture/ER diagram
System Architecture:
Er diagram:
Program and output
Car_rental.sql:
-- Create database
CREATE DATABASE IF NOT EXISTS car_rental_db;
USE car_rental_db;
-- Create cars table
CREATE TABLE IF NOT EXISTS cars (
id INT AUTO_INCREMENT PRIMARY KEY,
model VARCHAR(255) NOT NULL,
type VARCHAR(100) NOT NULL,
seats INT NOT NULL,
transmission VARCHAR(50) NOT NULL,
price_per_day DECIMAL(10, 2) NOT NULL,
available BOOLEAN DEFAULT TRUE,
image_url VARCHAR(500)
);
-- Create bookings table
CREATE TABLE IF NOT EXISTS bookings (
id INT AUTO_INCREMENT PRIMARY KEY,
car_id INT,
customer_name VARCHAR(255) NOT NULL,
customer_email VARCHAR(255) NOT NULL,
customer_phone VARCHAR(20) NOT NULL,
pickup_date DATE NOT NULL,
return_date DATE NOT NULL,
total_price DECIMAL(10, 2) NOT
NULL,
booking_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
status ENUM('pending', 'confirmed', 'completed', 'cancelled') DEFAULT 'pending',
FOREIGN KEY (car_id) REFERENCES cars(id)
);
-- Insert cars (from your phpMyAdmin table with images)
INSERT INTO cars (model, type, seats, transmission, price_per_day, available, image_url) VALUES
('Audi A6', 'Luxury Sedan', 5, 'Automatic', 7500.00, TRUE, '[Link]
content/uploads/2019/10/[Link]'),
('Hyundai Creta', 'SUV', 5, 'Automatic', 2500.00, TRUE, '[Link]
images/gallery/hyundai/creta/exterior/[Link]'),
('BMW 3 Series', 'Luxury Sedan', 5, 'Manual', 8300.00, TRUE,
'[Link]
g'),
('Mercedes-Benz C-Class', 'Luxury Sedan', 5, 'Automatic', 8000.00, TRUE,
'[Link]
('Mahindra XUV700', 'SUV', 7, 'Automatic', 3500.00, TRUE,
'[Link] 8India
%29_front_view.png'),
('TATA Nexon', 'Compact SUV', 5, 'Manual', 2500.00, TRUE,
12
'[Link]
ms%2Farticles%2F2024%2F4%2F3212698%2FTata_Nexon_Diesel_MT_22_d3246c75bd.jpg&
w=3840&q=75'),
('Toyota Innova Crysta', 'MPV', 7, 'Automatic', 3750.00, TRUE, '[Link]
content/uploads/2024/05/[Link]'),
('Maruti Suzuki Dzire', 'Sedan', 5, 'Automatic', 2500.00, TRUE,
'[Link]
[Link]'),
('Tesla Model 3', 'Electric', 5, 'Automatic', 11000.00, TRUE,
'[Link]
[Link]?v=1733570691');
-- Sample bookings (can keep same or adjust IDs based on car list above)
INSERT INTO bookings (car_id, customer_name, customer_email, customer_phone, pickup_date,
return_date, total_price, status) VALUES
(1, 'Sanket Patil', 'sanketp@[Link]', '555-1234', '2025-06-15', '2025-06-18', 22500.00,
'completed'),
(3, 'Aniket Kamble', 'aniketk@[Link]', '555-5678', '2025-06-20', '2025-06-25', 41500.00,
'confirmed'),
(5, 'Aniket Londhe', 'londhe@[Link]', '555-9012', '2025-07-01', '2025-07-07', 21000.00,
'pending');
13
Outputs/Frontend:
Database Connectivity/Admin Panel:
CMD:
PhpMyAdmin:
15
Admin Panel:
16
Test data Connection API:
Car API response:
Booking API response:
17
Conclusion:
The Car Rental System successfully demonstrates the implementation of a complete web-
based rental management solution using modern full-stack technologies. The system effectively
addresses the challenges of traditional car rental operations by providing an automated, efficient,
and user-friendly platform.
Key achievements of the project include:
Streamlined Rental Process: Customers can easily browse available vehicles, check
specifications, calculate costs, and make bookings through an intuitive interface.
Efficient Administration: Comprehensive admin panel enables effective management of
cars, bookings, and customer data with full CRUD operations and search capabilities.
Responsive Design: Modern UI/UX that works seamlessly across different devices and
screen sizes.
Overall, the Car Rental System represents a significant improvement over manual rental
processes, offering efficiency, accuracy, and enhanced customer experience while demonstrating
the effective application of full-stack web development technologies in solving real-world business
problems.
18
References:
1. [Link] Documentation, [Link]
2. MySQL Documentation, [Link]
3. MDN Web Docs, [Link]
4. [Link] Documentation, [Link]
5. W3Schools Web Development Guides, [Link]
6. JavaScript: The Definitive Guide by David Flanagan, O'Reilly Media
7. Web Development with Node and Express by Ethan Brown, O'Reilly Media
19