PROJECT REPORT

ON
“Car Rental System”
DEVELOPED AT

Creative Werk Designs

NADIAD

Developed By

BHATT KRISH V. (19BCUOS047)

SOLANKI JAY A. (19BCUBS085)
Internal Guide: External
Guide:

Prof. Chirag Patel Arpit G.

Shah

B.C.A Department, Creative Werk

designs,

D. D. University, Nadiad Nadiad.

Submitted To

Bachelor of Computer Application

Faculty of Management and Information Science
DHARMSINH DESAI UNIVERSITY
APRIL — 2022
DHARMSINH DESAI UNIVERSITY
 DHARAMSINH DESAI UNIVERSITY Faculty
Of Management & Information Science College
Road, Nadiad-387001

Certificate
This is to certify that Solanki Jay A. and Bhatt Krish V. of BCA
Semester-VI of Dharmsinh Desai University, Nadiad, have worked on the
Project “Car Rental System” at creative werk designs under my guidance. They
have successfully completed the project.
This project was carried from 06/12/2021 to 26/03/2022 as partial fulfillment
towards the degree of BCA (Bachelor of Computer Application). I wish them
success in their future endeavors as computer professionals.

Internal Guide Prof. [Link]

Asst. Prof.C.G. Patel HOD, BCA Department
BCA Department Dharmsinh Desai University
Dharmsinh Desai University
 Acknowledgement
We are grateful for and lucky to have received consistent encouragement,
support, and advice from our H.O.D. Prof C.P. Patel and all members of the
BCA Department Teaching Staff, who assisted us in completing our project
work successfully.
The success and end of this project necessitated a great deal of direction and
assistance from many people, and we consider ourselves quite fortunate to have
received it during the duration of our project. All of what we have accomplished
has been possible solely because of their guidance and aid, and we would like to
express our gratitude towards them.
Mr. Arpit G. Shah has our respect and gratitude for allowing us the opportunity
to work on the project at Creative Werk Designs and for providing us with all the
support and advice that enabled us to complete the project successfully.
Despite his busy schedule managing corporate matters, we are grateful to him for
providing such wonderful support and counsel. We owe a debt of appreciation to
him, who took a real interest in our project work and walked us through it from
start to finish, providing all the information we needed to establish a strong
system.
We would like to express my gratitude to Mr. Chirag Patel, Assistant Professor,
BCA Department for her assistance and recommendations during this endeavor.
Finally, we owe a great deal of appreciation to our family and friends, who have
provided as ongoing sources of inspiration throughout the development of this
project.

Thank You All,

Jay A. Solanki
Krish V. Bhatt
 Table of Content

[Link]. Content Page No.

1. Project Profile 1

2. About the system 2

3. Organization Overview and Organization Chart 3

4. Hardware and software Configuration 5

5. Features of the tools Used 6

6. Detailed Description Of The System 7

a. Existing System

b. Proposed System

7. System Documentation

a. Time Line Chart 8

b. Feasibility Study 9

c. System Flow Chart 11-22

d. Entity Relationship Diagram 23

e. Context Diagram 24

f. Data flow Diagram 25-32

g. Data Dictionary 33-49

h. Screen Layouts with Description 50-98

i. Report Generated from your system 99-103

j. Testing- Test Data, Expected Result and Actual Result 104-145

8. Scopes and Limitations 144

9. Future Expansion 145

10. References and bibliography 146

D.D.U. Car Rental System
Project Profile

Project Name Car Rental System

Developed By Krish V. Bhatt (19BCUOS047)
Jay A. Solanki(19BCUBS085)
Project External Guide Arpit G. Shah
Project Internal Guide Prof. Chirag Patel
Technology PHP
Database MySQL
Framework Code Igniter (MVC Structure)
HTML Framework BootStrap
JavaScript Framework Data Tables
Submitted To B.C.A Department,
Faculty of Management and
Information Science,
Dharmsinh Desai University

1|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
1.) About the System
Car rental system is an online booking system designed to meet the specific needs
of car rental companies, travel companies and travel agencies. Car reservation
system is a complete package of car rental websites, booking engines, end-user and
driver mobile apps and fleet management modules.
This Project is designed so as to be used by car Rental Company Specializing in
renting cars to customers. It is an online system through which customer can view
available cars, registration, view profile and book car. The advantage in information
Technology and internet penetration has greatly enhanced various business
processes and communication between companies and their customers of which car
rental industry is not left out.
MODULES:

View Available Cars: It is a system design especially for large, premium and small
car rental business. The user can view Available cars and user can book for that car.
Booking Car: The user can view Available cars and user can book for that car.
Easily Get the Car on rent: The Customer can easily get the car whenever they
need to on the rent with use of this system.
Give Feedback: The customer will give the feedback to the admin.
Enquiry: The inquiry can easily done by user.
Add Car: The Admin can add the car so that the user can see the available cars and
book the car.
Manage Rent: The Admin can manage the rent so that the user can see the rent and
book the car.
View Feedback: The admin easily view the feedbacks and solve the query.

2|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

2.) Organization Overview & Chart

Creative Werk Designs is a premier website design and development company that
is located in Nadiad, Gujarat, India. Coming up with exceptionally professional
websites with high end applications has been our forte. We have an array of services
that are being offered to our clients from across the globe. With a client-centric
approach, we ensure that we meet all our client requirements with the right kind of
innovative mix and technical expertise.
Creative Werk Designs is the brainchild of Arpit G Shah and Jyoti A Shah. With a
BE in Information Technology, the CEO of the company, Mr. Arpit has garnered 10
years of rich experience and specializes in development of responsive web designs,
Magento development, development of iPhone and Android applications, Square
Space, Weebly, WordPress, Opencart, Bootstrap framework, JavaScript/Jquery,
HTML5/CSS3 and many more. With unparalleled levels of commitment and
dedication towards his job, which is also his passion, Arpit G Shah has been able to
win out quite a number of international clients too to his repertoire. His partner in
work and in life, Jyoti A Shah, the Co-Founder and Director of Creative Werk
Designs has a post graduate degree in Information Technology and garnered a rich
experience of 6 years in the field of internet marketing. With Search Engine
Optimization being her forte, she has also doled out stupendous quality work in
content writing, blogging, PPC campaigns, SMO and web designs and print designs.

