TITLE
Designed Database for Booking
Vacation with Aifa Travel Agent
for Customer
ABSTRACT
Travel Agent was established to provide high standard of
services suitable for tourists, comfortable and memorable
experience in the hospitality. Therefore, Aifa Travel Agent
has provided our companys position as the leading travel
agency in the whole world. As to achieve the vision, our
mission was to develop employers with great
characteristics in all aspects such as attitude and
appearance. As for a company, we have our own constraint
and one of them was online booking must be done a month
before the date of vacation.We manage to construct our ER
diagram from travel agent survey requirement.
COMPANY
SITUATION
AiFa Travel Agent was authorized by Aina Amirah binti Baharin. AiFa Travel Agent
was established to ease customers who want to travel around the world by
providing a complete package which include destination, place to stay,
transportation and a tour guide that will bring our customer to visit the interesting
places in their chosen destination. Our manager is Nur Faiqah Aqilah binti Fuaad
and our travel agent was owned by Nurul Iffah binti Mohd Fauzi. Aifa Travel Agent is
a new company in this field. Our company was established since 2015, and we are
located in Kuala Lumpur. As a new company, we are facing some problems such as
lack of intelectual staffs and companys financial are not stable yet to develop our
company and make it become well-known. Hence, our company cannot attract
many customer to cooperate with us. Instead of our lackness, we also have our own
strengthness in providing the best facilities for all nations. We also provided online
booking to ease our customers so that they do not have to come to our office to
book for their vacation. We also provide you with services in and out of country. We
also have created an apps to ease our customers and to remind them. In the apps,
we include the status of booking, online booking, schedule of your vacation, types of
transportation that you are going to use to get to your destination and a map that
can be a guideline for you to go and visit the interesting places. Last but not least,
our main focus is to make our company as the best travel agency in the world with
our organized data and the service provided will satisfied our customer as customer
is our companys life.
COMPANY
OBJECTIVE
To provide the best service for
customers as they are the highest
priority for our companys
development.
To ease people who want to travel
around the world but do not know
where to stay and where to visit.
COMPANY
MISSION
To develop employers with moral
values, integrity, creative and critical
thinking based on aqli and naqli.
To produce a high quality customer
services so that it will satisfy our
customers with our provided services
and facilities.
COMPANY
VISSION
To strengthen our companys position
as the leading travel agency in the
whole world providing the best facilities
and qualities features for all nations.
To make our company become wellknown for the whole world.
PROBLEMS
CONTRACTING
~ storing of contracts of different
hotels and resorts.
~ most travel companies uses excel
sheets for storing the details of the
contracted properties
LACK OF SKILLED LABOR
~ lack of skilled human resources is
one of the major challenges faced by
the travel agents and the tour
operators.
~ the knowledge level of the staff and
their expertise in making use of the
technology determines the success of a
travel agency.
CONSTRAINT
S
One staff cannot handle more than 44
customers
Online booking for vacation must be
done a month before the date of
vacation
Pets are not allowed to bring to the
vacation
Payment must be settled three days
before the date of vacation
USER
REQUIREME
NT
JOB SCOPE
DATABASE ADMINISTRATOR
~ responsible for the physical realization of the
database, including physical database design and
implementation, security and integrity control,
maintenance of the operational system, and ensuring
satisfactory performance of the applications for users.
~ takes the initiative to resolve problems and ensures
that the application is running well with respect to the
database
DATABASE DESIGNER
~ aware of the functionality of the target DBMS
~ must understand the advantages and
disadvantages of each alternative
implementation.
~ assists staff with internal systems,
applications, and databases, including
developing procedures, forms, and other
organizational tools.
DATABASE ANALYST
~ Evaluates existing database and
recommend improvements for
performance efficiency.
BOUNDARY
HUMAN
RESOURCES
MONEY
EXCHANGE
ACCOUNTING
CUSTOMER
SERVICES
BOOKING
TRANSPORTATIO
N
PLANNING
ER DIAGRAM
HUMAN
RESOURCES
STAFF
manage
HUMAN
RESOURCES
CUSTOMER
SERVICE
TRANSPORTATION
SEMANTIC
DIAGRAM
CUSTOMER
SERVICES
CTA01
CTA02
CTA03
CTA04
.
.
.
.
Many customer services
serve zero or many
customer
MANAGES
.
.
.
.
r1
r2
r3
r4
TRANSPORTATIO
N
.
.
.
TP001
TP009
TP005
Many customer is
served by one or many
customer
HUMAN
RESOURCES
HR01
HR02
HR03
HR04
.
.
.
.
TRAINS
.
.
.
.
r1
r2
r3
r4
STAFFS
.
.
.
SID456
SID567
SID123
TRANSPORTATIO
N
PL01
PL02
PL03
.
.
.
.
BS04
MANAGES
.
.
.
.
r1
r2
r3
r4
LOCATION
.
.
.
.
SABAH
JAPAN
AUSTRALIA
LANGKAWI
