Problems/Normalization Practice#101MediumNormalization· 1NF/2NF/3NFNormalization PracticeGiven an unnormalized table: Orders(OrderID, CustomerName, CustomerPhone, ProductID, ProductName, Quantity, Price, OrderDate). Normalize step by step: (1) 1NF: atomic values, no repeating groups, (2) 2NF: remove partial dependencies, (3) 3NF: remove transitive dependencies. Show resulting tables with PKs and FKs. Explain each functional dependency you identify.#database#normalization#3nf
