report on dss for uttar pradesh tourism authority

8/9/2019 Report on DSS for uttar pradesh tourism authority

1/20


2/20

1. Information extractionSystem should provide the relevant informationto the tourist people and vendors. It includes information about thefollowing things.

Organizational setup.

City heritage.

Hotel s in the city. Tours & travels.

Tenders.

Authority office addresses.

2. Governing the systemBased upon the present condition of the tourismin the state, administration should be able to take decisions. It includesthe following decisions.

Fund allocation to the cities.

Officers postings.

Availability of buses. Instructions to the cities for improvements.

Selection of tenders.

ASSUMPTIONS

The functionality of the system is based upon following assumptions.1. Authority has a single officer as an administrator.2. A Non-stop bus service will be provided between two specific cities (ex-

Agra and Allahabad, Agra and Lucknow etc.)3. The Intercity bus service will be provided from 8:00 am to 8:00 pm.

4. The attributes of feedback form are mutually exclusive and exhaustivein nature.

5. No respondent will fill the feedback form twice.6. Hotels will provide only two kinds of accommodation i.e., single bed

and double bed.


3/20

CHAPTER 2

DESIGN PHILOSOPHY

This chapter will cover the front end (HTML web pages) and backend (SQL tables)

design. The front end helps user to get interact with the system and back end usestables to store data.

FRONT END DESIGNThe state authority system mainly has two users.

1. Authority administrator.

2. Tourist and vendors.

Theauthority administrator can perform the following tasks.1. He/She can generate overall rating of cities.

2. He/She can generate attribute wise rating of cities.3. He/She can add, remove, update inter city and intra city bus details.4. He/She can add, remove, update hotels details.5. He/She can generate a report of bus scheduling.

Front end snap shots for authority administrator:


4/20


5/20


6/20


7/20


8/20

Tourists and vendors can perform the following tasks.

1. Vendors can see information about various tenders.

2. Tourists can see information about cities.

3. Tourists can see information about hotels of a particular city.

4. Tourists can see information about inter city and intra city bus services.

5. Tourists can submit the feedback form.

6. Tourist can see the office addresses of tourism authority.

Front end snap shots for tourists and vendors:


9/20


10/20


11/20


12/20


13/20

BACK END DESIGNBack end consists of following tables

1. TABLE FOR COSTUMER FEEDBACK

Coust_feedback (coust_no ,name,country,city,city_visit,

accommodation,historical,hospitality,tourism_info,safety,price_quality,age,dat

e )

2. TABLE FOR HOTELS.

Hotel (name, category, city, single_charge, double_charge, contact_person,

contact)

3. TABLE FOR TENDER.

Tender (t_name, t_no, date, city, comp_name, yoe, contact, email, exp,

application_no )

4. TABLE FOR BUS SERVICES.

Intracity (city, bus_no, start_time, end_time)


14/20

Intercity(start_city,end_city,bus_no,start_time,end_time)

SELECTION OF PRIMARY KEYS

TABLE PRIMARY KEY DESCRIPTION

Coust_feedb

ack

Coust_no All other columns can have same data in

different rows. Coust_no will store unique

serial no. of rows in it.

hotel Name ,city Hotels of same group can be there in differe

cities

tender T_no

intracity City,bus_no

intercity Start_city,end_city,bus_

no


15/20

CHAPTER 3

IMPLEMENTATION

Implementation deals with the modelling phase of the project. In this chapter we

will present the simple logic based arithmetic modelling of the STATE TOURISM

AUTHORITY.

The main purpose of the modelling is to facilitate the administrator, so that he can

take good decisions on time. In the following section we will present the modelling

approach of every decision.

RANKING OF CITIESThe feedback form of the tourist respondents provides rating for different tourism

attributes of the city. The respondent provides rating between 1(highly dissatisfied)

and 4(highly satisfied).

TOTAL SCORE

