| id | name | 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 |
| id | departmentName | managerId |
|---|---|---|
| (→ Employees.id) | ||
| 1 | Sales | 1 |
| 2 | Marketing | 2 |
| 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 |
| skillName | requiredForJobId |
|---|---|
| (→ Jobs.id) | |
| Customer Service | 1 |
| Digital Marketing | 2 |
| 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 |
| 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 |