Find repeating groups (concept)

Find repeating groups (concept)

Easy SQL Normalization 19 views
Explanation Complexity

Problem Statement

Given a table OrdersRaw(order_id, items, quantities) where items are stored like '10|12|14' and quantities '1|2|1', explain why it breaks 1NF in description and give normalized tables in SQL.

Input Format

SQL DDL

Output Format

DDL statement(s)

Example

OrdersRaw
Normalized design

Constraints

Split multivalued fields

Input / Output Format

Input Format
SQL DDL
Output Format
DDL statement(s)
Constraints
Split multivalued fields

Examples

Input:
OrdersRaw
Output:
Normalized design

Example Solution (Public)

SQL 
CREATE TABLE Orders (order_id INT PRIMARY KEY); CREATE TABLE OrderItems (order_id INT NOT NULL, product_id INT NOT NULL, qty INT NOT NULL, PRIMARY KEY(order_id, product_id));

Official Solution Code

CREATE TABLE Orders (order_id INT PRIMARY KEY); CREATE TABLE OrderItems (order_id INT NOT NULL, product_id INT NOT NULL, qty INT NOT NULL, PRIMARY KEY(order_id, product_id));
Please login to submit solutions.
Editor
Output

                                        

                                    

                                    

                                        

                                                                                    
Please login to submit solutions.