联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp2

您当前位置:首页 >> Java编程Java编程

日期:2021-06-13 05:55

Project Case Study – Semester 3

Travel Management System:

John is working as a Java Developer in Dream Travel Inc. He has been assigned a task to

develop a software “Travel Management System”. Currently the Contact details of all the

tourists are being stored in a physical register maintained by the various receptionists. This

current process of storing details leads to the following problems:

1. Contacts are not being added on time

2. Old contacts are not being updated systematically.

3. Searching Contact details are tedious job for receptionist.

4. As one receptionist finishes his/her duty, another receptionist will take over the

responsibility, which creates lots of confusion for them, because they are not aware of

what manipulations has done by earlier person.

John has decided to develop an application by considering the following guidelines:

1. First of all, whenever this software gets open, Dream Travel admin should enter his/her

Username & password in order to use this application.

2. After the successful login, admin will be redirected to the Home Panel, where he will find

the following options.

a. Tour Packages option: By clicking on Tour packages button he/she will switched to

Tour Packages Frame

b. Tourist Record option: by clicking on Tourist record Button: By clicking on Tourist

Record button he/she will switched to Tour Packages Frame

3. If the admin chooses Tourist Record, admin will be able to add new tourist record,

update existing tourist record and in addition to that admin can able to see all tourist

list and also can delete any record, if required.

Here, after clicking on Add tab, New Tourist record can be added.

For this, the admin has to enter the following details.

1. Name

2. Contact No.

3. Address

4. Nationality

5. Passport No. of a particular tourist

If the admin click on Edit option, Admin can change the following details by choosing his/her

passport number from the drop down list:

1. Name

2. Contact no.

3. Address

4. Nationality (from drop down list)

By clicking on Delete tab, the Tourist record can be deleted, for this his/her passport number

should be selected from the drop down list.

Tour Packages Option:

In Tour Packages option, admin will be able to add new tour packages and edit/ delete

existing tour packages.

Here for adding tour package, Admin will click on Add tab, then

1. Enter package name

2. Enter package code

3. Enter Country

4. Enter days

5. Enter Itinerary

Now the admin can submit the records, by clicking on Submit button, then the new tour

package will be added.

The admin can also reset the wrongly entered data, by clicking on Reset button.


Next, the admin can edit a package and also delete a package.

By clicking on delete tab and entering the details of,

1. Package Name

2. Package Code

And then by clicking on Delete button, any existing tour package will be deleted.

Finally to view any Tourist record or Tour Package, admin can directly go to View frame.

To view tour packages records, admin should click on Tour Packages Info.

Admin can able to all Tourist Information by clicking on Tourist Information Button.

In any page, if the admin clicks on Log Out button, it will redirect the admin to the Login Page.

Database Design

This Project will have the following Tables:

field type describe_en

i d int primary key, not null

username varchar(50) user name, not null

password varchar(50) user password, not null

User

field type describe_en

package_name varchar(50) not null

package_code varchar(50) primary key, not null

country varchar(50) not null

no_of_days int not null

itinerary varchar(100)not null

Tour Packages

field type describe_en

name varchar(50) not null

contact_no varchar(50) not null

address varchar(50) not null

nationality varchar(10) not null

passport_no varchar(50) primary key, not null

Tourists Information


版权所有:留学生编程辅导网 2020 All Rights Reserved 联系方式:QQ:99515681 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。