Book My Trip

BOOK MY TRIP

A Project Report Submitted by

SMIT KACHHAD - 91800104011

KARAN BHATT - 91800104014
JENIL CHANDARANA - 91800104040
SMIT RAICHURA - 91800104041

in partial fulfilment for the award of the degree of

Bachelor of Technology
in
Information Technology

Faculty of Technology
Marwadi University, Rajkot
2021-22

I
 Faculty of Technology
Marwadi University
Department of Information Technology
2021-22

CERTIFICATE

This is to certify that the project entitled Book My Trip has been carried out by

Smit Raichura - 91800104041, Smit Kachhad - 91800104011, Jenil

Chandarana - 91800104040, Karan Bhatt - 91800104014 under my guidance

in partial fulfilment of the degree of Bachelor of Technology in Information

Technology of Marwadi University, Rajkot during the academic year 2021-22.

Date: ____________________

Internal Guide Head of the Department

Prof. Kajal Tanchak Dr. Damodaran P

Assistant Professor Head Of Department
 Book My Trip

Acknowledgments

I have taken efforts in this project. However, it would not have been possible
without the kind support and help of many individuals. I would like to
extend my sincere thanks to all of them. I am highly indebted to Prof.
Kajalben Tanchak for their guidance and constant supervision as well as for
providing necessary information regarding the project & also for their
support in completing the project. I would like to express my gratitude
towards my parents for their kind co-operation and encouragement which
help me in completion of this project.

II
 Book My Trip

Index
Institute’s Vision and Mission...........................................................................................IV
Department’s Vision and Mission ..................................................................................... V
PEO, POs and PSOs .........................................................................................................VI
Abstract ................................................................................................................................ X
List of Tables ......................................................................................................................XI
List of Figures ................................................................................................................... XII

1 Introduction .................................................................................................................. 1
1.1 Problem Summary ................................................................................................. 1
1.2 Aim and Objectives................................................................................................ 1
1.3 Proposed System .................................................................................................... 1
1.4 Literature Review................................................................................................... 2
1.5 Plan of the work ..................................................................................................... 2
1.6 Materials/Tools Requirements ............................................................................... 4
2 Analysis, Design Methodology and Implementation Strategy ................................. 5
2.1 Observation Matrix ................................................................................................ 5
2.2 Ideation Canvas ...................................................................................................... 5
2.3 Product Development Canvas ................................................................................ 6
2.4 Database Design..................................................................................................... 6
2.5 System Design ....................................................................................................... 9
3 Implementation .......................................................................................................... 13
3.1 Implemented Functionality .................................................................................. 13
3.2 Results and Reports.............................................................................................. 13
3.3 Snapshots ............................................................................................................. 14
4 Conclusion .................................................................................................................. 26
4.1 Summary of the results ........................................................................................ 26
4.2 Advantages of your work/results/methodologies................................................. 26
4.3 Scope of future work ............................................................................................ 26
4.4 Attainment of POs and PSOs ............................................................................... 26
Appendix ..................................................................................................................... 28

III
 Book My Trip

Institute’s Vision and Mission

Institute’s Vision

Our vision is to address challenges facing our society and planet through sterile education
that builds capacity of our students and empower them through their innovative thinking
practice and character building that will ultimately manifest to boost creativity and
responsibility utilizing the limited natural resources to meet the challenges of the 21st
century.

Institute’s Mission

• To Produce creative, responsible and informed professionals

• To produce individuals who are digital-age literates, inventive thinkers, effective

communicators and highly productive.

• To deliver cost-effective quality education

• To offer world-class, cross-disciplinary education in strategic sectors of economy

though well devised and synchronized delivery structure and system, designed to
tackle the creative intelligence and enhance the productivity of individuals.

• To provide a conducive environment that enables and promotes individuals to

