Programming_Skills

idskill
1Python
2JavaScript
3C++

Software_Engineers

idnameemailhireDate
(→ Employees.id)
1John Doejohn.doe@example.com2021-06-01
2Jane Smithjane.smith@example.com2021-07-01
3Alice Johnsonalice.johnson@example.com2021-08-01

Data_Scientists

idnameemailhireDate
(→ Employees.id)
1Michael Brownmichael.brown@example.com2021-09-01
2Emily Davisemily.davis@example.com2021-10-01
3David Wilsondavid.wilson@example.com2021-11-01

Job_Postings

idtitledescriptionpostDaterequiredSkillId
(→ Programming_Skills.id)
1Frontend DeveloperDevelop and maintain web applications.2021-12-011
2Backend DeveloperDesign and implement server-side logic.2021-12-022
3Full Stack DeveloperBuild complete web applications.2021-12-033
4Machine Learning EngineerImplement machine learning algorithms.2021-12-044
5Data AnalystAnalyze data and provide insights.2021-12-055

Applies

idjobIdapplicantIdapplyDate
(→ Job_Postings.id)(→ Employees.id)
1112021-12-06
2222021-12-07
3332021-12-08
4442021-12-09
5552021-12-10

Employees

idnamepositiondepartment
1Bob LeeSoftware EngineerEngineering
2Carol WhiteData ScientistResearch
3Tom GreenManagerManagement
4Ann BlackHR SpecialistHuman Resources
5Chris RedFinance OfficerFinance