| id | name | location | experience | programming_skills |
|---|---|---|---|---|
| 1 | John Doe | New York | 2 years | Python |
| 2 | Jane Smith | San Francisco | 3 years | JavaScript |
| 3 | Michael Johnson | Los Angeles | 5 years | C++ |
| 4 | Emily Brown | Chicago | 7 years | Ruby |
| 5 | David Wilson | Dallas | 8 years | Swift |
| id | name | location | experience | programming_skills |
|---|---|---|---|---|
| 6 | William Thompson | Boston | 4 years | Python |
| 7 | Linda Martinez | Washington | 6 years | R |
| 8 | Thomas Harris | Philadelphia | 9 years | Matlab |
| 9 | Elizabeth Clark | Atlanta | 10 years | Octave |
| 10 | Charles Young | Miami | 12 years | Scala |
| id | company_name | industry |
|---|---|---|
| 1 | Technology | |
| 2 | Amazon | E-commerce |
| 3 | Microsoft | Technology |
| 4 | Social Media | |
| 5 | Apple | Consumer Electronics |
| job_id | title | description | salary | posted_date |
|---|---|---|---|---|
| 1 | Software Engineer | Design and develop software applications. | 90000.0 | 2022-01-01 |
| 2 | Data Scientist | Analyze complex datasets and provide insights. | 100000.0 | 2022-01-02 |
| 3 | Mobile Developer | Create mobile apps using Swift. | 80000.0 | 2022-01-03 |
| 4 | Machine Learning Engineer | Build machine learning models. | 120000.0 | 2022-01-04 |
| 5 | Web Developer | Develop and maintain websites. | 70000.0 | 2022-01-05 |
| company_id | job_id |
|---|---|
| (→ Companies.id) | (→ Jobs.job_id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| engineer_id | job_id |
|---|---|
| (→ Software_Engineers.id) | (→ Jobs.job_id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| scientist_id | job_id |
|---|---|
| (→ Data_Scientists.id) | (→ Jobs.job_id) |
| 6 | 2 |
| 7 | 2 |
| 8 | 4 |
| 9 | 5 |
| 10 | 5 |