Software_Engineers

idnamelocationexperienceprogramming_skills
1John DoeNew York2 yearsPython
2Jane SmithSan Francisco3 yearsJavaScript
3Michael JohnsonLos Angeles5 yearsC++
4Emily BrownChicago7 yearsRuby
5David WilsonDallas8 yearsSwift

Data_Scientists

idnamelocationexperienceprogramming_skills
6William ThompsonBoston4 yearsPython
7Linda MartinezWashington6 yearsR
8Thomas HarrisPhiladelphia9 yearsMatlab
9Elizabeth ClarkAtlanta10 yearsOctave
10Charles YoungMiami12 yearsScala

Companies

idcompany_nameindustry
1GoogleTechnology
2AmazonE-commerce
3MicrosoftTechnology
4FacebookSocial Media
5AppleConsumer Electronics

Jobs

job_idtitledescriptionsalaryposted_date
1Software EngineerDesign and develop software applications.90000.02022-01-01
2Data ScientistAnalyze complex datasets and provide insights.100000.02022-01-02
3Mobile DeveloperCreate mobile apps using Swift.80000.02022-01-03
4Machine Learning EngineerBuild machine learning models.120000.02022-01-04
5Web DeveloperDevelop and maintain websites.70000.02022-01-05

CompanyJobs

company_idjob_id
(→ Companies.id)(→ Jobs.job_id)
11
22
33
44
55

EngineerJobs

engineer_idjob_id
(→ Software_Engineers.id)(→ Jobs.job_id)
11
21
33
44
55

ScientistJobs

scientist_idjob_id
(→ Data_Scientists.id)(→ Jobs.job_id)
62
72
84
95
105