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

Transcribed Image Text:

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. ● ● ● ● 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. ● ● ● ●