Total score for one respondent = of rating for each attribute

Total score of the city = ( score from each respondent) / (No. of respondent)

ATTRIBUTE WISE SCORE

Score of an attribute = ( score of the attribute from each respondent) / (No. of

respondent).

DECISIONS

1. The top three scorers will get an appreciation amount from the tourismauthority.

2. The bottom three scorers will get fund along with the instructions to use it on

some specific attributes.

3. Based on the attribute wise scores, authority will release officers transfer

order.


16/20

SHEDULING OF BUSESIn this part, system uses a simple network model that shows the connectivity of

different cities. The objective is to provide 8:00 AM to 8:00 PM uninterrupted bus

service between two connected cities, the next bus will available after the duration

of two hours.

The connectivity of cities along with the distances is shown in the following table.

CITY CONNECTED CITIES

SARNATH chitrakoot (100km)

vrindavan (150km)

VARANASI ayodhya (150 km) Allahabad (100km)

VRINDAVAN chitrakoot (150km)

sarnath (150 km)

The optimal solution of this network model is shown below.

CITY 1 2 3 4 5 6 7 8 9 10 111 - 4 0 0 0 0 4 3 0 0 02 4 - 0 0 0 3 2 0 0 2 03 0 0 - 0 0 0 0 4 0 3 04 0 0 0 - 0 0 0 4 2 0 35 1 0 0 0 - 0 5 0 0 0 06 0 3 0 0 0 - 4 0 0 0 07 4 2 0 0 5 4 - 0 0 0 0

LUCKNOW agra (150km)

ayodhya (200km)

chitrakoot (200km)

Kanpur (100km)

KANPUR agra (200 km) Allahabad (100km)

Jhansi (200km)

F.S (250 km)

AGRA lucknow (150km) Kanpur (200 km) Allahabad (200 km)

CHITRAKOOT lucknow (200km)

sarnath (100 km) vrindavan (150 km)

JHANSI Kanpur (200 km) allahabad (150km)

FATEHPUR SIKRI agra (50) Kanpur (250 km)

AYODHYA Varanasi (150 km) lucknow (200 km)


17/20

8 3 0 4 4 0 0 2 - 0 0 09 0 0 0 2 0 0 0 0 - 0 310 0 2 3 0 0 0 0 0 0 - 011 0 0 0 3 0 0 0 0 3 0 -

(1= Agra , 2= Allahabad , 3= Ayodhya , 4=Chitrakoot , 5=Fathepur sikri , 6=Jhansi ,

7=Kanpur , 8=Lucknow , 9=Sarnath , 10=Varanasi, 11=Vrindavan).

*Assuming the average speed of bus as 50 kmph.

DECISIONS

1. The requirement of buses at the various nodal points (connected cities) can

be determined.

CHAPTER 4

RESULTS

The DSS on State tourism authority system is providing following facilities todifferent users.

1. Tourists

Tourists can see information about cities.

Tourists can see information about hotels of a particular city.


18/20

Tourists can see information about inter city and intra city bus services.

Tourists can submit the feedback form.

Tourist can see the office addresses of tourism authority.

2. Vendors

Vendors can see information about various tenders.

3. Administrator

The DSS output will help administrator in following manner:


19/20


20/20

FUTURE SCOPE1. The model can be upgraded to provide booking facilities for buses and hotels.

2. The model can be upgraded to provide seasonal offers.

3. In the bus routes intermediate cities can also be considered.

LIMITATIONS1. We have not considered the constraint on availability of buses.

2. Tourism attributes of feedback form may not be exhaustive in nature.

REFRENCE1. www.up-tourism.com

2. www.incredibleindia.org

3. www.w3schools.com
http://www.up-tourism.com/http://www.incredibleindia.org/http://www.w3schools.com/http://www.up-tourism.com/http://www.incredibleindia.org/http://www.w3schools.com/

report on dss for uttar pradesh tourism authority

Documents