National University of Technology, Islamabad
CS160 – Database Systems
Project-Based Learning (PBL) Proposal
Group Members:
Mohammad Youniss Sarwari (F24608062)
Yahia Habibi (F24608065)
Farkhunda Latif (F24608060)
Zeeshan Afridi (F24608054)
Maid Ali (F24608047)
Mustafa Nazari (F24608068)
Car Rental System Project
This project implements a Car Rental System applying core database concepts. It
concepts. It simulates a real-world vehicle rental business. We designed and
and implemented a fully functional relational database.
Addressing Real-World Challenges
Car rental agencies need efficient systems. Manual processes cause conflicts and data issues. Our system offers robust, user-friendly data
friendly data management. It uses structured data and simple interfaces.
Booking Conflicts Data Redundancy Reporting Difficulties
Manual systems lead to overlapping Poor tools result in duplicated and Inefficient data makes generating reports
overlapping reservations. inconsistent data. hard.
Project Objectives
We aimed to design a normalized database. This includes creating tables and automating
rental assignments. We also developed a web interface.
1 Database Design
Normalize and create tables for car rental service.
2 SQL Operations
Write CRUD queries and generate reports.
3 Web Interface
Build a basic HTML/CSS/PHP front-end.
4 System Integration
Connect front-end with SQL Server database.
Tools and Technologies
We utilized Microsoft SQL Server for the database. PHP handled the back-end logic.
HTML/CSS with Bootstrap created the front-end.
Component Technology Used
Database Microsoft SQL Server
Back-End PHP
Front-End HTML, CSS (Bootstrap)
ERD Design [Link] / [Link]
IDE Visual Studio Code / SSMS
Local Server XAMPP
System Scope and Modules
The system manages vehicles, customers, and rentals. It includes a Rent Vehicle module. Payment tracking and reporting are also supported.
Vehicle Management Customer Management Rental System Payment Tracking
Management Management
Rent vehicles and track return Record payments, statuses,
Add, update, delete vehicle Register and update customer dates. and dates.
records. information.
Implementation Plan
Our plan involved seven key steps. From requirements to final testing. Each step ensured a robust and functional system.
Requirement Gathering
And ERD design.
Database Creation
Schema and table setup.
SQL Development
For CRUD operations.
Front-end Design
HTML/CSS/PHP UI.
UI Integration
With SQL Server.
Testing & Debugging
Finalizing Rent module.
Final Submission
Testing and report.
Database Tables and Workflow
The system manages Vehicles, Customers, Rentals, and Payments. A RentVehicle module links customers
to vehicles. This generates rental and payment records.
Customer Registration
Vehicle Addition Customers are registered in the
Admin adds vehicles to the Vehicles Customers table.
table.
Initiate Rental
Record inserted into RentVehicle
table.
Update Status
Process Payment
Vehicle status updated to "Rented".
Payment record generated in
Payments table.
Query: Show cars which are available to rent.
Query: Show all customers and their info.
Conclusion and Future Scope
This project successfully integrates database operations with
a user-friendly interface. It streamlines vehicle rentals and
customer management. The system offers a complete
workflow for rental businesses.
Enhanced Technical Skills
Strengthened full-stack development abilities.
Improved Problem Solving
Better analysis, planning, and delivery of solutions.
Scalable Foundation
Ready for advanced features like reporting and
notifications.