3|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

4|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

3.) Hardware - Software Configuration [Actual]

Hardware(Client Side)

RAM 512MB

Hard Disk 10GB

Processor 1.0GHz

Hardware(Server Side)

RAM 1GB

Hard Disk 20GB

Processor 2.0GHz

Software(Client Side)

Web Browser Internet Explorer 6 or Any

compatible browser

Operating System Windows or any equivalent OS

Software(Server Side)

Web Server IIS 7.5

Database Server MS SQL Server 2008

Web Browser Internet Explorer 6 or any

compatible browser

Operating System Windows Server 2007

Windows xp

Linux os

5|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
4.) Features of tools use
XAMPP:
XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP(P) and
Perl (P).
Features:
► Xampp is a free and open source.
► It is a simple, lightweight Apache distribution that makes it extremely easy for
developers to create a local web server for testing and deployment purposes.
► XAMPP is great tool for anyone looking to get full development server up and
running within quick time constrains.
► XAMPP is also cross-platform, which means it works equally well on Linux,
Mac and Windows.
► XAMPP's designers intended it for use only as a development tool, to allow
website designers and programmers to test their work on their own computers
without any access to the Internet.
► XAMPP makes transitioning from a local test server to a live server extremely
easy as well.
► XAMPP also provides support for creating and manipulating databases in
MariaDB and SQLite among others.

6|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
5.) Detailed Description of the System
Existing Car Rental System
Car Rental System service will help users to book a car for some fee specified. Till now there
was no clear web based UI to help the users to rent the vehicle. They had to manually rent the
vehicle through their offices. It was a difficult task to manage rental vehicles. Keeping track of
all the rental cars was a problem.

Proposed System
This Car Rental System project will enable the user to rent a vehicle. The user shall login to the
system and check for availability of cars. The user specifies a type of car and the journey date
and time. The Car Rental System shall check for the availability of the car and rent the car to the
customer. The user can make payment online. The tool is designed using Code Igniter. All the
data regarding the rental cars are stored in MySQL database. The user has to enter his name,
address, phone details and check for the cars available for rent. The UI is very simple and the
connectivity to back end is robust. The main advantage is that the user shall be able to choose a
car depending on his budget

7|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
6.) Gantt Chart

8|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
7.) Feasibility Study and System Flow Chart
Operational Feasibility:

• This project is being developed keeping in mind the general people who one
have very little knowledge of computer operation, they can easily access booking
related information.

• The point to be considered are the system interface is standard, user friendly
and provides extensive help. Hence no special training is required. System can
easily work withall the major devices and major browsers compatibility.

• Our system meets the requirements of the customer and the administrator and
also there is no need for special staff member. so we can say that the system is
operationally feasible.

Economic Feasibility:

• Our Project will be beneficial because only one time development efforts (in
terms of person-hours or money) required. All people are aware of technologies
so no special skill required to running the system. As no paper required so it
reduces cost.

• The system provides many benefits that can't be measured

in terms of money for e.g., user friendliness, more efficient user response,
maintenance of database etc. The system also reduces the administrative and
technical staff to do various jobs that single software can't do so this system is
Economically feasible.

9|Page Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

Technical Feasibility:

• It is planned to implement the system using, window 10operating system,

sublime text editor, etc. It is evident that the necessary soft-ware and hard-ware
is available for development and implementation of the system.

• This project will be platform independent since it is being coded in PHP with
MVC structure and Html is used to create web pages.

• The system is developed using PHP as the main development language due to
client’s hardware specification, and apache has been chosen to the web server
due to high reliability and flexibility in between platforms. MySQL is chosen to
be the DBMS of the system, due to flexibility.

• All the required technologies are widely used and are available for free use.
These technologies are all open source software (MySQL apache, PHP). Hence
we can confidently conclude that this system is indeed technically
feasible.

10 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
System Flowchart

11 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

12 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

13 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

14 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

15 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

16 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

17 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

18 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

19 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

20 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

21 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

22 | P a g e Jay A. Solanki
Krish V. Bhatt
ERD
D.D.U. Car Rental System

Context Level DFD

24 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
Level 1 DFD

25 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
Level 2 DFD
2ndlevelofRegistration&LoginProcess

26 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
nd
2 LevelofCarBookingProcess

27 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

2ndlevelofTourPackages

28 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

2ndLevelofPaymentProcess

29 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

2ndLevelofInvoiceProcess

30 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

2ndLevelofFAQ’S

31 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
2ndLevelofreview and rating

32 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

Data Dictionary
TableName:Admin

Name DataType Size Constrain Description

a_id Int 10 Primary For the

uniqueidentificati
Key,AutoIncrem onforadminrecord
ent .

a_name Varchar 100 Nameofadmin

Password Varchar 20 password

ofadmin

activation_code Varchar 40 activationcode

oftheadmin
forgot_password_code Varchar 40 Forgotpassword
codeofadmin

33 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:User

Name DataType Size Constrain Description

u_id Int 10 Primary For the

uniqueidentificati
Key,AutoIncrem onforuserrecord.
ent

f_name Varchar 50 Firstnameofth

euser

l_name Varchar 50 Lastnameofth

euser

Email Varchar 30 Emailidoftheus

er

Password Varchar 20 Password

givenbyuser

Mobile Varchar 20 Contact

numberoftheuser

date_of_registration Date Registrationdate

