A Project Report on

“Travels Booking System”

By

Mr. Bhavesh Kishor Duggad

MCA – I, SEM – I

2023-2024

To
Savitribai Phule Pune University
Pune- 411041

In Partial Fulfillment of the Degree of

Master in Computer Application (M. C. A.)

Under The Guidance Of

Prof. Adarsha Katrale Mam

Suryadatta Institutes of Management, Pune

Suryadatta Institute of Management and Mass Communication (SIMMC)
 Date:-

CERTIFICATE

This is to certify that Mr. / Ms. _________________________________, has successfully

completed his/her project work entitled “_Travel Booking System” in partial fulfillment of

MCA– I Semester program for the year A.Y. 2023-2024 . He / She have worked under our

guidance and direction.

Prof. Adarsha Katrale Dr. Manisha Kumbhar

(Project Guide) HOD-MCA, SGI

Examiner 1 Examiner 2

Date:

Place:
 Acknowledgment
We started this project as a part of our course curriculum. It gives us great pleasure to present the report of this
project work conducted towards the fulfillment of the project titled “Travel Booking System”.

We take this opportunity to thank those who have made the efforts in success of the project. We extend our special
gratitude towards Prof. Dr. Manisha Kumbhar (Head of the Department of MCA) and lecturer Prof.
Adarsha Katrale (internal guide) who has been a constant source of motivation, encouragement, and
guidance that has gone a long way in helping the completion of this project. We express our warm wishes to the entire
staff members for their assistance and kind guidance who helped me out of all my queries.

I also heartily thankful to all my friends and “Live Life” for providing me all the useful requirements that were needed
by me for the completion of project.

Thank You

Mr. Bhavesh Kishor Duggad

 Index
Chapter Page number
CHAPTER 1 : INTRODUCTION
1.1 Existing System
1.2 Need for System
1.3 Operating Environment Hardware and
Software
CHAPTER 2 : PROPOSED SYSTEM
2.1 Proposed System (Introduction of system)
2.2 Module specifications (Scope)
2.3 Objectives of System
CHAPTER 3 : ANALYSIS & DESIGN
3.1 Use Case Diagrams
3.2 Activity Diagram
3.3 E-R Diagram
3.3 Module Hierarchy Diagram
3.4 Table specifications (Database design)
3.5 Data dictionary
CHAPTER 4 : USER MANUAL
4.1 User Interface Screens (Input)
4.2 Output Screens with data
4.3 Data Reports
4.4 Sample program code
4.5 Limitations and Bibliography
 Introduction

1.1Existing System

• In existing system there are lots of paper work and manual processing.
 • Records very carefully as the entire data is written in those book

• Everything is paper based hence it is very time consuming more than person can’t access the
data at same time

• There is no system to check the past transactions on any bill, to do this they have to check
payment register and this task is too much time consuming and tiresome.

• The manually system work very difficult and very complex for manages celebration.

1.2 Need For System

• Keep proper records of items.

• It also maintains correct and quick processing to get some printed output or records. Bills, Paid
amount, Balance amount, etc.

• The main objective of this system to store large amount of data within less time.

• The most important objective is to provide the security. Authority security and further
privacy and also provide management of information very quickly.

• To overcome some problem that comes during existing system.

• Now the day, everyone lives with very fast life; no one can wait a time consuming so new
system do the necessary and speedy job daily monthly yearly easily and quickly.

1.3Operating Environment Hardware and Software

The Travel Booking System shall function on the PC provided by the system. This entails the
system to operate on the Windows CE platform. The Travel Booking System shall interface
between Windows CE designated to store the records. The Web Server and Database Software
have not been established at this point. The Travel Booking System will record all the essentials
details of each particular User related data. Pentium 3.0 GHz or higher RAM must be 1 Gb or
more and Hard disk.

SOFTWARE SPECIFICATION

• Operating system: Microsoft windows 11/10/7.

• Integrated Development Environment: Netbeans
• MySQL Command Line Client
• Programming language: JAVA

HARDWARE SPECIFICATION

• System type: 64-bit Operating System, x64-bassed processor.

• Installed memory (RAM):8.00 GB (7.43 GB Usable)
• Total size of Hard disk: 1 TB
PROPOSED
SYSTEM

2.1 Proposed System (Introduction of system)

 The main objective of the Travels Booking System is to manage the details of Customer, Hotel
