| id | skill |
|---|---|
| 1 | Python |
| 2 | JavaScript |
| 3 | C++ |
| id | name | 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 |
| id | name | 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 |
| 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 |
| 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 |
| 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 |