oftheuser

forgot_password_code Varchar 40 forgot

passwordcodeofth
euser
activation_code Varchar 40 Activationcodeof
theuser

34 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:Vehicle

Name DataType Size Constrain Description

v_id Int 10 PrimaryKey, Fortheuniqueid

entificationfor
AutoIncrement vehiclerecord.

v_model Varchar 50 Modelnameofth

ecar

v_name Varchar 100 Name of

thecar

v_description Varchar 500 Description

ofthecar

passenger_capacity Int 10 Passengercapac

ityofcar

large_luggage_capacity Int 10 Large

luggagecapacit
yofcar
small_luggage_capacity Int 10 Small
luggagecapacit
yofcar
fuel_type Enum “Petrol”,”Diesel”,”Gas Fueltypeofc
”.”Electric” ar

v_image Varchar 255 Pathoftheim

age

car_no_plate Varchar 25 Carnumberofth

ecar

Total_vehicles Int 2 Check Constraint Total

2 availablecar

cost_stating_from Int 10 Statingpriceofth

ecar

v_status Enum “Active”,”Inactive” AsDefined To store

thestatusofthe
car

A_id Int 10 Fk For

Acknowledge
ment of
booking
35 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

TableName:features

Name DataType Size Constrain Description

f_id Int 10 PrimaryKey, Uniqueidentification

AutoIncrement

Feature Varchar 50 Featuresoftheca

r
likeac,wifi,none-
ac
Status Enum “Active”,”Inactive” AsDefined To store
thestatusofthe
featurs

v_id Int 10 FK vehicleidentification

36 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName: vehicle_booking

Name DataType Size Constrain Description

vb_id Int 10 Primary For the

uniqueidentificati
Key,AutoIncrem onforvehicle
ent bookingrecord.

u_id Int 10 FK useridentification

v_id Int 10 FK vehicleidentificatio

n

pick_date Date Pickupdateofthe

user

pick_time Time Pickuptimeofthe

user

pick_point Varchar 512 Pickuppointofthe

user

drop_point Varchar 512 Droppointofth

euser

Distance Float 10,2 Distancecalcu

latebetween
pickpont&
droppoint

distance_type Varchar 10 distancetypeofthe

journey in km.

return_journey Enum “yes”,”no” Returnjourneyre

quiredornot

waiting_id Int 10 FK waitingtimeid

only_booking_cost Float 10,2 Only

bookingcostexclu
detax
/couponetc
tax_applied Enum “yes”,”no” Fortaxapplied

37 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
tax_amt Float 10,2 Tax amount
onthetotalamount

coupon_id Int FK couponidentificati

on

cost_of_journey Float 10,2 Totalamountofthe

journey

is_conformed Enum “pending”,”confirm”,” To determine

allthe
cancelled,”refund” possiblevalue
forconfirmbookin
g
Bookdate Date Bookingdateofth
ecar

A_id Int 10 Fk For

Acknowledgeme
nt of booking

TableName:waitings

Name DataType Size Constrain Description

waiting_id Int 10 PrimaryKey, Uniqueidentification

AutoIncrement

waiting_time Waitingtimeforre
turnjourney

Cost Float 10,2 Waitingcostforth

e returnjourney

Status Enum “Active”,”Inactive” AsDefined To store

thestatusofthe
waitingtime

38 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:tourpackage

Name DataType Size Constrain Description

package_id Int 10 PrimaryKey, Fortheuniqueid

entificationfor
AutoIncrement tourpackagerec
ord.

package_name Varchar 100 Name of

tourpackage

from_location Varchar 100 Tour

packagestartlo
cation
to_location Varchar 100 Tour
packageendloc
ation
Description Varchar 10000 Description
oftourpackage

arrival_date Date Arrivaldateofu

ser

arrival_time Time Arrivaltimeofu

ser

dept_date Date Deptarture

dateofuser
dept_time Time Deptartureti
meofuser

pack_price Float 10,2 Priceoftourp

ackage

package_img Varchar 255 Path of

theimageoftou
rpackages

Status Enum “Active”,”Inactive” AsDefined Statusoftourpa

ckage

A_id Int 10 Fk For

Acknowledgem
ent of booking

39 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

TableName:image_file

Name DataType Size Constrain Description

Id Int 10 Primary For the

uniqueidentificati
Key,AutoIncrem onfortour
ent packageimages

file_name Varchar 255 Nameofimage

uploaded_on Datetime Uploadeddate&ti

me of theimage

Status Enum ‘1’,’0’ Asdefined:1 1foractivei

mage

0forinactivei
mage

p_id Int 10 FK Package_id

40 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:package_booking

Name DataType Size Constrain Description

pb_id Int 10 PrimaryKey, For the

uniqueidentificati
AutoIncrement onfortour
packagebooking.

u_id Int 10 FK Useridentification

booking_ref varchar 100 Bookingreferencenu

mber for
tourbooking

payment_type Enum “cash”,”paypal”,”payu Todetermineallthetyp

” esofpayment

payment_received Float 10,2 Tostorepaymentrec

eivedamount

total_price Int 10 Totalpricefortourpa

ckagebooking

is_conformed Enum “pending”,”confirm”,”ca Todetermineallthepos

sible value
ncelled”,refund forconfirmation
tourbooking

Bookdate Date Bookdateofthetou

rpackages

registered_name varchar 100 Registered

usernameforthetou
rpackage

package_id Int 10 FK Packageidentification

payer_id varchar 100 Payeridforp

ayment

coupon_id Int 10 FK Couponidentificati

on

a_id Int 10 FK For

Acknowledgement
of booking
details

41 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

TableName:coupon

Name DataType Size Constrain Description

coupon_id Int 10 PrimaryKey, Uniqueidforthe

AutoIncrement Coupon
c_title Varchar 100 Titleoftheco
upon

