View the step-by-step solution to:

Question


微信图片_20200105145128.png

src="/qa/attachment/11007757/" alt="微信图片_20200105145123.jpg" />Hi Tutor,

I need to creat an EER diagram, the scenario is in the attachment.

Here I draw an EER diagram, but I am not sure that the connection is right.

Could you help me to check my diagram and point out my problem?

Thanks and best regards

微信图片_20200105145123.jpg

signseeing
tour
tour
destination clate
Customer
YRH HH
with
K
travel
agency
culture
customer
other
name
purchasing
late
destination
date
customer
original
tours
furtomer ID
Place
book
F
travels
Buy
insurance
D
D
seperate
Mel
leeal
other
countries

微信图片_20200105145128.png

Your Dream Holidays is a small, but rapidly growing travel business operating out of Melbourne.
The owner, Mr. Colin Mcfarlane, started this business to organize sightseeing tours for tourists to
visit various tourism attractions in Victoria region. However, organizing sightseeing tours alone was
not profitable due to strong competitions in the market. Colin decided to expand the operations to
provide other types of travel experiences such as shopping and fashion tours, food and wine tours, and cultural and theme tours. Within a year of beginning his operation, Colin’s business has expanded their operations beyond Victoria region, to other states in Australia. He was also approached by tour operators in other
regions seeking his help in getting their services booked with tourists. All bookings can be made
through Your Dream Holidays, while the tours can be operated by lColin’s company itself or by other tour operators in specific regions. All tour bookings must specify an origin (starting location], a
destination (visiting location] and an operator for the tour. The tour bookings can be made by local
residents in Melbourne or tourists from anywhere in the world, prior to their arrival in Australia. Due to several incidents in the tourism industry, tourists are getting more and more concerns for
their safety and well—being. Colin’s company has partnered with insurance companies to provide a
wide range of travel insurance products to their clients. Tourists can purchase travel insurance as a part of their tour booking or separately for other travel purposes. A few years later, IColin found that he has become a travel agent with a network of 450 tour
operators and travel insurance providers around Australia. He is generating a reasonable income
from the commissions charged (5% of total transaction value). So far, his business has been operating with temporary notes scribbled on notebooks in
combination with a series of disorganised spread sheets. But these tools are becoming inefficient
and increasingly inapt at managing the growing demands of the business. A transition to an information system is urgently needed. The proposed business should support the operations of tour operators, insurance companies
and clients. Their interactions should be integrated into your EER model.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes