## Office

id | address
--- | ---
1 | 2/7 London Street
2 | 3/10 New York Avenue

## Graphic_Designers

id | officeId | name | skills
--- | --- | --- | ---
| (→ Office.id) |  |
1 | 1 | Alice Smith | Photoshop, Illustrator, InDesign
2 | 2 | Bob Johnson | Photoshop, Illustrator, InDesign

## Web_Developers

id | officeId | name | languages
--- | --- | --- | ---
| (→ Office.id) |  |
1 | 1 | Carol Williams | JavaScript, HTML, CSS
2 | 2 | David Brown | Python, Java, C++

## Employees

id | fullName | email | phoneNumber | hireDate
--- | --- | --- | --- | ---
1 | Eve White | eve@example.com | +1234567890 | 2021-01-01
2 | Frank Black | frank@example.com | +0987654321 | 2021-02-01

## Skills

skillId | description
--- | ---
1 | Proficient in Adobe Creative Suite
2 | Experienced in frontend and backend development

## EmployeeSkillMapping

employeeId | skillId | level
--- | --- | ---
(→ Employees.id) | (→ Skills.skillId) |
1 | 1 | 5
1 | 2 | 7
2 | 1 | 8
2 | 2 | 6