c_code Varchar 20 Code of

thecoupon

discount_amt Float 10,2 Discountamountapp

lied bycoupon

to_date Date stating

couponappliedd
ate
from_date Date Lastvaliddateofth
ecoupon

created_on Datetime coupon

createddateandti
me
Updated Datetime Couponupdatedd
ateandtime

Status Enum “Active”,”Inactive” AsDefined To store

thestatusofthe
coupon

42 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

TableName:payment

Name DataType Size Constrain Description

p_id Int 10 Primary Uniqueidentificati

onforpayment
Key,AutoIncrem

ent

p_date Date To store

thepaymentdat
e
p_time Time To store
thepaymenttim
e
trans_id Varchar 100 To store
thetransactionid

coupon_id Int 10 FK coupon

identification
p_status Varchar 50 Statusofthepa
yment

booking_ref Varchar 50 Refferencenum

berofthebookin
g

total_amount Float 10,2 To store

thetotal
paymentamoun
t
p_type Enum “cash”,”payumoney” Todetermineallth
e
typesforpayment

a_id Int 10 Fk To see all the

payment Details

43 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:Invoice

Name DataType Size Constrain Description

Id Int 10 Primary Uniqueidentificati

onforinvoice
Key,AutoIncrem

ent

u_id Int 10 FK Useridentification

p_id Int 10 FK Paymentidentificatio

n

created_on Date Invoice

createddate

due_date Date Invoiceduedate

bill_date Date Invoicebilldate

total_amount Float 10,2 Tostorethetotalam

ount

44 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:Reviews&Ratings

Name DataType Size Constrain Description

Id Int 10 PrimaryKey, For

uniqueidentification
AutoIncrement

u_id Int 10 FK Useridentificati

on

package_id Int FK Packageidentificatio

n

Rating Int 10 Tostoretherat

ingcount

Content Varchar 512 To store

thecontentofthe
reviews

added_date Date Tostorereviewsad

deddate

Status Enum “Active”,”Inactive” Statusoftherev

iews

45 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:site_settings

Name DataType Size Constrain Description

Id Int 10 PrimaryKey, For uniqueidentification

AutoIncrement

a_id Int 10 Adminidentification

site_name Varchar 5 Nameofthesite

Address Varchar 512 Tostoreaddressforcont

actus

City Varchar 100 Tostorethecityforcont

actus

State Varchar 100 Tostorethestateforconta

ctus

Country Varchar 100 Tostorethecountryforc

ontactus

Pincode Varchar 100 Tostorethepin number

Mobilenumber Varchar 20 TostoreMobilenu
mber

land_line Varchar 20 Tostoreland_linenu

mber

contact_email Varchar 25 Tostoretheemailforthec

ontactus

Designby Varchar 512 Tostorethecompanynam

e

46 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:email_settings

Name DataType Size Constrain Description

Id Int 11 PrimaryKey, Tostoretheun

iqueid
AutoIncrement

a_id Int 10 Adminidentification

smtp_host Varchar 100 Yourserverhost

smtp_post Int 10 Serverport

smtp_user Varchar 100 server

username

smtp_password Varchar 50 Password

mail_config Enum “webmail” smtp

mailsetting
s

TableName:email_templates

Name DataType Size Constrain Description

Id Int 10 PrimaryKey, Tostoretheun

iqueid
AutoIncrement

a_id Int 10 Adminidentification

Subject Varchar 100 Titleoftheemail

email_template Varchar 10000 Tostorethefo

rmate
foremail

Status Enum “Active”,”Inactive” AsDefined Statusofemailte

mplates

47 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:payu_settings

Name DataType Size Constrain Description

Id Int 10 PrimaryKey, Tostoreuniqueide

ntification
AutoIncrement

a_id Int 10 Adminidentification

test_merchant_key Varchar 20 Test key

forPayUMon
eyintegration

test_salt Varchar 20 TestsaltkeyforPa

yUMoneyintegrat
ion

live_merchant_key Varchar 20 Livemerchantkey

forPayUMoneyin
tegration

Varchar 20 LivesaltkeyforPa
live_salt yUMoneyintegra
tion

Mode Enum “test”,”live” Mode

forPayUMoneypay
mentintegration

48 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
TableName:faq’s

Name DataType Size Constrain Description

Id Int 10 PrimaryKey, UniqueidforFAQ

AutoIncrement

a_id Int 10 adminidentification

Question varchar 512 Storequestions

Answer varchar 512 Storeanswers

Status enum “Active”,”Inactive” AsDefined To determine

allthepossiblevaluef
orstatus

49 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

Screen Layout with Description

1.) Home Page
Description:- Home page

2.) Registration
Description:-For Registration of user

50 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

3.) Activation link

Description:- Send by admin to user for login

51 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

4.) Login
Description:- For Login of user

52 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

5.) Logout
Decription:- for logout of user

53 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

6.) Forgot Password

Description:- If user forgot password

54 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

55 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

7.) Term’s and condition in car rental

Description:- for term’s and condition for car rental

8.) Car rental

Description :-For car booking

56 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

57 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

58 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
9.) Payment
Description:- Bill generated for car or tour package

10.) Printing bill

Description:- For customer on the spot printing

59 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

11.) Email of Confirm Booking

Description:- Sending Email of confirm booking of Customer to admin

12.) Pdf of Confirm Booking

Description:- Pdf Sending to customer

60 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

13.) Taxi booking

Description:- Taxi booking for customer

61 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

14.) Admin Booking Confirmation of car

Description:- Confirmation of car booking

62 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
15.) Cancellation of car booking
Description:- Cancellation of car booking and sending email

16.) Tour package view

Description:- For Details of Tour Booking

63 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
17.) Tour package booking
Description:- For booking of tour package

64 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
18.) Faq
Description:- faq for the customer

