Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Violates 3NF: employees table -- emp_id | name | dept_id | dept_name -- dept_name depends on dept_id (a non-key column) -- Fix: separate departments table CREATE TABLE departments ( id INT PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(100), dept_id INT REFERENCES departments(id) );
Result
Open