Avoid update anomaly
SQL
Medium
2 views
Problem Description
Table ProductSupply(product_id, supplier_name, supplier_phone, supply_price). Decompose to reduce update anomaly.
Output Format
DDL statement(s)
Constraints
Separate supplier data
Official Solution
CREATE TABLE Suppliers (supplier_id INT PRIMARY KEY, supplier_name VARCHAR(200), supplier_phone VARCHAR(30)); CREATE TABLE Supplies (product_id INT, supplier_id INT, supply_price DECIMAL(10,2), PRIMARY KEY(product_id, supplier_id));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!