Travel_Agencies

idnamelocation
1WorldWide TravelsNew York
2EuroTrip ExpeditionsLondon
3Asian AdventuresTokyo
4African ExplorersCape Town
5Americas DiscoveriesMiami

Destinations

iddestination_name
1Europe
2Asia
3Africa
4North America
5South America
6Australia

Accommodations

idaccommodation_typecapacity
1Hotel300
2Resort600
3Hostel80
4Bed & Breakfast20
5Villa10

Tours

idtour_nameduration
1City Tour1
2Beach Vacation7
3Mountain Trekking10
4Cultural Experience14
5Adventure Package12

Bookings

idtravel_agency_iddestination_idaccommodation_idtour_iddateprice
(→ Travel_Agencies.id)(→ Destinations.id)(→ Accommodations.id)(→ Tours.id)
111112023-06-153000
212222023-06-202500
321332023-07-014000
422442023-07-063500
531552023-07-114500

Travel_Agencies_Destinations

travel_agency_iddestination_id
(→ Travel_Agencies.id)(→ Destinations.id)
11
12
21
22
31
41
51