creatively interact, coordinate, disseminate and examine change, opinion as well
as concept that will enable students to experience higher level of learning acquired
through ceaseless effort that lead to the development of character, confidence,
values and technical skills.

IV
 Book My Trip

Department’s Vision and Mission

Department’s Vision

To be recognized as a team delivering educational excellence that advances teaching,

learning and research, in alignment with Marwadi Education Foundation's mission and
goals.

Department’s Mission

• To impart knowledge and skills related to under graduate program offered by the
department.

• To impart technical and professional skills to make graduates competitive and

capable.

• To constantly encourage and motivate graduates for innovation,

entrepreneurship& industry-readiness.

• To inspire graduates for higher education and research and to place graduates in
leading industries and companies.

V
 Book My Trip

PEO, PO and PSO

Program Educational Objectives (PEO):

Our graduated students are expected to fulfill the following Program Educational
Objectives (PEOs):

1. Core Competency: Successfully apply fundamental mathematical, scientific, and

engineering principles in formulating and solving engineering and real life problems
for betterment of society.

2. Breadth: Will apply current industry accepted practices, new and emerging
technologies to analyse, design, implement and maintain state of art solutions.

3. Professionalism: Work effectively and ethically in ever changing global professional

environment and multi-disciplinary environment.

4. Learning Environment: Demonstrate excellent communication and soft skills to

fulfil their commitment towards social responsibilities and foster life-long learning.

5. Preparation: Promote research and patenting to enhance technical and

entrepreneurship skills within them.

VI
 Book My Trip

Program Outcomes (POs)

Engineering Graduates will be able to:

PO1: Engineering knowledge: Apply the knowledge of mathematics, science,

engineering fundamentals, and an engineering specialization to the solution of complex
engineering problems.

PO2: Problem analysis: Identify, formulate, review research literature, and analyze
complex engineering problems reaching substantiated conclusions using first principles of
mathematics, natural sciences, and engineering sciences.

PO3: Design/development of solutions: Design solutions for complex engineering

problems and design system components or processes that meet the specified needs with
appropriate consideration for the public health and safety, and the cultural, societal, and
environmental considerations.

PO4: Conduct investigations of complex problems: Use research-based knowledge

and research methods including design of experiments, analysis and interpretation of data,
and synthesis of the information to provide valid conclusions.

PO5: Modern tool usage: Create, select, and apply appropriate techniques, resources,
and modern engineering and IT tools including prediction and modeling to complex
engineering activities with an understanding of the limitations.

PO6: The engineer and society: Apply reasoning informed by the contextual
knowledge to assess societal, health, safety, legal and cultural issues and the consequent
responsibilities relevant to the professional engineering practice.

PO7: Environment and sustainability: Understand the impact of the professional

engineering solutions in societal and environmental contexts, and demonstrate the
knowledge of, and need for sustainable development.

PO8: Ethics: Apply ethical principles and commit to professional ethics and
responsibilities and norms of the engineering practice.

PO9: Individual and team work: Function effectively as an individual, and as a

member or leader in diverse teams, and in multidisciplinary settings.

VII
 Book My Trip

PO10: Communication: Communicate effectively on complex engineering activities

with the engineering community and with society at large, such as, being able to
comprehend and write effective reports and design documentation, make effective
presentations, and give and receive clear instructions.

PO11: Project management and finance: Demonstrate knowledge and understanding of

the engineering and management principles and apply these to one’s own work, as a
member and leader in a team, to manage projects and in multidisciplinary environments.

PO12: Life-long learning: Recognize the need for, and have the preparation and ability
to engage in independent and life-long learning in the broadest context of technological
change.

VIII
 Book My Trip

Program Specific Outcomes (PSOs)

PSO1. Graduates shall have knowledge in nucleus areas of Information Technology and
related engineering so as to grasp engineering trade-offs, analyze, design, and synthesize
data and technical concepts to form products and solutions for the real life problems.