19.) Contact
Description:- For contact to admin

65 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

20.) Email of contact

Description:- An email is sent to admin by customer for contact

66 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
21.) Review
Description:-Review customer side

22.) User side my account

Description:- My account user side

67 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
23.) User side my profile
Description:- To change name and other details

24.) Change password

Description:- Change password user

68 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

25.) My Booking
Description:- User side my booking

69 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
26.) Booking details
Description:-User side booking details

27.) Suggestion page

Description:- Suggestion page for customer

70 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
28.) Dashboard
Description:- Admin Side Home Page for easy accessible

29.) Admin side Profile

Description:- Admin Details like name email etc

71 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
30.) Change password admin
Description:- Change password for admin

72 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
31.) Add Booking
Description:- Admin can do booking for himself and for others also

32.) Today booking

Description:- Admin can see all booking

73 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
33.) Search booking
Description:- Search booking for specific date

34.) Search booking result

Description:- Result of search booking

74 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
35.) All booking
Description:- All Booking which is being requested

36.) Vehicle List

Description:- List of vehicle which is being added

75 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
37.) Vehicle feature
Description:- vehicle features of car

38.) Edit Features

Description:- features which is being edited

76 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

39.) Edit vehicles

Description:- Edit vehicle for admin

77 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
40.) Add vehicle
Description:- To add new vehicle

41.) Add package

Description:- To add new Package

78 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
42.) All Package
Description:- All Package List

43.) Edit or Add Tour Packages

Description:- To add new package booking

79 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
44.) Add tour booking
Description:- add new tour booking

80 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
45.) All tour booking
Description:- List of all booking

46.) List Customer

Description:- List of customer who have registered

81 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
47.) site Setting
Description:- Site setting for admin

48.) review setting

Description:- Review of customer

82 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
49.) Add Testimony
Description:- Testimony for to add review

50.) Email setting

Description:- Email Settings for admin

83 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
51.) Email template
Description:- Email Template to edit specific details

52.) Edit Email Template

Description:- Email template to edit

84 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
53.) payu setting
Description:- To have payment option

54.) package setting

Description:- Package setting for users managed by admin

85 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
55.) Edit Package
Description:- Edit package for customer

56.) Add waiting time

Description:- Waiting time for user managed by admin

86 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
57.) waiting time
Description:- list of waiting time

58.) Edit waiting time

Description:- Edit waiting time if admin have made some mistake

87 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System

59.) Reason to book with us

Description:- Reason to book with us for attraction of website

88 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
60.) Coupons
Description:- Coupons list to give offer

61.) Edit Coupons

Description:- Edit coupon if admin have made some mistake

89 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
62.) Add Coupons
Description:- Add coupon to add new offers

63.) car invoice

Description:- invoice generated for car

90 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
64.) car invoice pdf
Description:- pdf generated for car invoice

65.) tour package invoice

Description:- for confirmation of tour package

91 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
66.) faqs
Description:- faq for customer

67.) Add Faq’s

Description:- add new faq for customer

92 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
68.) Edit Faq’s
Description:- Edit faq if admin had made some mistake

93 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
69.) overall Vehicles
Description:-to get idea of which vehicle has been booked

70.) payments
Description:- the users who have paid the bills

94 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
71.) Edit Testimony
Description:- edit testimony if admin have made mistake

72.) Excel Sheet of payment

Description:- excel sheet generated for payment

95 | P a g e Jay A. Solanki
Krish V. Bhatt
 D.D.U. Car Rental System
73.) Over All Vehicle Excel Sheet
Description:- sheet generated for all vehicle

78.) Payu settings

Description:- Payment gateway

96 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
79.) Debit Card Details
Description:- payment gateway for debit card

80.) Net Banking

Description:- payment gateway for net banking

97 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
81.) UPI
Description:- Payment gateway for upi

82.) Login to payu

Description:- payment gateway login for payu

98 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System

System Generated Report

1.) Over all vehicle report (Dynamic)
Description:- overall vehicle report

2.) Over all vehicle report (Dynamic)

Description:- overall report of vehicle in from of excel sheet by clicking on
excel button

99 | P a g e Jay A. Solanki
Krish V. Bhatt
D.D.U. Car Rental System
3.) Payment report (Dynamic)
Description:- Confirmation of payment

4.) Payment report (Dynamic)

Description:- Payment excel sheet by clicking on excel button

100 | P a g e Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
5.) Tour Package Invoice
Description:- All information of Tour Package Invoice

6.) Tour package invoice

Description:- all details of tour package invoice

101 | P a g e Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

7.) Car Invoice

Description:- Car invoice in from of pdf

8.) Customer bill report (dynamic)

Description:- Customer Bill

102 | P a g e Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System
9.) Customer booking report (dynamic)
Description:-customer side booking report

10.) Customer bill copy (Dynamic)

Description:- Customer bill copy in from of pdf

103 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System

Test Case

 Customer side Booking Process

1. Customer Registration
[Link] Field Input Expected Actual Result
Output Output
1. First name Jay Data added Data added Pass
successfully to Edited
and display
and display
message
message
successfully
successfully
1234567 Error Error Unsuc
cessful
2. Last name Solanki Data added Data added Pass
successfully to Database
and display
and display
message
message
successfully
successfully
- Error Error Unsuc
cessful

104 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3. Email Jay.solanki0906@g Data added Data added Pass
[Link]
successfully to Database
and display
and display
message
message
successfully
successfully
[Link] Error Error Unsuc
m cessful
4. Mobile 9428022578 Data added Data added Pass
Number successfully
to Database
and display
and display
message
message
successfully
successfully
Jay Solanki Error Error Unsuc
cessful
5. Password Jay@0402 Data added Data added Pass
successfully successfully
and display and display
message message
successfully successfully
Xyz Error Error Unsuc
cessful

105 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6. Confirm Jay@0402 Data Data Pass
Password recorded recorded
successfully successfully
and display and display
message message
successfully successfully
Xyz Error Error Unsuc
cessful
7. All Null All field null Data not Data not Unsucce
ssful
added into added into
database database

106 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
2. Customer Login
[Link] Field Input Expecte Actual Result
d
Output
Output
1. Email-id Jay.solanki0906@g Login Login Pass
[Link] Successf Successfull
ully y
and and
redirect redirect to
to home home page
page
[Link] Error Error Unsuc
m cessful

2. Password Jay@0402 Login Login Pass

Successf Successfull
ully y
and and redirect
redirect to home
to home page
page
Jay Error Error Unsuc
cessful
3. All Null All field null Unsucce Unsuccessf Unsuc
ssful to ul to Login cessful
Login

107 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3. Forgot Password
[Link] Field Input Expecte Actual Result
d
Output
Output
1. Email Jay.solanki0906@g Forgot Forgot Pass
[Link] password password
link sent link sent
[Link] Error Error Unsucc
m essful
2. New Jay@0906 New New Pass
Password Passwor Password
d Set Set
Successf Successfull
ully y
Jay Error Error Unsucc
essful

3. Confirm Jay@0906 Passwor Password Pass

Password d Recorded
Recorde Successfull
d y
Successf
ully
Jay Error Error Unsucc
essful

108 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System

4. Tour Package booking information

[Link] Field Input Expecte Actual Result
d
Output
Output
1. Name Jay Solanki Data Data added Pass
added
successfully
successf and display
ully and
message
redirect
to Booking
payment Successfull
page y

1234 Error Error Unsucce

ssful
2. Email Jay.solanki0906@g Data Data added Pass
[Link] added
successfully
successf and redirect
ully and to payment
redirect page
to
payment
page
[Link] Error Error Unsucce
m ssful

109 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System

3. Phone 7016756529 Data Data added Pass

number added
successfull
successf y and
ully and redirect to
redirect payment
to page
payment
page
123 Error Error Unsucce
ssful
4. Payment Cash/payu Get Get Pass
mode payment payment
and and proceed
proceed further
further
5. All null All field null Error Error Unsucce
ssful

110 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
5. Car Booking
[Link] Field Input Expecte Actual Result
d
Output
Output
1. Pick up Pij Road, Napad, Data Data Pass
location Nadiad, Gujarat, Record Record
India Successf Successfull
ully y
Xyz Error Error Unsucce
ssful
2. Name Jay Solanki Data Data added Pass
added
successfully
successf and display
ully and
message
redirect
to Booking
payment Successfull
page y

1234 Error Error Unsucce

ssful

111 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3. Email Jay.solanki0906@g Data Data added Pass
[Link] added
successfully
successf and redirect
ully and to payment
redirect page
to
payment
page
[Link] Error Error Unsucce
m ssful
4. Phone 7016756529 Data Data added Pass
number added
successfull
successf y and
ully and redirect to
redirect payment
to page
payment
page
123 Error Error Unsucce
ssful
5. Payment Cash/payu Get Get Pass
mode payment payment
and and proceed
proceed further
further
6. All null All field null Error Error Unsucce
ssful

112 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6. Taxi booking
[Link] Field Input Expected Actual Result
Output Output
1. Pick up Pij Road, Napad, Data Data Pass
location Nadiad, Gujarat, Record Record
India Successfu Successfull
lly y
Xyz Error Error Unsucce
ssful

2. Drop-of- "Pulwama Rd, Data Data Pass

location Muchhpuna Record Record
192301" Successfu Successfull
lly y
Xyz Error Error Unsucce
ssful

3. Pick up 30/3/2022 Data Data Pass

date Record Record
Successfu Successfull
lly y
30/3/2001 Error Error Unsucce
ssful

113 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System

4. Pick up 10:20 Pm Data Data Pass

time Record Record
Successfu Successfull
lly y
- Error Error Unsucce
ssful
5. Name Jay Solanki Data Data added Pass
added
successfully
successfu and display
lly and
message
redirect to
payment Booking
page Successfull
y
1234 Error Error Unsucce
ssful

6. Email Jay.solanki0906@g Data Data added Pass

[Link] added
successfully
successfu and redirect
lly and to payment

114 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
redirect to page
payment
page
[Link] Error Error Unsucce
m ssful
7. Phone 7016756529 Data Data added Pass
number added
successfull
successfull y and
y and redirect to
redirect to payment
payment page
page
123 Error Error Unsucce
ssful
8. Payment Cash/payu Get Get Pass
mode payment payment
and and proceed
proceed further
further
9. All null All field null Error Error Unsucce
ssful

115 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
7. Contact Us
[Link] Field Input Expecte Actual Result
d
Output
Output
1. Name Jay Solanki Data Data sent Pass
sent
successfully
successf
ully
13mn Error Error Unsucce
ssful
2. Email Jay.solanki0906@g Data Data sent Pass
[Link] sent
successfully
successf
ully
[Link] Error Error Unsucce
ssful
3. Mobile no. 12334 Data Data sent Pass
sent
successfully
successf
ully
9428022578 Error Error Unsucce
ssful

116 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
4. Message Good service Data Data sent Pass
sent
successfully
successf
ully
- Error Error Unsucce
ssful
5. All null All field null Error Error Unsucce
ssful

 Admin Side
1.) Add Booking
[Link] Field Input Expected Actual Result
Output Output
1. Source Vijayawada, Data Data Pass
Andhra Pradesh, Recorder Recorder
India successfu successfully
lly
Xyz Error Error Unsucc
essful
2. Destination "Upleta Rd, Sonal Data Data Pass
Nagar, Upleta, Recorder Recorder
Gujarat, India" successfu successfully
lly
Abc Error Error Unsucc
essful

