## Company

id | name | address
--- | --- | ---
1 | Company A | 123 Main St
2 | Company B | 456 Oak St
3 | Company C | 789 Pine St
4 | Company D | 098 Maple St
5 | Company E | 567 Elm St

## Skills

id | skillName
--- | ---
1 | Photoshop
2 | Illustrator
3 | HTML
4 | CSS
5 | JavaScript

## Location

id | officeAddress
--- | ---
1 | 2/7 London Street
2 | 3/15 New York Ave
3 | 4/23 Los Angeles Blvd
4 | 5/4 Chicago Dr
5 | 6/41 Boston Rd

## JobPosting

id | jobTitle | companyID | skillsID | locationID
--- | --- | --- | --- | ---
|  | (→ Company.id) | (→ Skills.id) | (→ Location.id)
1 | Graphic Designer | 1 | 1 | 1
2 | Graphic Designer | 2 | 2 | 2
3 | Web Developer | 1 | 3 | 1
4 | Web Developer | 2 | 4 | 3
5 | Software Engineer | 3 | 5 | 4
6 | Data Analyst | 4 | 6 | 5
7 | Project Manager | 5 | 7 | 6

## Creative_Industry_Professions

id | profession | skillsID
--- | --- | ---
|  | (→ Skills.id)
1 | Graphic Designer | 1
2 | Graphic Designer | 2
3 | Web Developer | 3
4 | Web Developer | 4
5 | UX Designer | 5
6 | UI Designer | 6

## Office

id | officeAddress | locationID
--- | --- | ---
|  | (→ Location.id)
1 | 2/7 London Street | 1
2 | 3/15 New York Ave | 2
3 | 4/23 Los Angeles Blvd | 3
4 | 5/4 Chicago Dr | 4
5 | 6/41 Boston Rd | 5