PSO2. Graduates shall have competence to take challenges associated with future
technological issues in various domains such as security, database design, advance
software development etc.

IX
 Book My Trip

Abstract
Book My Trip is website developed for online tour booking. There has been a huge

increase in tourism in past decade and especially online tour booking. But online tour and

ticket booking systems are still in the early phase. Before online booking systems, people

used to physically go to some travel agency for tour booking but this problem has been

resolved by this project. User can view all tour packages, check availability and book

package online. This leads to efficient and fast management.

X
 Book My Trip

List Of Tables

Table No. Table Description Page No

Table 2.4.1 Admin 6

Table 2.4.2 User 7

Table 2.4.3 Tour Packages 7

Table 2.4.4 Booking 7

Table 2.4.5 Issue 8

Table 2.4.6 Enquiry 8

Table 2.4.7 Pages 8

Table 4.4.1 Attainment of POs and PSOs 26

XI
 Book My Trip

List of Figures

Figure No. Figure Description Page No

Fig. 2.1.1 Observation Matrix 5

Fig. 2.2.1 Ideation Canvas 5

Fig. 2.3.1 Product Development Canvas 6

Fig. 2.5.1 User Data Flow Diagram 9

Fig. 2.5.2 Admin Data Flow Diagram 9

Fig. 2.5.3 Data Flow Diagram 10

Fig. 2.5.4 Admin UML Diagram 10

Fig. 2.5.5 User UML Diagram 11

Fig. 2.5.6 Class Diagram 11

Fig. 2.5.7 Entity Relationship Diagram 12

Fig. 3.3.1 Homepage 14

Fig. 3.3.2 User Sign Up 15

Fig. 3.3.3 User Sign In 15

Fig. 3.3.4 View Package 16

Fig. 3.3.5 Package Details 17

Fig. 3.3.6 User Profile 18

Fig. 3.3.7 Post Enquiry 18

Fig. 3.3.8 Raise Issue 19

Fig. 3.3.9 User Password Change 19

Fig. 3.3.10 User Tour History 20

Fig. 3.3.11 View Raised Issues 20

Fig. 3.3.12 Admin Dashboard 21

XII
 Book My Trip

Fig. 3.3.13 Create Tour Package 21

Fig. 3.3.14 Manage Tour Package 22

Fig. 3.3.15 Manage Users 22

Fig. 3.3.16 Update Tour Package 23

Fig. 3.3.17 Admin Manage Tour Booking 23

Fig. 3.3.18 Admin Manage Issues 24

Fig. 3.3.19 Admin Manage Enquiries 24

Fig. 3.3.20 Update Pages 25

XIII
 Book My Trip

List of Tables

Table No. Table Description Page No

Table 2.3.1 User 5

Table 2.3.2 Customer 5

Table 2.3.3 Restaurant 6

Table 2.3.4 Items 6

XIV
 Book My Trip

1. Introduction

1.1 Problem Summary

• In the present system a customer has to approach various agencies to find details
of places and to book tickets.
• This often requires a lot of time and effort.
• A customer may not get the desired information from these offices and often the
customer may be misguided.
• It is tedious for a customer to plan a particular journey and have it executed
properly.

1.2 Aim and Objectives

• The objective of the project is to develop a system that automates the

processes and activities of a travel and tourism agency.
• The purpose is to design a system using which one can perform all operations
related to traveling and sight-seeing.

1.3 Proposed System

• The proposed system is a web-based application and maintains a centralized

repository of all related information.

• The system allows one to easily access the relevant information and make
necessary travel arrangements.

• Users can decide about places they want to visit then check availability and make
bookings online for travel.

1
 Book My Trip

1.4 Literature Review

Potentially, all current travel and tourism transactions can be performed on-line on the
internet. The opportunity presented by the industry, now the biggest in the world, is huge.
The World Travel and Tourism Council (WTTC) reported in World Economic Impact
that Travel and Tourism – encompassing transport, accommodation, catering, recreation
and services for travelers – is expected to grow to US $5 trillion of economic activity by
2020.

