A comprehensive web-based Car Rental Database Management System facilitating seamless vehicle booking, fleet management, and administrative oversight.
Authors · Overview · Features · Structure · Results · Quick Start · Usage Guidelines · License · About · Acknowledgments
Important
Special thanks to the AHNA Team (Hasan Rizvi, Nithya Gnanasekar, Anisha Gupta) for their meaningful contributions, guidance, and support that helped shape this work.
The Car Rental System is a web-based database management utility developed to automate and streamline vehicle rental operations. It features a robust dual-interface architecture that facilitates seamless interactions between end-users and administrators.
Developed as a mini-project for the Database Management System Laboratory curriculum, this tool demonstrates the practical application of relational database design (MySQL), server-side logic (PHP), and responsive frontend development (Bootstrap).
Note
Research Impact & Certification
This project was published as an academic research paper in the International Journal for Research in Applied Science & Engineering Technology (IJRASET) (Volume 9, Issue 7), with a scholarly Preprint available on viXra. The project received an official Publication Certificate for its research contribution to database management systems.
| # | Resource | Description | Date | Marks |
|---|---|---|---|---|
| 1 | Source Code | Complete web application source code | - | - |
| 2 | Technical Specification | System architecture and specifications | - | - |
| 3 | Project Report | Detailed project documentation | November 28, 2020 | 09/10 |
| 4 | Published Paper | IJRASET (Vol 9 Issue 7) Publication | July 2021 | - |
| 5 | Certificate | Publication Certificate | July 2021 | - |
| 6 | DBMS Laboratory | Computer Engineering Laboratory Repository | - | - |
Tip
Database Schema Optimization
For high-performance vehicle queries, ensure that the tblvehicles table is indexed on VehiclesBrand and PricePerDay. This optimization significantly reduces latency during filtered search operations and dashboard aggregation in the administrative backend.
| Feature | Description |
|---|---|
| Vehicle Inventory | Browsable fleet catalog comprising diverse vehicle brands, detailed specifications, high-resolution imagery, and accessory listings. |
| Booking Engine | Automated reservation workflow allowing users to query availability, book vehicles for specific durations, and track booking status (Confirmed/Pending). |
| Admin Dashboard | Centralized control panel providing real-time statistical insights into registered users, total bookings, vehicle status, and brand aggregates. |
| User Management | Secure authentication system for customers, featuring profile management, password recovery, and booking history tracking. |
| Fleet Administration | Comprehensive CRUD capabilities for administrators to manage vehicles, update pricing, modify features, and organize inventory by brand. |
| Reservation Control | Administrative tools to review, approve, or cancel user bookings, ensuring optimal fleet scheduling and availability management. |
| Content Management | Admin-controlled page editor for managing "About Us", "Privacy Policy", and "FAQs", alongside tools to moderate user testimonials. |
| Inquiry Handling | Dedicated interface for administrators to view, manage, and respond to "Contact Us" queries and manage email subscribers. |
- Language: PHP 7.x (Procedural)
- Database: MySQL 5.x+
- Frontend: HTML5, CSS3, Bootstrap 3, jQuery
- Server: Apache (XAMPP/WAMP)
CAR-RENTAL-SYSTEM/
│
├── docs/ # Formal Documentation
│ └── SPECIFICATION.md # Technical Architecture & Specification
│
├── Mini-Project/ # Research & Academic Assets
│ ├── Draft/ # Preliminary Documentation
│ │ └── IJRASET - Car Rental.docx # Working Draft Document
│ ├── Figures/ # UML & Architecture Diagrams
│ │ ├── Fig. (1) Use Case Diagram.png # System Use Case Diagram
│ │ ├── Fig. (2) Data Flow Diagram.png # Data Flow Diagram (DFD)
│ │ ├── Fig. (3) Sequence Diagram.png # System Sequence Diagram
│ │ ├── Fig. (4) ER Diagram.jpg # Entity-Relationship Diagram
│ │ ├── Fig. (5) Relationship Model.jpg # Database Relationship Model
│ │ ├── Fig. (6) Database Management.png # Database Management Structure
│ │ ├── Fig. (6) Home.jpg # Homepage Interface
│ │ ├── Fig. (7) Cars.jpg # Vehicle Listing Page
│ │ ├── Fig. (7) Database Structure.png # Database Schema Structure
│ │ ├── Fig. (8) Contact Us.jpg # Contact Form Interface
│ │ ├── Fig. (9) Sign In.jpg # User Login Interface
│ │ ├── Fig. (10) Make My Account.jpg # User Registration Interface
│ │ ├── Fig. (11) Password Recovery.jpg # Password Reset Interface
│ │ ├── Fig. (12) My Profile.jpg # User Profile Page
│ │ ├── Fig. (12) Update Password.jpg # Password Update Interface
│ │ ├── Fig. (13) My Booking.jpg # Booking History Interface
│ │ ├── Fig. (14) About Us.jpg # About Us Page
│ │ └── Fig. (15) Successful Connection.png # Database Connection Success
│ ├── B-42,45,50,51_DBMS_Mini_Project.pdf # Formal Academic Report (09/10)
│ ├── IJRASET-V9I7 - Car Rental System.pdf # Published Paper (IJRASET Vol 9 Issue 7)
│ ├── IJRASET36339 - Car Rental System.pdf # Publication Certificate
│ └── Preprint - Car Rental System.pdf # viXra Preprint
│
├── Source Code/ # Full Stack Web Application
│ ├── admin/ # Administrative Backend Module
│ │ ├── css/ # Admin Interface Stylesheets
│ │ ├── fonts/ # Admin Interface Web Fonts
│ │ ├── img/ # Admin Dashboard Visual Assets
│ │ ├── includes/ # Admin Shared Components
│ │ ├── js/ # Admin Functional Scripts
│ │ ├── dashboard.php # System Overview Dashboard
│ │ ├── manage-vehicles.php # Fleet Inventory Controller
│ │ └── reg-users.php # Registered User Directory
│ │
│ ├── assets/ # Public Frontend Resources
│ ├── includes/ # Core Shared Framework
│ ├── sqlfile/ # Data Architecture
│ │ └── carrental.sql # Relational Database Schema
│ ├── car-listing.php # Fleet Inventory Display
│ ├── index.php # Application Landing Page
│ ├── profile.php # User Account Management
│ └── vehicle-details.php # Comprehensive Vehicle Specs
│
├── .gitattributes # Git Line Ending Control
├── .gitignore # Excluded Files Manifest
├── CITATION.cff # Academic Citation Standard
├── codemeta.json # Software Metadata Repository
├── LICENSE # Project Licensing Terms
├── README.md # Comprehensive Documentation
└── SECURITY.md # Cybersecurity Protocol
Ensure your local development environment meets the following requirements:
- Web Server: Apache (via XAMPP, WAMP, or MAMP).
- PHP: Version 7.0 or higher.
- Database: MySQL 5.6 or higher.
- Browser: Modern web browser (Chrome, Firefox, Edge).
Warning
Legacy Dependencies & Security
This system utilizes PHP 7.x Procedural logic and Bootstrap 3. While robust for educational archiving, it is recommended to run this in a sandboxed local environment (e.g., XAMPP) to mitigate risks associated with legacy server-side scripting. Ensure that config.php utilizes strong MySQL credentials if deployed beyond local environments.
- Clone the Repository:
git clone https://github.com/Amey-Thakur/CAR-RENTAL-SYSTEM.git
- Deploy Source Code:
- Locate the
Source Codedirectory within the cloned repository. - Copy the entire contents of
Source Codeinto your server's root directory:- XAMPP:
C:\xampp\htdocs\carrental\ - WAMP:
C:\wamp64\www\carrental\
- XAMPP:
- Locate the
- Start Services: Launch Apache and MySQL via your server control panel.
- Access phpMyAdmin: Navigate to
http://localhost/phpmyadmin/. - Create Database:
- Database Name:
carrental - Collation:
utf8_general_ci
- Database Name:
- Import Schema:
- Select the
carrentaldatabase. - Import the
Source Code/sqlfile/carrental.sqlscript.
- Select the
Update the database connection settings in Source Code/includes/config.php (and Source Code/admin/includes/config.php) if your local MySQL credentials differ from the defaults.
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','');
define('DB_NAME','carrental');Access the application through your local gateway: http://localhost/carrental/
This repository is openly shared to support learning and knowledge exchange across the academic community.
For Students
Use this mini-project as a reference for understanding relational database design, server-side logic in PHP, and responsive frontend development. The source code and research assets are documented to support self-paced learning and exploration of full-stack database applications.
For Educators
This project may serve as a practical example or supplementary teaching resource for Database Management System courses (CSC502 / CSL503). Attribution is appreciated when utilizing content.
For Researchers
The published paper and preprint provide insights into the system's architecture and the researchers' approach to automating vehicle rental operations.
This repository and all linked academic content are made available under the MIT License. See the LICENSE file for complete terms.
Note
Summary: You are free to share and adapt this content for any purpose, even commercially, as long as you provide appropriate attribution to the original author.
Copyright © 2021 Amey Thakur
Created & Maintained by: Amey Thakur
Academic Journey: Bachelor of Engineering in Computer Engineering (2018-2022)
Institution: Terna Engineering College, Navi Mumbai
University: University of Mumbai
This project features the Car Rental System, a web-based utility developed as a 5th Semester Mini-Project. It showcases the practical application of full-stack web development principles and relational database management.
Connect: GitHub · LinkedIn · ORCID
Grateful acknowledgment to the AHNA Team (Hasan Rizvi, Nithya Gnanasekar, Anisha Gupta) for their exceptional collaboration and innovative contributions during the development of this project. Their combined technical expertise in relational database architecture, server-side PHP logic, and commitment to software quality were instrumental in building this robust management system. Learning alongside them was a transformative experience; their thoughtful approach to problem-solving and steady encouragement turned complex challenges into meaningful learning moments. This work reflects the growth and insights gained from our side-by-side academic journey. Thank you, Hasan, Nithya, and Anisha, for everything you shared and taught along the way.
Grateful acknowledgment to the faculty members of the Department of Computer Engineering at Terna Engineering College for their guidance and instruction in Database Management Systems. Their expertise in relational architecture and server-side logic helped shape the technical foundation of this project.
Special thanks to the mentors and peers whose encouragement, discussions, and support contributed meaningfully to this learning endeavor.
Authors · Overview · Features · Structure · Results · Quick Start · Usage Guidelines · License · About · Acknowledgments
🔬 Database Management System Laboratory · 🚗 Car Rental System
Computer Engineering (B.E.) - University of Mumbai
Semester-wise curriculum, laboratories, projects, and academic notes.