| id | name | location |
|---|---|---|
| 1 | Advertising Agency A | New York |
| 2 | Digital Media Company B | Los Angeles |
| 3 | PR Firm C | Chicago |
| 4 | Media Consultancy D | Boston |
| 5 | Branding Agency E | Dallas |
| id | position |
|---|---|
| 1 | Graphic Designer |
| 2 | Copywriter |
| 3 | Photographer |
| 4 | Web Developer |
| 5 | Content Creator |
| agency_id | position_id |
|---|---|
| (→ Marketing_Agency.id) | (→ Creative_Position.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |