TOURISM MANAGEMENT APPLICATION

DEPARTMENT OF Computer science

MOBILE APPLICATION DEVELOPMENT
PROJECT REPORT FILE

PROJECT:

TOURISM MANAGEMENT APPLICATION

GROUP MEMBERS:

Tanzila Yaseen Ghanchi

Anusha Hussain

ID NO:

CSC-21F-125

CSC-21F-021

SUBMITTED TO:

Sir. Abdullah Ayub

SEMESTER AND SECTION:

6th –“A

page 1
TOURISM MANAGEMENT APPLICATION

CHAPTER 1
INTRODUCTION
1.1 INTRODUCTION TO DBMS

Database is a collection of related data and data is collection of facts and figure that can
be procedure information.
Mostly data represents recordable facts. Data aids in producing information, which is
based on facts. For example, if we have data about marks obtained by all students, we
can then conclude about toppers and average marks.
A Database management system stores data in such a way that it becomes easier to
retrieve, manipulate, and produce information.

1.2 ABOUT SQL

SQL is a language to operate database; it includes database creation, deletion, fetching

rows, modifying rows, etc. SQL is an ANSI (American National Standards Institute)
standard language, but there are many different versions of SQL language.

What is SQL:

SQL is a Structured Query Language, which is a computer language for storing,

manipulating and retrieving data stored in a relation database.

SQL is the standard language for Relational Database System. All the Relation Database
Management System (RDBMS) like My SQL, MS Access, Oracle, Sybase, Informix,
Postgres and SQL Server use SQL as their standard database language.

1.3 USER INTERFACE DESIGN

1.3.1 GRAPHICAL USER INTERFACES

A graphical user interface (GUI) is a type of interface that allows users to interact with
electronic devices or programs through graphical icons and visual indicators such as
secondary notation, as opposed to text-based interfaces, typed command labels or text
navigation. GUIs

page 2
TOURISM MANAGEMENT APPLICATION

are easier to learn than command-line interfaces (CLIs), which require commands to be typed
on the keyboard.
Third-party proprietary and free graphical administration applications (or "front ends") are
available that integrate with MySQL and enable users to work with database structure and
data visually. Some well-known front ends are:

MySQL Workbench
MySQL Workbench is the official integrated environment for MySQL. It was developed by
MySQL AB, and enables users to graphically administer MySQL databases and visually
design database structures. MySQL Workbench replaces the previous package of software,
MySQL
GUI Tools. Similar to other third-party packages, but still considered the authoritative
MySQL front end, MySQL Workbench lets users manage database design & modelling, SQL
development (replacing MySQL Query Browser) and Database administration (replacing
MySQL Administrator).
MySQL Workbench is available in two editions, the regular free and open source Community
Edition which may be downloaded from the MySQL website, and the proprietary Standard
Edition which extends and improves the feature set of the Community Edition.

1.3.2 COMMAND LINE INTERFACES

A command-line interface is a means of interacting with a computer program where the user
issues commands to the program by typing in successive lines of text (command lines). MySQL
ships with many command lines tools, from which the main interface is the MySQL client.
MySQL Utilities is a set of utilities designed to perform common maintenance and administrative
tasks. Originally included as part of the MySQL Workbench, the utilities are a stand-alone
download available from Oracle.
1.4 PROJECT DESCRIPTION:
The main objective of the Tourism Management 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.

page 3
TOURISM MANAGEMENT APPLICATION

 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 package and can make cancellation.

page 4
TOURISM MANAGEMENT APPLICATION

page 5
TOURISM MANAGEMENT APPLICATION

CHAPTER 2
REQUIREMENTS SPECIFICATION

2.1 SOFTWARE SPECIFICATION

• Operating system: Microsoft windows 10.

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

2.2 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

page 6
TOURISM MANAGEMENT APPLICATION

CHAPTER 3
SYSTEM DESIGN
3.1 INTRODUCTION

System design is the process of defining the elements of a system such as the architecture,
modules and components, the different interfaces of those components and the data that goes
through that system. It is meant to satisfy specific needs and requirements of a business or
organization through the engineering of a coherent and well-running system.
System designing in terms of software engineering has its own value and importance in the
system development process as a whole. To mention it may though seem as simple as anything or
simply the design of systems, but in a broader sense it implies a systematic and rigorous approach
to design such a system which fulfils all the practical aspects including flexibility, efficiency and
security.
Before there is any further discussion of system design, it is important that some points be
made clear. As it goes without saying that nothing is created that is not affected by the world in
which it’s made. So, the systems are not created in a vacuum.
They are created in order to meet the needs of the users. They are not only intended to
solve the existing problems, but they also come up with acceptable solutions to the problems that
may arise in the future. The whole process of system development, from blueprint to the actual
product, involves considering all the relevant factors and taking the required specifications and
creating a useful system based on strong technical, analytical and development skills of the
professionals.
Let’s get back to our discussion about what the system design phase is and the importance
of system design in the process of system development. Being another important step in the
system development process, system designing phase commences after the system analysis phase
is completed. It’s appropriate to mention that the output or the specifications taken through the
phase of system analysis become an input in the system design phase which in turn leads to
workout based on the user defined estimations.
The importance of this phase may be understood by reason of the fact that it involves
identifying data sources, the nature and type of data that is available. For example, in order to
design a salary system, there is a need for using inputs, such as, attendance, leave details,
additions or deductions etc. This facilitates understanding what kind of data is available and by
whom it is supplied to the system so that the system may be designed considering all the relevant
factors. In addition, system designing leads to ensure that the system is created in such a way that
it fulfils the need of the users and keep them at ease being user-oriented.

page 7
TOURISM MANAGEMENT APPLICATION

3.2 SCHEMA DIAGRAM:

A database schema is the skeleton structure that represents the logical view of the entire database.
It defines how the data is organized and how the relations among them are associated. It
formulates all the constraints that are to be applied on the data.
A database schema defines its entities and the relationship among them. It contains a descriptive
detail of the database, which can be depicted by means of schema diagrams. It’s the database
designers who design the schema to help programmers understand the database and make it
useful.

Account:
usernam name password security answer
e

Customer:
usernam id id_number name gender country address phone email
e

Book package:
usernam package person id id_numbe phone price
e s r

Book Hotel:
usernam hotel persons days ac food id id_numbe phone price
e r

Hotel:
hotel cost_per_day food_charges ac_charges

page 8
TOURISM MANAGEMENT APPLICATION

3.3 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, ovals to define attributes and diamond shapes to represent relationships.

page 9
TOURISM MANAGEMENT APPLICATION

3.3 The above figure represents the ER Diagram.

CHAPTER 4
IMPLEMENTATION

4.1 DESCRIPTION OF TABLES:

TABLE 4.1.1: ACCOUNT:

Field Type Null Key Default Extra

username varchar(30) NO PRI NULL

Name varchar(30) NO PRI NULL
password varchar(30) NO NULL

page 10
TOURISM MANAGEMENT APPLICATION

security varchar(30) NO NULL

Answer varchar(30) NO NULL

TABLE 4.1.2: CUSTOMER:

Field Type Null Key Default Extra

username varchar(30) NO MUL NULL

id varchar(30) NO PRI NULL
id_number varchar(30) NO NULL
name varchar(30) NO NULL
gender varchar(30) NO NULL
country varchar(30) NO NULL
address varchar(30) NO NULL
phone varchar(30) NO NULL
email varchar(30) NO NULL
TABLE 4.1.3: BOOK PACKAGE:
Field Type Null Key Default Extra

username varchar(30) NO MUL NULL

package varchar(30) NO NULL
persons int(10) NO NULL
id varchar(30) NO MUL NULL
id_number varchar(30) NO NULL
phone varchar(30) NO PRI NULL
price varchar(30) NO NULL
TABLE 4.1.4: BOOK HOTEL:
Field Type Null Key Default Extra

username varchar(30) NO MUL NULL

hotel varchar(30) NO MUL NULL
persons int(10) NO NULL
days int(10) NO NULL
Ac varchar(30) NO NULL
food varchar(30) NO NULL
Id varchar(30) NO MUL NULL
id_number varchar(30) NO NULL
phone varchar(30) NO MUL NULL
price varchar(30) NO NULL

TABLE 4.1.5: HOTEL:

Field Type Null Key Default Extra

page 11
TOURISM MANAGEMENT APPLICATION

hotel varchar(30) NO PRI NULL

cost_per_day int(10) NO NULL
food_charges int(10) NO NULL
ac_charges Int(10) NO NULL

4.2 TRIGGERS AND STORED PROCEDURE:

