Companies
id | name | address |
1 | Company A | Address of Company A |
2 | Company B | Address of Company B |
3 | Company C | Address of Company C |
4 | Company D | Address of Company D |
5 | Company E | Address of Company E |
Employees
id | firstName | lastName | jobTitle | companyId |
| | | | (→ Companies.id) |
1 | John | Doe | Software Engineer | 1 |
2 | Jane | Smith | Data Analyst | 2 |
3 | Bob | Johnson | Project Manager | 3 |
4 | Alice | Williams | HR Specialist | 4 |
5 | Mike | Brown | Marketing Coordinator | 5 |
Skills
skillId | skillName |
1 | Proactivity |
2 | Teamwork |
3 | Communication |
4 | Leadership |
5 | Time Management |
EmployeeSkills
employeeId | skillId |
(→ Employees.id) | (→ Skills.skillId) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
Customer_Service_Reps
repId | employeeId |
| (→ Employees.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
Call_Center_Agents
agentId | employeeId |
| (→ Employees.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |