Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- 4NF violation: emp_skills and emp_languages in one table -- emp_id | skill | language (independent facts mixed) -- 4NF fix: two separate tables CREATE TABLE emp_skills (emp_id INT, skill VARCHAR(50), PRIMARY KEY(emp_id, skill)); CREATE TABLE emp_languages (emp_id INT, language VARCHAR(50), PRIMARY KEY(emp_id, language));
Result
Open