TRIGGERS:
A trigger is a named database object that is associated with a table, and that activates when
a particular event occurs for the table. Some uses for triggers are to perform checks of values to be
inserted into a table or to perform calculations on values involved in an update.
A trigger is defined to activate when a statement inserts, updates, or deletes rows in the
associated table. These row operations are trigger events. A trigger can be set to activate either
before or after the trigger event. For example, you can have a trigger activate before each row that
is inserted into a table or after each row that is updated.

Trigger used in this application:

create trigger `trigger_on_login` after insert on `customer` for each row insert into
users(username,id,id_number,name,country,gender,address,phone,email)
values(NEW.username,NEW.id,NEW.id_number,NEW.name,NEW.country,NEW.gender,
NEW.address,NEW.phone,NEW.email);

STORED PROCEDURE:
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and
over again. So, if you have an SQL query that you write over and over again, save it as a stored
procedure, and then just call it to execute it. You can also pass parameters to a stored procedure,
so that the stored procedure can act based on the parameter value(s) that is passed.
The most important part is parameters. Parameters are used to pass values to the Procedure.
There are 3 different types of parameters, they are as follows:
 IN: This is the Default Parameter for the procedure. It always receives the values from
calling program.

 OUT: This parameter always sends the values to the calling program.

 IN OUT: This parameter performs both the operations. It Receives value from as well
as sends the values to the calling program.

Stored Procedure used in above application:

To select all the data from customer table:

page 12
TOURISM MANAGEMENT APPLICATION

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getCustomer`
BEGIN
SELECT * FROM CUSTOMER;
END;
DELIMITER;

CHAPTER 5
TESTING
Test Test case Input Steps to Expected Result Actual Pass/Fail
cases Data execute the Result
test case
No.
1 Login Wrong After A proper A Pass
Screen username entering the message message
or data click indicating the was
password on the login error should displayed
button appear and the saying
user should be Invalid
redirected to username
login screen. or
password
2 Insertion If any After A proper A message Pass
field was entering the message was

page 13
TOURISM MANAGEMENT APPLICATION

not data click indicating the displayed

entered. on the create error should saying
button appear and the Enter all
user should be the details
redirected to properly
customer screen.
3 Deletion If any After A proper A message Pass
field was entering the message was
not data click indicating the displayed
entered. on the delete error should saying
button appear and the Enter all
user should be the details
redirected to properly
customer screen.
4 Update If any After A proper A message Pass
field was entering the message was
not data click indicating the displayed
entered. on the update error should saying
button appear and the Enter all
user should be the details
redirected to properly
update customer
screen.

CHAPTER 6
CONCLUSION AND FUTURE ENHANCEMENT

The process of the system we can consider here, can maintain the databases of the
system. We can insert to the databases and retrieve all the information.
The main aim of this project is to help the tourists to manage their trip. It makes all
operation of the tour company easy and accurate. The standalone platform makes tourism
management easy by handling requests and providing servers for the customers located at
different parts of the various
cities. Different modules have been incorporated in this project to handle different parts and sector
of the tour management field.

page 14
TOURISM MANAGEMENT APPLICATION

CHAPTER 7
SNAPSHOTS

LOGIN PAGE:

page 15
TOURISM MANAGEMENT APPLICATION

LOADING PAGE:

MAIN FRAME:

page 16
TOURISM MANAGEMENT APPLICATION

PERSONAL DETAILS:

UPDATE CUSTOMER PAGE:

page 17
TOURISM MANAGEMENT APPLICATION

VIEW CUSTOMER PAGE:

PACKAGE PAGE:

page 18
TOURISM MANAGEMENT APPLICATION

page 19
TOURISM MANAGEMENT APPLICATION

BOOK PACKAGE:

page 20
TOURISM MANAGEMENT APPLICATION

VIEW PACKAGE:

BOOK HOTEL:

page 21
TOURISM MANAGEMENT APPLICATION

HOTEL/RESORT PAGE:

VIEW HOTEL:

page 22
TOURISM MANAGEMENT APPLICATION

DESTINATION PAGE:

PAYMENT:

page 23
TOURISM MANAGEMENT APPLICATION

ABOUT PAGE:

page 24
TOURISM MANAGEMENT APPLICATION

CHAPTER 8
REFERENCES

We have taken references from many resources like many websites.

Websites:
• https://www.w3schools.com
• https://www.javatpoint.com
• https://www.codecademy.com
• https://www.stackoverflow.com

page 25