3. Pick-up- 30/3/2022 Data Data Record Pass

117 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
date Record Successfully
Successfu
lly
30/3/2001 Error Error Unsucc
essful

4. Pick-up- 10:20 Pm Data Data Record Pass

time Record Successfully
Successfu
lly
- Error Error Unsucc
essful
5. Status Pending Data Data Record Pass
Record Successfully
Successfu
lly
- Error Error Unsucc
essful
6. Name Jay Solanki Data Data Pass
Record Record
Successfu Successfull
lly y
13mn Error Error Unsucc
essful

118 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
7. Email Jay.solanki0906@g Data Data Pass
[Link] Record Record
Successfu Successfull
lly y
[Link] Error Error Unsucc
essful
8. Mobile no. 12334 Data Data Pass
Record Record
Successfu Successfull
lly y
9428022578 Error Error Unsucc
essful

9. All null All field null Error Error Unsucc

ssful

119 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
2.) Search Booking
[Link] Field Input Expected Actual Result
Output Output
1 From Date 30-3-22 Get all Get all Pass
booking booking
details details
from from
chosen chosen date
date
- Error Error Unsucc
essful
2 To date 6-4-22 Get all Get all Pass
booking booking
details details
from from
chosen chosen date
date
- Error Error Unsucc
essful
3 All null All field null Error Error Unsucc
essful

120 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3.) Add Vehicle
[Link] Field Input Expected Actual Result
Output Output
1. Category General/premium Data Data added Pass
added to to database
database
- Error Error Unsucc
essful

2. Name Renault Kiger Data Data added Pass

added to to database
database
- Error Error Unsucc
essful

3. Model SUV Data Data added Pass

added to to database
database
- Error Error Unsucc
essful
4. Car GJ-03-2002 Data Data added Pass
number added to to database
database

121 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
- Error Error Unsucc
essful
5. Fuel type Petrol/diesel/gas Data Data added Pass
added to to database
database
- Error Error Unsucc
essful
6. Passenger 7 Data Data added Pass
capacity added to to database
database
- Error Error Unsucc
essful
7. Large 10 Data Data added Pass
Luggage added to to database
Capacity database
Xyz Error Error Unsucc
essful

8. Small 1 Data Data added Pass

Luggage added to to database
Capacity database
Xyz Error Error Unsucc
essful

122 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
9. Cost 2000 Data Data added Pass
Starting added to to database
From (₹) database

Xyz Error Error Unsucc

essful
10. All null All field null Error Error Unsucc
essful

4.) Add packages

[Link] Field Input Expected Actual Result
Output Output
1. Package Run of Kutch Data Data added Pass
Name added to to database
database
- Error Error Unsucc
essful
2. Source Nadiad Data Data added Pass
added to to database
database
Error Error Unsucc
essful
3. Destinati Kutch Data Data added Pass
on added to to database
database
Error Error Unsucc
essful

123 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
4. Arrival 26-3-22 Data Data added Pass
Date added to to database
database

- Error Error Unsucc

essful
5. Arrival 12:30pm Data Data added Pass
time added to to database
database

- Error Error Unsucc

essful
6. Departure 1:30pm Data Data added Pass
time added to to database
database

- Error Error Unsucc

essful
7. Status Pending Data Data added Pass
added to to database
database

- Error Error Unsucc

essful
8. Price 14000 Data Data added Pass
added to to database
database
Xyz Error Error Unsucc
essful

124 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
9. All null All field null Error Error Unsucc
essful

5.) Add Customer Admin side

[Link] Field Input Expected Actual Result
Output Output
1. First Jay Data added Data added Pass
name
successfully to Edited
and display
and display
message
message
successfully
successfully
1234567 Error Error Unsucce
ssful
2. Last Solanki Data added Data added Pass
name
successfully to Database
and display
and display
message
message
successfully
successfully
- Error Error Unsucce
ssful

125 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3. Email Jay.solanki0906@ Data added Data added Pass
[Link]
successfully to Database
and display
and display
message
message
successfully
successfully
[Link].c Error Error Unsucce
om ssful

4. Mobile 9428022578 Data added Data added Pass

Number successfully
to Database
and display
and display
message
message
successfully
successfully
Jay Solanki Error Error Unsucce
ssful
5. Passwor Jay@0402 Data added Data added Pass
d successfully successfully
and display and display
message message
successfully successfully
Xyz Error Error Unsucce
ssful

126 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6. Confirm Jay@0402 Data Data Pass
Passwor recorded recorded
d successfully successfully
and display and display
message message
successfully successfully
Xyz Error Error Unsucce
ssful
7. Status Active/inactive Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucce
ssful

8. All Null All field null Data not Data not Unsucce
ssful
added into added into
database database

127 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6.) Site Setting
[Link] Field Input Expected Actual Result
Output Output
1. Site tile Car rental system Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
2. Site url [Link] Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful

128 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
3. Address 13 sky Tatva Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
4. City Nadiad Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
5. State Gujarat Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful

129 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6. Country India Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
7. Pin code 360450 Data Data Pass
recorded recorded
successfully successfully
and display and display
message message
successfully successfully
1234567890 Error Error Unsucc
essful
8. Mobile 9428022578 Data Data Pass
no. recorded recorded
successfully successfully
and display and display
message message
successfully successfully
23 Error Error Unsucc
essful

130 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
9. Land 7698876987 Data Data Pass
line recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
10. Contact Jay.solanki0906@gm Data Data Pass
email [Link] recorded recorded
successfully successfully
and display and display
message message
successfully successfully
[Link] Error Error Unsucc
essful
11. Powered Creative werk Data Data Pass
by recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful

131 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
12. URL [Link] Data Data Pass
Powered recorded recorded
by successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
13. Right Copy right Data Data Pass
Reserved recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
14. Date Mm/dd/yyyy Data Data Pass
format recorded recorded
successfully successfully
and display and display
message message
successfully successfully
- Error Error Unsucc
essful

