Companies
id | name |
1 | TechCorp |
2 | Software Inc. |
3 | Data Solutions Ltd. |
4 | AI Developers |
5 | Network Services Co. |
Customer_Facing_Roles
id | role |
1 | Customer Service Advisor |
2 | IT Support Technician |
Language_Proficiencies
id | language |
1 | Bilingual |
2 | Multilingual |
Employees
id | first_name | last_name | email | phone | customer_role_id | language_proficiency_id |
| | | | | (→ Customer_Facing_Roles.id) | (→ Language_Proficiencies.id) |
1 | Mike | Adams | mikeadams@email.com | +1112223333 | 1 | 1 |
2 | Nancy | Walker | nancywalker@email.com | +2223334444 | 1 | 2 |
3 | Tom | Hanks | thanks@email.com | +3344556677 | 2 | 1 |
4 | Laura | Williams | laurawilliams@email.com | +4455667788 | 2 | 2 |
5 | Steve | Martin | stevemartin@email.com | +5566778899 | 1 | 1 |