Main Normalization Problem in an Orders Table With Customer Details

Question 1

Assume a developer designs the following table for an e-commerce system: ```sql CREATE TABLE Orders ( OrderID INT PRIMARY KEY, CustomerName VARCHAR(100), CustomerEmail VARCHAR(100), ProductName VARCHAR(100), ProductPrice DECIMAL(10, 2) ); ``` After some time, the DBA reports issues where the same customer's email appears with different products, and if the email changes, multiple rows are updated.