## 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