Remove transitive dependency (3NF)
SQL
Easy
2 views
Problem Description
Employees(emp_id, emp_name, dept_id, dept_name). Show 3NF decomposition.
Output Format
DDL statement(s)
Sample Test Case
Input:
Employees contains dept_name
Constraints
dept_name depends on dept_id
Official Solution
CREATE TABLE Departments (dept_id INT PRIMARY KEY, dept_name VARCHAR(100)); CREATE TABLE Employees (emp_id INT PRIMARY KEY, emp_name VARCHAR(100), dept_id INT, FOREIGN KEY (dept_id) REFERENCES Departments(dept_id));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!