An employee can have multiple skills and speak multiple languages, independently
A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.
- Domain
- Data Modeling
- Difficulty
- medium
Problem
An employee can have multiple skills and speak multiple languages, independently. Storing (employee, skill, language) creates false combinations. Decompose into two separate multi-valued fact tables to achieve 4NF.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.