Travel_Agencies
AgencyID | Name | Address | ContactNumber |
1 | Explorer Tours | 123 Exploration St. | +1 9876543210 |
2 | World Wanderers | 456 Adventure Blvd. | +1 9876543211 |
Online_Booking_Platforms
PlatformID | Name | Website |
1 | GoTrip | www.gotrip.com |
2 | VacayFinder | www.vacayfinder.com |
Tours
TourID | DestinationName | Duration |
1 | Machu Picchu | 5 |
2 | Eiffel Tower | 3 |
Bookings
BookingID | CustomerID | TourID | TravelAgencyID | OnlinePlatformID | StartDate | EndDate |
| (→ Customers.CustomerID) | (→ Tours.TourID) | (→ Travel_Agencies.AgencyID) | (→ Online_Booking_Platforms.PlatformID) | | |
1 | 1 | 1 | 1 | 1 | 2022-06-15 | 2022-06-20 |
2 | 2 | 2 | 2 | 2 | 2022-07-15 | 2022-07-20 |
Customers
CustomerID | FirstName | LastName | Email | PhoneNumber |
1 | John | Doe | john.doe@example.com | +1 9876543212 |
2 | Jane | Smith | jane.smith@example.com | +1 9876543213 |