Marketing_Agency

idnamelocation
1Advertising Agency ANew York
2Digital Media Company BLos Angeles
3PR Firm CChicago
4Media Consultancy DBoston
5Branding Agency EDallas

Creative_Position

idposition
1Graphic Designer
2Copywriter
3Photographer
4Web Developer
5Content Creator

Marketing_Agency_Creative_Positions

agency_idposition_id
(→ Marketing_Agency.id)(→ Creative_Position.id)
11
21
31
41
51
54