| id | name |
|---|---|
| 1 | Expedia |
| 2 | Booking.com |
| id | guideName | agencyId |
|---|---|---|
| (→ Agency.id) | ||
| 1 | John Doe | 1 |
| 2 | Jane Smith | 2 |
| 3 | Michael Johnson | 1 |
| 4 | Emily Davis | 2 |
| 5 | David Brown | 1 |
| id | agentName | agencyId |
|---|---|---|
| (→ Agency.id) | ||
| 1 | Alice Lee | 1 |
| 2 | Bob White | 2 |
| 3 | Carol Black | 1 |
| 4 | Daniel Green | 2 |
| 5 | Eva Blue | 1 |
| id | title | description |
|---|---|---|
| 1 | Software Engineer | Developing web applications. |
| 2 | Data Analyst | Analyzing customer behavior. |
| 3 | Graphic Designer | Creating visuals for marketing materials. |
| 4 | Marketing Specialist | Promoting products and services. |
| 5 | HR Manager | Managing employees and recruitment. |
| tourGuideId | travelAgentId | jobId | applicationDate |
|---|---|---|---|
| (→ Tour_Guide.id) | (→ Travel_Agent.id) | (→ Jobs.id) | |
| 1 | 3 | 1 | 2024-03-13 17:41:57 |
| 2 | 4 | 2 | 2024-03-13 17:41:57 |
| 3 | 1 | 3 | 2024-03-13 17:41:57 |
| 4 | 2 | 4 | 2024-03-13 17:41:57 |
| 5 | 1 | 5 | 2024-03-13 17:41:57 |
| skillId | skillName |
|---|---|
| 1 | Python Programming |
| 2 | SQL Database Management |
| 3 | JavaScript Development |
| 4 | SEO Optimization |
| 5 | Customer Relationship Management |