Loading repository data…
Loading repository data…
Amey-Thakur / repository
A web-based Car Rental Database Management System designed for online vehicle booking and administrative management, featuring separate user and admin interfaces.
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
A comprehensive web-based Car Rental Database Management System facilitating seamless vehicle booking, fleet management, and administrative oversight.
Source Code · Technical Specification · Live Demo
Authors · Overview · Features · Structure · Results · Quick Start · Usage Guidelines · License · About · Acknowledgments
Terna Engineering College | Computer Engineering | Batch of 2022
| Amey Thakur |
|---|
[!IMPORTANT]
🤝🏻 Special Acknowledgement
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
tblvehiclestable is indexed onVehiclesBrandandPricePerDay. 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. |
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