Travel_Agencies

AgencyIDNameAddressContactNumber
1Explorer Tours123 Exploration St.+1 9876543210
2World Wanderers456 Adventure Blvd.+1 9876543211

Online_Booking_Platforms

PlatformIDNameWebsite
1GoTripwww.gotrip.com
2VacayFinderwww.vacayfinder.com

Tours

TourIDDestinationNameDuration
1Machu Picchu5
2Eiffel Tower3

Bookings

BookingIDCustomerIDTourIDTravelAgencyIDOnlinePlatformIDStartDateEndDate
(→ Customers.CustomerID)(→ Tours.TourID)(→ Travel_Agencies.AgencyID)(→ Online_Booking_Platforms.PlatformID)
111112022-06-152022-06-20
222222022-07-152022-07-20

Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1 9876543212
2JaneSmithjane.smith@example.com+1 9876543213