Office

idaddress
12/7 London Street
23/10 New York Avenue

Graphic_Designers

idofficeIdnameskills
(→ Office.id)
11Alice SmithPhotoshop, Illustrator, InDesign
22Bob JohnsonPhotoshop, Illustrator, InDesign

Web_Developers

idofficeIdnamelanguages
(→ Office.id)
11Carol WilliamsJavaScript, HTML, CSS
22David BrownPython, Java, C++

Employees

idfullNameemailphoneNumberhireDate
1Eve Whiteeve@example.com+12345678902021-01-01
2Frank Blackfrank@example.com+09876543212021-02-01

Skills

skillIddescription
1Proficient in Adobe Creative Suite
2Experienced in frontend and backend development

EmployeeSkillMapping

employeeIdskillIdlevel
(→ Employees.id)(→ Skills.skillId)
115
127
218
226