132 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
15. Google AIzaSyDPV759MXY Data Data Pass
api key wrfbR- recorded recorded
kQFJulFqiS61M524B successfully successfully
U
and display and display
message message
successfully successfully
- Error Error Unsucc
essful
16. All Null All field null Data not Data not Unsucc
essful
added into added into
database database

133 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
7.) Add testimonial
[Link] Field Input Expected Actual Result
Output Output
1. Title Taxi Booking Data added Data added Pass
successfully successfully

- Error Error Unsucc

essful
2. Author Jay Solanki Data added Data added Pass
successfully successfully

- Error Error Unsucc

essful
3. Description Description Data added Data added Pass
successfully successfully

- Error Error Unsucc

essful
4. Status Active/Inactive Data added Data added Pass
successfully successfully

- Error Error Unsucc

essful

134 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
5. All Null All field null Data not Data not Unsucc
essful
added into added into
database database

8.) Email Setting

[Link] Field Input Expected Actual Result
Output Output
1. Host ssl://[Link] Data added Data added Pass
successfully successfully
- Error Error Unsucce
ssful
2. Email jay.solanki0906@gm Data added Data added Pass
[Link] successfully successfully
[Link] Error Error Unsucce
ssful

3. Password ****** Data added Data added Pass

successfully successfully
- Error Error Unsucce
ssful
4. Port 465 Data added Data added Pass
successfully successfully
- Error Error Unsucce
ssful

135 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
5. All Null All field null Data not Data not Unsucce
ssful
added into added into
database database

9.) Payu setting

[Link] Field Input Expected Actual Result
Output Output
1. Test rjQUPktU Data added Data added Pass
Merchant successfully successfull
Key y
- Error Error Unsucce
ssful
2. Test Salt e5iIg1jwi8 Data added Data added Pass
successfully successfull
y
- Error Error Unsucce
ssful
3. Live Live Merchant Key Data added Data added Pass
Merchant successfully successfull
Key y
- Error Error Unsucce
ssful
4. Live Salt Live Salt Data added Data added Pass
successfully successfull
y

136 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
- Error Error Unsucce
ssful
5. Mode Live/test Data added Data added Pass
successfully successfull
y
- Error Error Unsucce
ssful

6. All Null All field null Data not Data not Unsucce
ssful
added into added into
database database

10.) Add waiting

[Link] Field Input Expected Actual Result
Output Output
1. Waiting 20 Data added Data added Pass
Time successfully successfully
Uhbjh Error Error Unsucc
essful
2. Cost (₹) 30 Data added Data added Pass
successfully successfully
Jbksdc Error Error Unsucc
essful
3. Status Active Data added Data added Pass
successfully successfully

137 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
- Error Error Unsucc
essful
4. All Null All field null Data not Data not Unsucc
essful
added into added into
database database

11.) Reason to book with us

[Link] Field Input Expected Actual Result
Output Output
1. Reason Reasons to book with Data added Data added Pass
to book us successfully successfully
- Error Error Unsucc
essful
2. Content Responsive web site Data added Data added Pass
successfully successfully
- Error Error Unsucc
essful
3. Status Active Data added Data added Pass
successfully successfully
- Error Error Unsucc
essful
4. All Null All field null Data not Data not Unsucc
essful
added into added into
database database

138 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
12.) Coupons
[Link] Field Input Expected Actual Result
Output Output
1.) Coupon Summer coupon Data added Data added Pass
title successfully successfully
- Error Error Unsuc
cessful
2.) Coupon Su12 Data added Data added Pass
code successfully successfully
- Error Error Unsuc
cessful
3.) Discount 20rs Data added Data added Pass
Amount successfully successfully
Error Error Unsuc
cessful
4.) From 1/4/2022 Data added Data added Pass
successfully successfully
2/2/2022 Error Error Unsuc
cessful
5.) To 6/6/2022 Data added Data added Pass
successfully successfully
3/3/2022 Error Error Unsuc
cessful

139 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
6.) Status Active Data added Data added Pass
successfully successfully
- Error Error Unsuc
cessful
7.) All Null All field null Data not Data not Unsuc
cessful
added into added into
database database

140 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System
13.) FAQ’s
[Link] Field Input Expected Actual Result
Output Output
1. Question How Can I Book My Data added Data added Pass
Tour with You? successfully successfully
Error Error Unsucc
essful
2. Answer If you are interested Data added Data added Pass
in booking any of our successfully successfully
tours,, You may
simply send us an
email giving us your
details
Error Error Unsucc
essful
3. Status Active Data added Data added Pass
successfully successfully

- Error Error Unsucc

essful
4. All Null All field null Data not Data not Unsucc
essful
added into added into
database database

141 | P a g e Jay A. Solanki

Krish V. Bhatt
 D.D.U. Car Rental System

Scope and Limitations:

Scope:
o Car Rental System is developing for web based car booking
system which provides booking for car, taxi and also tour
packages.
o Our project provides different features like Email, Notifications,
invoice ,PDF reports ,today booking and latest user bookings
history .
o Any user can contact for getting the system related information.
Limitations:
• It is for a particular city.
• All the communication is provided through email.
• For taxi service only a particular route is available.
• Login is only available through email or Google login.

142 | P a g e Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

Future Enhancement
o The Taxi Services will have different route for each destination.
o User will be able to login through facebook.
o We will include sms service to customer.
o We will expand our system state-wise too.

143 | P a g e Jay A. Solanki

Krish V. Bhatt
D.D.U. Car Rental System

References and Bibliography

• [Link]
• [Link]
• [Link]
• [Link]
• [Link]
• [Link]

144 | P a g e Jay A. Solanki

Krish V. Bhatt