| id | name | address |
|---|---|---|
| 1 | Company A | 123 Main St |
| 2 | Company B | 456 Elm St |
| 3 | Company C | 789 Oak St |
| 4 | Company D | 001 Pine St |
| 5 | Company E | 246 Maple Ave |
| id | product_name |
|---|---|
| 1 | Widget |
| 2 | Gadget |
| 3 | Tool |
| 4 | Accessory |
| 5 | Component |
| manufacturer_id | product_id |
|---|---|
| (→ Manufacturers.id) | (→ Products.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| job_title | company_name | location | required_skills |
|---|---|---|---|
| (→ Manufacturers.name) | |||
| Software Engineer | Company A | New York | Java, Python, C++ |
| Data Analyst | Company B | Los Angeles | SQL, R, Excel |
| Project Manager | Company C | Chicago | PMP, Agile, Scrum |
| Graphic Designer | Company D | San Francisco | Adobe Creative Suite, Sketch, Figma |
| QA Tester | Company E | Boston | Jira, TestRail, Selenium |