Question: Draw an EER diagram for the following problem: A travel company specializes in holidays to Hong Kong. It provides customized holidays that are set

Draw an EER diagram for the following problem:  A travel company specializes in holidays to Hong Kong.  It

Draw an EER diagram for the following problem: A travel company specializes in holidays to Hong Kong. It provides customized holidays that are set up and handled by a sales representative. A rep is described by an identifier, first name, and last name. Each rep can create several new bookings, which has an identifier. A hotel is described by an identifier, name, location, and rating. Each hotel room is described by an identifier, name, room type, room capacity, and price. Once a customer has chosen a hotel and hotel room, they can add up to three excursions that are offered within the vicinity of the hotel. An excursion is described by an identifier, name, price, and duration. Hotels and excursions are referred to as an itinerary, and customers can assign one or more itineraries to a booking. Each itinerary is described by an identifier, date, and total price. Often the customer making the booking is not actually the one going on holiday, therefore each booking has an assigned set of travelers. A customer who makes the booking is described by an identifier, first name, last name, and address.

Step by Step Solution

3.48 Rating (148 Votes )

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 Programming Questions!