Company

idnameaddress
1Company A123 Main St
2Company B456 Oak St
3Company C789 Pine St
4Company D098 Maple St
5Company E567 Elm St

Skills

idskillName
1Photoshop
2Illustrator
3HTML
4CSS
5JavaScript

Location

idofficeAddress
12/7 London Street
23/15 New York Ave
34/23 Los Angeles Blvd
45/4 Chicago Dr
56/41 Boston Rd

JobPosting

idjobTitlecompanyIDskillsIDlocationID
(→ Company.id)(→ Skills.id)(→ Location.id)
1Graphic Designer111
2Graphic Designer222
3Web Developer131
4Web Developer243
5Software Engineer354
6Data Analyst465
7Project Manager576

Creative_Industry_Professions

idprofessionskillsID
(→ Skills.id)
1Graphic Designer1
2Graphic Designer2
3Web Developer3
4Web Developer4
5UX Designer5
6UI Designer6

Office

idofficeAddresslocationID
(→ Location.id)
12/7 London Street1
23/15 New York Ave2
34/23 Los Angeles Blvd3
45/4 Chicago Dr4
56/41 Boston Rd5