DBMSMediumNormalization
Normalize a Given Table to 3NF
đ Problem
You're given a single table: Orders(OrderID, CustomerName, CustomerCity, ProductName, ProductPrice, Quantity). Normalize it to 3NF.
đ§ Approach
First spot the repeating/dependent groups: CustomerCity depends only on CustomerName (not the whole key), and ProductPrice depends only on ProductName â these are transitive dependencies, which violate 3NF. Split into 3 tables: Customers(CustomerName, CustomerCity), Products(ProductName, ProductPrice), and Orders(OrderID, CustomerName, ProductName, Quantity) referencing the other two via foreign keys.