Travel_Agencies
| id | name | location |
| 1 | WorldWide Travels | New York |
| 2 | EuroTrip Expeditions | London |
| 3 | Asian Adventures | Tokyo |
| 4 | African Explorers | Cape Town |
| 5 | Americas Discoveries | Miami |
Destinations
| id | destination_name |
| 1 | Europe |
| 2 | Asia |
| 3 | Africa |
| 4 | North America |
| 5 | South America |
| 6 | Australia |
Accommodations
| id | accommodation_type | capacity |
| 1 | Hotel | 300 |
| 2 | Resort | 600 |
| 3 | Hostel | 80 |
| 4 | Bed & Breakfast | 20 |
| 5 | Villa | 10 |
Tours
| id | tour_name | duration |
| 1 | City Tour | 1 |
| 2 | Beach Vacation | 7 |
| 3 | Mountain Trekking | 10 |
| 4 | Cultural Experience | 14 |
| 5 | Adventure Package | 12 |
Bookings
| id | travel_agency_id | destination_id | accommodation_id | tour_id | date | price |
| (→ Travel_Agencies.id) | (→ Destinations.id) | (→ Accommodations.id) | (→ Tours.id) | | |
| 1 | 1 | 1 | 1 | 1 | 2023-06-15 | 3000 |
| 2 | 1 | 2 | 2 | 2 | 2023-06-20 | 2500 |
| 3 | 2 | 1 | 3 | 3 | 2023-07-01 | 4000 |
| 4 | 2 | 2 | 4 | 4 | 2023-07-06 | 3500 |
| 5 | 3 | 1 | 5 | 5 | 2023-07-11 | 4500 |
Travel_Agencies_Destinations
| travel_agency_id | destination_id |
| (→ Travel_Agencies.id) | (→ Destinations.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 2 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |