Using MySQL Workbench, create an EER DIAGRAM for question 3-32. Explain your reasoning around which supertypes/subtypes you identified, in particular, focus on the types completeness and disjointness constraints.

Question 3-32:

DRAW an EER diagram for the following problem: AmazingMemories, a travel agency, specializes in holiday to Southeast Asia. It provides bespoke holidays that are set up and handled by an agency rep. Each rep creates a new booking, which has an ID, hotel, hotel room, check in dates, and number of nights. Once costumer has chosen a hotel and hotel room, they can add up to three excursions that are offered within the vicinity of the hotel. Hotels and excursions are referred to as an itinerary, and customers can assign one or more itineraries to a booking. Often the customer making the booking is not actually the one going on holiday, therefore each booking has an assigned set of travelers.