Question: Develop ERD to support the needs for the following problem. While it is not necessary, feel free to write down your assumptions of the business

Develop ERD to support the needs for the

Develop ERD to support the needs for the following problem. While it is not necessary, feel free to write down your assumptions of the business rules to support your design. When you are finished, please submit a MS WORD file embedded with a ERD diagram created by MS Visio (Note, you may also submit a PDF file). A travel agency is frequently asked questions about tourist destination cities. For example, customers want to know details of the average climate for a particular month (e.g., temperature, humidity, precipitation, etc.), the population, and other geographic facts (e.g., airport name, etc.) of the cities. Sometimes, they request the flying time and distance (e.g., # of miles) between any two cities. Please draw a conceptual model (ERD) to maintain the above facts. [Assumption: each city has only one airport]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!