| CompanyID | Name | Industry |
|---|---|---|
| 1 | ABC Corporation | Technology |
| 2 | XYZ Industries | Finance |
| LocationID | City | State | Country |
|---|---|---|---|
| 1 | New York | NY | USA |
| 2 | Los Angeles | CA | USA |
| MarketID | Type |
|---|---|
| 1 | B2B |
| 2 | B2C |
| SkillID | Description |
|---|---|
| 1 | Proficient in CRM software |
| 2 | Excellent communication skills |
| JobID | Title | Salary | DatePosted | Sales_and_marketing | CompanyID | LocationID |
|---|---|---|---|---|---|---|
| (→ Companies.CompanyID) | (→ Locations.LocationID) | |||||
| 1 | Sales Associate | 60000.0 | 2024-03-13 13:38:07 | 1 | 1 | 1 |
| 2 | Sales Associate | 60000.0 | 2024-03-13 13:38:07 | 1 | 2 | 2 |
| 3 | Marketing Specialist | 70000.0 | 2024-03-13 13:38:07 | 1 | 1 | 1 |
| 4 | Marketing Specialist | 70000.0 | 2024-03-13 13:38:07 | 1 | 2 | 2 |
| JobID | SkillID |
|---|---|
| (→ Jobs.JobID) | (→ Skills.SkillID) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 3 | 5 |
| 3 | 6 |
| 4 | 7 |
| 4 | 8 |
| JobID | MarketID |
|---|---|
| (→ Jobs.JobID) | (→ TargetMarkets.MarketID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |
| 4 | 2 |