Car Rental Web Portal

Introduction

This web portal is designed for rent-a-car services provider where the user can visit and book their required vehicle online and select their vehicle, duration, with driver option etc. A complete list of vehicles with detailed description along with the images is available for users. User can easily pay online or at user location, but the user needs to make an account so that he/she can check his/her records and current status.

This system include a complete content management system so that the client can easily add, update, or delete any vehicle, check payment details, check users detail etc. Payment gateway is also integrated for online transaction.

Purpose

This web portal will increase clients because customers who live far from showroom can also approach and vehicle can be delivered at his/her doorstep.

Scope

A comprehensive web portal for rental car services where the user can become a member and book any car for a rental and can pay through credit/Debit card and also all descriptions of vehicles should be available along with the rental rates and terms and conditions.

System Overview

This system comprises 3 types of users and 2 modules which are listed below:

System Users

• Admin
• Staff
• Member/Customer

Modules

• Registration and booking
• Billing and Payment

Logical Design



Physical design

Fields	Data Types
Member_ID (PK)	Auto
Member_Name	Varchar(50)
Member_Address	Varchar(50)
Member_Contact_1	Varchar(20)
Member_Contact_2	Varchar(20)

Fields	Data Types
PaymentID(PK)	Auto
Booking ID(FK)	Auto
DateTime_Of_Handover	DateTime
Advance	Double
Remaining	Double
Total	Double
Status	Varchar(10)

Fields	Data Types
Booking_ID (PK)	Auto
Member_ID(FK)	Auto
Rent_ID (FK)	Auto
Driver_ID (FK)	Auto
Booking_Date	Auto
Vehicle_ID (PK)	DateTime
Booking_Per	VarChar(10)
Rent_Rate	Double
Date_Time_Of_Handover	DateTime
Date_Time_of_return	DateTime
Meter_Reading	Varchar(50)
Fuel_Reading	Varchar(50)

Fields	Data Types
Driver_ID (PK)	Auto
Driver_Name	Varchar(50)
Driver_Address	Varchar(50)
Driver_Contact_1	Varchar(20)
Driver_Contact_2	Varchar(20)
Driver_NIC	Varchar(20)
Driver_Timings	DateTime

Use Cases

Context Diagram



Data Flow diagram





User services

• User can create account
• user can book vehicle online
• user can track his current rent status
• user can check his previous records
• user can pay online
• user can send feedback
• Invoice generated for user which can be printed

Client Services

• Client can check all members record
• Client can manage orders
• Client can check add, update and delete members
• Client can add, update and delete vehicles and its description
• Separate login area for admin and other employees
• Invoice generated for client which can be printed