Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Start: flat orders sheet -- order_id, customer, email, product, qty, price, category -- 1NF: ensure atomic values, add PK -- 2NF: separate customers (email depends on customer not order) -- 3NF: separate products and categories (category depends on product) -- Result: orders, customers, products, categories, order_items tables
Result
Open