Travel alone is now one of the largest on-line business-to-consumer product in the India
and on-line air travel is the largest in Europe (Dwyer et al, 1998). In Germany, the
leading on-line market in Europe, air travel has been the largest on-line revenue since
1997 and is predicted to be the largest revenue generator, at least until the year 2002
(Jupiter Communications, 1998c). In a report Leisure Travel Spend On The Web on-line
travel bookings was predicted to reach $2.5 trillion by the year 2020.

1.5 Plan of the work

To provide flexibility to the users, the interfaces have been developed that are accessible
through a browser. The GUI’S at the top level have been categorized as

1. Administrative user interface

2. The operational or generic user interface

The ‘administrative user interface’ concentrates on the consistent information that is

practically, part of the organizational activities and which needs proper authentication for
the data collection. These interfaces help the administrators with all the transactional
states like Data insertion, Data deletion and Data.

The ‘operational or generic user interface’ helps the end users of the system in
transactions through the existing data and required services. The operational user
interface also helps the ordinary users in managing their own information in a customized
manner as per the included flexibilities.

2
 Book My Trip

Feasibility Study:

Preliminary investigation examines project feasibility; the likelihood the system will be
useful to the organization. The main objective of the feasibility study is to test the
Technical, Operational and Economical feasibility for adding new modules and
debugging old running system. All systems are feasible if they are given unlimited
resources and infinite time. There are aspects in the feasibility study portion of the
preliminary investigation:

• Technical Feasibility
• Operation Feasibility
• Economical Feasibility

Technical Feasibility:

The technical issue usually raised during the feasibility stage of the investigation includes
the following:
• Does the necessary technology exist to do what is suggested?
• Do the proposed equipments have the technical capacity to hold the data required
to use the new system?
• Will the proposed system provide adequate response to inquiries, regardless of the
number or location of users?
• Can the system be upgraded if developed?
• Are there technical guarantees of accuracy, reliability, ease of access and data
security?

Operational Feasibility:

Proposed projects are beneficial only if they can be turned out into information systems,
which will meet the organization’s operating requirements. Operational feasibility aspects
of the project are to be taken as an important part of the project implementation. Some of
the important issues raised are to test the operational feasibility of a project includes the
following:

3
 Book My Trip

• Is there sufficient support for the management from the users?

• Will the system be used and work properly if it is being developed and implemented?
• Will there be any resistance from the user that will undermine the possible application
benefits?

This system is targeted to be in accordance with the above-mentioned issues. Beforehand,

the management issues and user requirements have been taken into consideration. So,
there is no question of resistance from the users that can undermine the possible
application benefits. The well-planned design would ensure the optimal utilization of the
computer resources and would help in the improvement of performance status.

Economic Feasibility:

A system can be developed technically and that will be used if installed must still be a
good investment for the organization. In the economical feasibility, the development cost
in creating the system is evaluated against the ultimate benefit derived from the new
systems. Financial benefits must exceed the costs. The system is economically feasible. It
does not require any additional hardware or software.

1.6 Materials / Tools required

Hardware Configuration:

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor

• 2 GB RAM

• 40 GB HDD

Software Configuration:

• OS: Windows 7

• PHP Triad (PHP5.6, MySQL, Apache, and PHPMyAdmin)

• Web Browser (Firefox/Chrome/Edge)

4
 Book My Trip

2. Analysis, Design Methodology and Implementation

2.1 Observation Matrix

Fig. 2.1.1 Observation Matrix

2.2 Ideation Canvas

Fig. 2.2.1 Ideation Canvas

5
 Book My Trip

2.3 Product Development Canvas

Fig. 2.3.1 Product Development Canvas

2.4 Database Design

Table 2.4.1 Admin

6
 Book My Trip

Table 2.4.2 User

Table 2.4.3 Tour Packages

Table 2.4.4 Booking

7
 Book My Trip

Table 2.4.5 Issue

Table 2.4.6 Enquiry

Table 2.4.7 Pages

8
 Book My Trip

2.5 System Design

Fig. 2.5.1 User Data Flow Diagram

Fig. 2.5.2 Admin Data Flow Diagram

9
 Book My Trip

Fig. 2.5.3 Data Flow Diagram

Fig. 2.5.4 Admin UML Diagram

10
 Book My Trip

Fig. 2.5.5 User UML Diagram

Fig. 2.5.6 Class Diagram

11
 Book My Trip

Fig. 2.5.7 Entity Relationship Diagram

12
 Book My Trip

3. Implementation

3.1 Implemented Functionalities

• User Registration

• User Authentication

• User Profile

• View Tour Package

• Check Availability and Price

• Book Tour Package

• Raise Query

• Post Inquiry

• Add/Manage/Delete Tour Package

• User Management

• Query and Inquiry Management

3.2 Results and Reports

Admin first needs to add tour package. User has to register and login to book
package. Guest user can post inquiry and view tour packages.

13
 Book My Trip

3.3 Snapshots

Fig. 3.3.1 Homepage

14
 Book My Trip

Fig. 3.3.2 User Sign Up

Fig. 3.3.3 User Sign In

15
 Book My Trip

Fig. 3.3.4 View Package

16
 Book My Trip

Fig. 3.3.5 Package Details

17
 Book My Trip

Fig. 3.3.6 User Profile

Fig. 3.3.7 Post Enquiry

18
 Book My Trip

Fig. 3.3.8 Raise Issue

Fig. 3.3.9 User Password Change

19
 Book My Trip

Fig. 3.3.10 User Tour History

Fig. 3.3.11 View Raised Issue

20
 Book My Trip

Fig. 3.3.12 Admin Dashboard

Fig. 3.3.13 Create Tour Package

21
 Book My Trip

Fig. 3.3.14 Manage Tour Package

Fig. 3.3.15 Manage Users

22
 Book My Trip

Fig. 3.3.16 Update Tour Package

Fig. 3.3.17 Admin Manage Tour Booking

23
 Book My Trip

Fig. 3.3.18 Admin Manage Issues

Fig. 3.3.19 Admin Manage Enquiries

24
 Book My Trip

Fig. 3.3.20 Update Pages

25
 Book My Trip

4. Conclusion

4.1 Summary of Results:

• Successful operation of all functionalities.

4.2 Advantage of your work/results/methodologies:

This project helps reduce waiting times for traveller by eliminating the need of physically
going to any travel agency. User can directly login to website and check package details
online itself and then book the tour. Thus, it is fast, efficient and proper management is
followed.

4.3 Scope of future work:

As the world is progressing, most of the things are getting online. Manually going to
travel agency for tour booking is an inefficient process. Online tour and ticket booking
systems are more efficient and thus every agency would upgrade to online booking
systems in near future. This would save their time, manpower, paper and infrastructure.

4.4 Attainment of POs and PSOs:

Table 4.4.1 Attainment of POs and PSOs

26
 Book My Trip

27
 Book My Trip

Appendix A – Review Cards

28
 Book My Trip

29
 Book My Trip

30
 Book My Trip

31
 FACULTY OF TECHNOLOGY
Department of Information Technology
01IT0801 – Major Project-II

Semester: 8 (A.Y.2021
(A.Y.2021-22)
REVIEW CARD: REVIEW 2

Team ID - Team Size: Project / Internship

Name
Enrollment No.
Class
Internal Guide
Title of Project
Name of Industry (in case of
internship)
Performance Evaluation (Out of 60 marks)
Faculty Name Reviewer 1 Reviewer 2
(Internal Guide) (External Reviewer)

10 marks: Status, execution and submission project

related documents as per the Suggestions / comments /
corrections received during review-1.
10 marks: Design aspects (DB design, ER diagram, Class
diagram, UML diagram etc.)
10 marks: Prototype and framework

10 marks: Soft skills, Gesture & Posture, Presentation

quality
10 marks: Technical knowledge/depth of knowledge of
student
10 marks: Assigned by the guide for regular reporting,
updating on progress etc.

Remarks / Suggestion

Remarks / Suggestion Name & Signature

Reviewer 1
(Internal Guide)

Reviewer 2
(External Reviewer)

32
 FACULTY OF TECHNOLOGY
Department of Information Technology
01IT0801 – Major Project-II

Semester: 8 (A.Y.2021
(A.Y.2021-22)
REVIEW CARD: REVIEW 2

Team ID - Team Size: Project / Internship

Name
Enrollment No.
Class
Internal Guide
Title of Project
Name of Industry (in case of
internship)
Performance Evaluation (Out of 60 marks)
Faculty Name Reviewer 1 Reviewer 2
(Internal Guide) (External Reviewer)

10 marks: Status, execution and submission project

related documents as per the Suggestions / comments /
corrections received during review-1.
10 marks: Design aspects (DB design, ER diagram, Class
diagram, UML diagram etc.)
10 marks: Prototype and framework

10 marks: Soft skills, Gesture & Posture, Presentation

quality
10 marks: Technical knowledge/depth of knowledge of
student
10 marks: Assigned by the guide for regular reporting,
updating on progress etc.

Remarks / Suggestion

Remarks / Suggestion Name & Signature

Reviewer 1
(Internal Guide)

Reviewer 2
(External Reviewer)

33
 FACULTY OF TECHNOLOGY
Department of Information Technology
01IT0801 – Major Project-II

Semester: 8 (A.Y.2021
(A.Y.2021-22)
REVIEW CARD: REVIEW 2

Team ID - Team Size: Project / Internship

Name
Enrollment No.
Class
Internal Guide
Title of Project
Name of Industry (in case of
internship)
Performance Evaluation (Out of 60 marks)
Faculty Name Reviewer 1 Reviewer 2
(Internal Guide) (External Reviewer)

10 marks: Status, execution and submission project

related documents as per the Suggestions / comments /
corrections received during review-1.
10 marks: Design aspects (DB design, ER diagram, Class
diagram, UML diagram etc.)
10 marks: Prototype and framework

10 marks: Soft skills, Gesture & Posture, Presentation

quality
10 marks: Technical knowledge/depth of knowledge of
student
10 marks: Assigned by the guide for regular reporting,
updating on progress etc.

Remarks / Suggestion

Remarks / Suggestion Name & Signature

Reviewer 1
(Internal Guide)

Reviewer 2
(External Reviewer)

34
 FACULTY OF TECHNOLOGY
Department of Information Technology
01IT0801 – Major Project-II

Semester: 8 (A.Y.2021
(A.Y.2021-22)
REVIEW CARD: REVIEW 2

Team ID - Team Size: Project / Internship

Name
Enrollment No.
Class
Internal Guide
Title of Project
Name of Industry (in case of
internship)
Performance Evaluation (Out of 60 marks)
Faculty Name Reviewer 1 Reviewer 2
(Internal Guide) (External Reviewer)

10 marks: Status, execution and submission project

related documents as per the Suggestions / comments /
corrections received during review-1.
10 marks: Design aspects (DB design, ER diagram, Class
diagram, UML diagram etc.)
10 marks: Prototype and framework

10 marks: Soft skills, Gesture & Posture, Presentation

quality
10 marks: Technical knowledge/depth of knowledge of
student
10 marks: Assigned by the guide for regular reporting,
updating on progress etc.

Remarks / Suggestion

Remarks / Suggestion Name & Signature

Reviewer 1
(Internal Guide)

Reviewer 2
(External Reviewer)

35