Companies

CompanyIDNameIndustry
1ABC CorporationTechnology
2XYZ IndustriesFinance

Locations

LocationIDCityStateCountry
1New YorkNYUSA
2Los AngelesCAUSA

TargetMarkets

MarketIDType
1B2B
2B2C

Skills

SkillIDDescription
1Proficient in CRM software
2Excellent communication skills

Jobs

JobIDTitleSalaryDatePostedSales_and_marketingCompanyIDLocationID
(→ Companies.CompanyID)(→ Locations.LocationID)
1Sales Associate60000.02024-03-13 13:38:07111
2Sales Associate60000.02024-03-13 13:38:07122
3Marketing Specialist70000.02024-03-13 13:38:07111
4Marketing Specialist70000.02024-03-13 13:38:07122

JobSkills

JobIDSkillID
(→ Jobs.JobID)(→ Skills.SkillID)
11
12
23
24
35
36
47
48

JobMarkets

JobIDMarketID
(→ Jobs.JobID)(→ TargetMarkets.MarketID)
11
22
31
42