Manufacturers

idnameaddress
1Company A123 Main St
2Company B456 Elm St
3Company C789 Oak St
4Company D001 Pine St
5Company E246 Maple Ave

Products

idproduct_name
1Widget
2Gadget
3Tool
4Accessory
5Component

Manufacturers_Products

manufacturer_idproduct_id
(→ Manufacturers.id)(→ Products.id)
11
21
31
41
51

JobPostings

job_titlecompany_namelocationrequired_skills
(→ Manufacturers.name)
Software EngineerCompany ANew YorkJava, Python, C++
Data AnalystCompany BLos AngelesSQL, R, Excel
Project ManagerCompany CChicagoPMP, Agile, Scrum
Graphic DesignerCompany DSan FranciscoAdobe Creative Suite, Sketch, Figma
QA TesterCompany EBostonJira, TestRail, Selenium