Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Violates 1NF: multiple values in one column -- id | name | phones -- 1 | Alice | 555-1111, 555-2222 -- 1NF compliant: one value per cell CREATE TABLE user_phones ( user_id INT, phone VARCHAR(20), PRIMARY KEY (user_id, phone) );
Result
Open