Agencies

AgencyIDName
1Expedia
2ABC Travel

TourGuides

GuideIDNameAgeExperienceAgencyID
(→ Agencies.AgencyID)
1John Doe3081
2Jane Smith2972

TravelAgents

AgentIDNameSalaryCommissionRateAgencyID
(→ Agencies.AgencyID)
1Mike Johnson60000.00.11
2Emily Brown55000.00.122

Customers

CustomerIDFirstNameLastNameEmailPhoneNumberTourGUIDEID
(→ TourGuides.GuideID)
1AliceSmithalice@example.com12345678901
2BobJohnsonbob@example.com09876543212

BookedTrips

TripIDStartDateEndDateNumOfPeopleTotalCostAgentIDGuideID
(→ TravelAgents.AgentID)(→ TourGuides.GuideID)
12021-07-012021-07-1044000.011
22021-08-012021-08-1066000.022