Normalization with composite attribute
SQL
Medium
3 views
Problem Description
Table Employees(emp_id, name, address) where address stores 'house,street,city'. Normalize it into separate columns and keep it 1NF.
Output Format
DDL statement(s)
Constraints
Atomic values
Official Solution
CREATE TABLE Employees (emp_id INT PRIMARY KEY, name VARCHAR(100), house VARCHAR(50), street VARCHAR(100), city VARCHAR(100));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!