AgencyID | Name |
---|---|
1 | Expedia |
2 | ABC Travel |
GuideID | Name | Age | Experience | AgencyID |
---|---|---|---|---|
(→ Agencies.AgencyID) | ||||
1 | John Doe | 30 | 8 | 1 |
2 | Jane Smith | 29 | 7 | 2 |
AgentID | Name | Salary | CommissionRate | AgencyID |
---|---|---|---|---|
(→ Agencies.AgencyID) | ||||
1 | Mike Johnson | 60000.0 | 0.1 | 1 |
2 | Emily Brown | 55000.0 | 0.12 | 2 |
CustomerID | FirstName | LastName | PhoneNumber | TourGUIDEID | |
---|---|---|---|---|---|
(→ TourGuides.GuideID) | |||||
1 | Alice | Smith | alice@example.com | 1234567890 | 1 |
2 | Bob | Johnson | bob@example.com | 0987654321 | 2 |
TripID | StartDate | EndDate | NumOfPeople | TotalCost | AgentID | GuideID |
---|---|---|---|---|---|---|
(→ TravelAgents.AgentID) | (→ TourGuides.GuideID) | |||||
1 | 2021-07-01 | 2021-07-10 | 4 | 4000.0 | 1 | 1 |
2 | 2021-08-01 | 2021-08-10 | 6 | 6000.0 | 2 | 2 |