Booking, Cancellation and Tourism places. It manages all the information about Users, Hotel,
Packages etc. The project is totally built at administrative end and thus only the administrator is
guaranteed the access to the backend database. The purpose of this project is to build an
application program to reduce the manual work for managing Tourists, Booking, Places etc.
.
 This application will help in accessing the information related to the travel to the particular
destination with great ease. The users can track the information related to their tours with great
ease through this application. The travel agency information can also be obtained through this
application.

 Through this system, the propose system is highly automated and makes the travelling
activities much easier and flexible. The user can get the very right information at the very right
time. This system will include all the necessary fields which are required during online
reservation time. This system will be easy to use and can be used by any person. The basic idea
behind this project is to save data in a central database which can be accessed by any authorize
person to get information and saves time and burden which are being faced by their customers.

 Administrator can access and modify the information stored in the database of this system,this
includes adding and updating of details, and it will give accurate information and simplifies
manual work and also it minimizes the documentation related work. Provides up to date
information. Finally booking confirmation notification will be send to the users.

 Tourists can register by providing personal details,make new reservation and book only one
hotel and packageand can make cancellation.

Introduction to proposed system:

 Computer is manmade machine. It takes some data as input process as per instruction and
give result very quickly and accurately. System is an orderly grouping interdependent component
linked together to according to plan to achieve specific objective.
There are many drawbacks in manual system. To overcome these all drawbacks there is
need of computerization there are many chances of mistakes while calculation. When calculation
is performed on computer, we get more accuracy than manual work. It is easy to generate reports
which can received quickly therefore it save the time and energy so fact is reduce man power
automatically.
In proposed system when we enter information for new entries, details of event on computer
then within fraction of time report will generate. As well as we see total information of particular
customer and also we removed particular record from computer and the information about
particular field is updated automatically you can create bill receipt on these proposed system. We
can see reports at any time on system.

2.2 Module specifications (Scope)

1) Saving of man power:

Due to computerization, there is consideration saving in manpower and time because all billing
related activities are carried out automatically.

2) Accuracy and efficiency:

No wrong data is possible because of the validation checks by system.

3) Early and correct decision making:

Because of fast communication, report making procedure is simplified and fast.

4) Immediate response to problems:

Due to computerization the problems which are related to billing can be reduced.

5) Advantages of computerization:
To overcome limitation of existing system, computerization is correct choice of computer in any
field and it reduce the time required to do a particular job.
 2.3 Objectives of System
The main reason behind the development of the system is to overcome the problems
and provide the good and quick Reports of Travel system.

The system consists many objectives as follows:

1) To increase efficiency and make work effective.

2) This system also uses to current and quick working.

3) To reduce manpower and paperwork.

4) The objective of this system is to store large amount of data with less space and less time.

5) To introduce drawbacks of manual system.

6) To provide good service and give desired and accurate result.

7) There is no loss of data.

8) Using computer software addition, modification, view, deletion of record is quickly possible.

The main objective is to provide accuracy in the billing. It helps to customer and owner also for
errorless transactions. The paperwork has too many errors while billing. To resolve this problem
this system is developed.
ANALYSIS
& DESIGN
3.1 Use Case Diagram

visit site
Ll login

R Registration

User Profile

Package Hotels

Booking

actor CCancel Booking

FFeedback

Report
3.2 class diagram

User Booking
User _name Package_name char
password Hotel _ name char

Updatedetails() Bookpackage()
Deletedetails() Bookhotels()
cancelBooking()

Package Hotels

- Package_id - Hotel_name char

int
- Package_nam
e char
checkHotels()
checkPackage()

Add customer Update customer Delete customer

details details details
Name _ char Name _ char Name _ char
Id _ int Id _ int Id _ int
Address _ char Address _ char Address _ char

AddCustomer Updatecustomer DeleteCustomer

-details () -details() -details()
3.3 Activity Diagram

start

LL Login

no yes

valid user

B View B View V view A Add D Delete

Package Hotel Destination Customer Customer

yes no
B Book Book Hotel
Package

D Update
Customer

LL Logout

end
 3.4 E-R Diagram
ER Diagram stands for Entity Relationship Diagram, also known as ERD is a diagram that
displays the relationship of entity sets stored in a database. In other words, ER diagrams help to
explain the logical structure of databases. ER diagrams are created based on three basic concepts:
entities, attributes and relationships.ER Diagrams contain different symbols that use rectangles to
represent entities, ova to define attributes and diamond shapes to represent relationships.

3.5 sequence diagram

 Login success customer package Hotels Booking

Add/edit add/edit add/edit

Login
To
page
save/update
save/
update

manage
customer

manage
package

Manage
hotels

manage
bookings