Unnormalized Dataset $($Violates $1$NF$,2$NF$,$ and $3$NF$)$:

This dataset stores customer and order information, where

customers can place multiple orders, and each order can

include multiple products. Additionally, the customer's

address is repeated, and product information is embedded

within the order details.

Im having trouble with this I posted a screenshot of the table, If you can post your answers today that would be the biggest help thank you!

Instructions:

$1)$Identify repeating groups and multivalued attributes

$($such as multiple products in a single field$).$

$2)$Break down the unnormalized table into $1$NF by ensuring

atomicity $($each cell contains only one value$).$

$3)$Normalize further into $2$NF by removing partial

dependencies $($separate customer data from orders$).$

$4)$Normalize into $3$NF by removing transitive dependencies

$($separate product information from the order details$).$

$5)$Create the necessary new tables to ensure data is fully

normalized and avoid redundancy.