## Programming_Skills

id | skill
--- | ---
1 | Python
2 | JavaScript
3 | C++

## Software_Engineers

id | name | email | hireDate
--- | --- | --- | ---
(→ Employees.id) |  |  |
1 | John Doe | john.doe@example.com | 2021-06-01
2 | Jane Smith | jane.smith@example.com | 2021-07-01
3 | Alice Johnson | alice.johnson@example.com | 2021-08-01

## Data_Scientists

id | name | email | hireDate
--- | --- | --- | ---
(→ Employees.id) |  |  |
1 | Michael Brown | michael.brown@example.com | 2021-09-01
2 | Emily Davis | emily.davis@example.com | 2021-10-01
3 | David Wilson | david.wilson@example.com | 2021-11-01

## Job_Postings

id | title | description | postDate | requiredSkillId
--- | --- | --- | --- | ---
|  |  |  | (→ Programming_Skills.id)
1 | Frontend Developer | Develop and maintain web applications. | 2021-12-01 | 1
2 | Backend Developer | Design and implement server-side logic. | 2021-12-02 | 2
3 | Full Stack Developer | Build complete web applications. | 2021-12-03 | 3
4 | Machine Learning Engineer | Implement machine learning algorithms. | 2021-12-04 | 4
5 | Data Analyst | Analyze data and provide insights. | 2021-12-05 | 5

## Applies

id | jobId | applicantId | applyDate
--- | --- | --- | ---
| (→ Job_Postings.id) | (→ Employees.id) |
1 | 1 | 1 | 2021-12-06
2 | 2 | 2 | 2021-12-07
3 | 3 | 3 | 2021-12-08
4 | 4 | 4 | 2021-12-09
5 | 5 | 5 | 2021-12-10

## Employees

id | name | position | department
--- | --- | --- | ---
1 | Bob Lee | Software Engineer | Engineering
2 | Carol White | Data Scientist | Research
3 | Tom Green | Manager | Management
4 | Ann Black | HR Specialist | Human Resources
5 | Chris Red | Finance Officer | Finance