Agency

idname
1Expedia
2Booking.com

Tour_Guide

idguideNameagencyId
(→ Agency.id)
1John Doe1
2Jane Smith2
3Michael Johnson1
4Emily Davis2
5David Brown1

Travel_Agent

idagentNameagencyId
(→ Agency.id)
1Alice Lee1
2Bob White2
3Carol Black1
4Daniel Green2
5Eva Blue1

Jobs

idtitledescription
1Software EngineerDeveloping web applications.
2Data AnalystAnalyzing customer behavior.
3Graphic DesignerCreating visuals for marketing materials.
4Marketing SpecialistPromoting products and services.
5HR ManagerManaging employees and recruitment.

Applications

tourGuideIdtravelAgentIdjobIdapplicationDate
(→ Tour_Guide.id)(→ Travel_Agent.id)(→ Jobs.id)
1312024-03-13 17:41:57
2422024-03-13 17:41:57
3132024-03-13 17:41:57
4242024-03-13 17:41:57
5152024-03-13 17:41:57

Skills

skillIdskillName
1Python Programming
2SQL Database Management
3JavaScript Development
4SEO Optimization
5Customer Relationship Management