## Employees

id | name | email | phoneNumber | address
--- | --- | --- | --- | ---
1 | John Doe | johndoe@example.com | 123-456-7890 | 123 Main St
2 | Jane Smith | janesmith@example.com | 987-654-3210 | 456 Elm St

## Departments

id | departmentName | managerId
--- | --- | ---
|  | (→ Employees.id)
1 | Sales | 1
2 | Marketing | 2

## Sales_and_marketing_jobs

jobTitle | targetMarket | salary | departmentId
--- | --- | --- | ---
(→ Jobs.title) |  |  | (→ Departments.id)
Sales Associate | B2B | 50000 | 1
Sales Associate | Retail | 40000 | 1
Marketing Specialist | B2B | 60000 | 2
Marketing Specialist | Consumer Goods | 55000 | 2

## Skills

skillName | requiredForJobId
--- | ---
| (→ Jobs.id)
Customer Service | 1
Digital Marketing | 2

## Experience

employeeId | yearsOfExperience | jobTitle | companyName | startDate | endDate
--- | --- | --- | --- | --- | ---
(→ Employees.id) |  |  |  |  |
1 | 5 | Account Manager | ABC Corporation | 2015-01-01 | 2020-01-01
2 | 3 | Graphic Designer | XYZ Company | 2017-01-01 | 2020-01-01

## Jobs

id | title | description | location | postedOn | closingDate | minimumYearsOfExperience | skillsRequiredId
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Skills.skillName)
1 | Sales Associate | Responsible for selling products to B2B clients. | New York | 2021-01-01 | 2021-02-01 | 1 | 1
2 | Sales Associate | Assisting customers at a retail store. | Los Angeles | 2021-01-01 | 2021-02-01 | 0 | 2
3 | Marketing Specialist | Developing digital marketing campaigns. | San Francisco | 2021-01-01 | 2021-02-01 | 2 | 3
4 | Marketing Specialist | Creating traditional advertising materials. | Chicago | 2021-01-01 | 2021-02-01 | 1 | 4