Languages

idname
1English
2Spanish
3French
4German
5Chinese

Customer_Service_Advisors

idadvisor_namelanguage_id
(→ Languages.id)
1Alice1
2Bob3
3CarolNone
4Dave5
5Eve2

IT_Support_Technicians

idtechnician_namelanguage_id
(→ Languages.id)
1Frank1
2Grace3
3HannahNone
4Isaac5
5Jackie2

Job_Postings

idtitledescriptionlocationsalaryposted_date
1CS AdvisorAssist customers via phone and email.New York600002024-03-13 20:10:28
2IT Support TechTroubleshoot hardware and software issues.San Francisco700002024-03-13 20:10:28
3ManagerOversee operations of a department.Los Angeles900002024-03-13 20:10:28
4EngineerDesign and develop new products.Chicago800002024-03-13 20:10:28
5AnalystAnalyze data and provide insights.Miami750002024-03-13 20:10:28

CS_Jobs

job_posting_idcustomer_service_advisor_id
(→ Job_Postings.id)(→ Customer_Service_Advisors.id)
11
13

IT_Jobs

job_posting_idit_support_technician_id
(→ Job_Postings.id)(→ IT_Support_Technicians.id)
24
25
32