Question

In: Math

d. A travel agency is frequently asked questions about tourist destinations. For example, customers want to...

d. A travel agency is frequently asked questions about tourist destinations. For
example, customers want to know details of the climate for a particular month,
the population of the city, and other geographic facts. Sometimes they request
the flying time and distance between two cities. The manager has asked you to
create a database to maintain these facts.

Solutions

Expert Solution

Customers want to know details of the climate for a particular month,

the population of the city, and other geographic facts. sometimes,they request the flying time and distance between two cities .

The manager has asked you to create a database to maintain these facts.

DESTINATION

DestinationID DestinationName Population PlacesToVisit

Destination table will consists of an ID ( primary key), the destinatin name, population, placestovisit etc.

Destination_Weather

DestinationId Month Climate

This table will contain the destination and its weather for a particular month. Here the primary key is (destiation_id + month)

DESTINATION_DISTANCE

DESTINATION_ID LATITUDE LONGITUDE

This table will contain the latitude and longitude of a particular destination. So when user queries for a distance between any two cities, based on the latitude and longitude values of the two cites, we can write a program to calculate the distance and return the result.

AIRLINE_DIST_TIME

AIRLINE DISTANCE TIME

This table consists of the particular airline and how much distnace is covered in what time is stored.

So when user asks for the time taken by a particular airline between two places, we can query the destination latitude and longitudes from the destination_dist tables , and calculate the distances between the two destinations.

Then based on the distance to be covered and the particular airline, we can search on the AIRLINE_DIST_TIME to determine the time required.


Related Solutions

Draw a data model for the following: A travel agency is frequently asked questions about tourist...
Draw a data model for the following: A travel agency is frequently asked questions about tourist destinations. For example, customers want to know details of the climate for a particular month, the population of the city, and other geographic facts. Sometimes they request the flying time and distance between two cities. The manager has asked you to create a database to maintain these facts.
research about the importance of travel agency
research about the importance of travel agency
The manager of a travel agency asked you to come up with a forecasting technique that...
The manager of a travel agency asked you to come up with a forecasting technique that will best fit to the actual demand for packaged tours. You have observed and recorded the actual demand for the last 10 periods. You also identified two possible techniques for consideration: 2-month moving averages (F1), and exponential smoothing (F2) with a smoothing constant of 0.40. Using Cumulative Forecasting Error (CFE) and Mean Absolute Deviation (MAD) as your performance measures you will determine the technique...
The manager of a travel agency asked you to come up with a forecasting technique that...
The manager of a travel agency asked you to come up with a forecasting technique that will best fit to the actual demand for packaged tours. You have observed and recorded the actual demand for the last 10 periods. You also identified two possible techniques for consideration: 2-month moving averages (F1), and exponential smoothing (F2) with a smoothing constant of 0.40. Using Cumulative Forecasting Error (CFE) and Mean Absolute Deviation (MAD) as your performance measures you will determine the technique...
One of the questions most frequently asked by prospective home buyers along the east coast of...
One of the questions most frequently asked by prospective home buyers along the east coast of the United States is: If we purchase this home, how much can we expect to pay to heat it during the winter? The research department at Herrington Real Estate has collected the following information. Temperature = Mean Outside Temperature (F); Attic = Attic insulation (in inches). Home Mean Outside Temperature (degrees) Attic Insulation (inches) Monthly Heating Costs ($) 1 18 3 188 2 34...
One of the questions most frequently asked by prospective home buyers along the east coast of...
One of the questions most frequently asked by prospective home buyers along the east coast of the United States is: If we purchase this home, how much can we expect to pay to heat it during the winter? The research department at Herrington Real Estate has collected the following information. Temperature = Mean Outside Temperature (F); Attic = Attic insulation (in inches). Home Mean Outside Temperature (degrees) Attic Insulation (inches) Monthly Heating Costs ($) 1 18 3 188 2 34...
write a report about travel agency in c++ not a program writing just report writing
write a report about travel agency in c++ not a program writing just report writing
I want letter about appreciation,to appreciate agency give me scholarship . please I want typing because...
I want letter about appreciation,to appreciate agency give me scholarship . please I want typing because I don't understand handwriting thanks
1) Explain about Macro environment and how its effect on travel agency recent Covid 19 pandemic....
1) Explain about Macro environment and how its effect on travel agency recent Covid 19 pandemic. 2) how to improve and manage by company macro environment effect ?
Some interesting generalities are frequently made about Egyptian art. For example, it has been said that...
Some interesting generalities are frequently made about Egyptian art. For example, it has been said that the spirit of the Old Kingdom is best expressed in the pyramids, that of the Middle Kingdom in its sculpture, and that of the New Kingdom in its painting. Does this statement seem justified to you? Support your answer with a discussion of relevant works of art.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT