$$ UNF $($Unnormalized Form$)$:

o Customer Table:

$$ CustomerID $($Primary Key$)$

$$ CustomerName

$$ CustomerAddress

$$ CustomerCategory

$$ DiscountRate

$$ Product Table:

$$ ProductID $($Primary Key$)$

$$ ProductName

$$ Description

$$ Category

$$ Price

$$ StockLevel

$$ VendorID $($Foreign Key$)$

$$ Order Table:

$$ OrderID $($Primary Key$)$

$$ CustomerID $($Foreign Key$)$

$$ OrderDate

$$ PaymentOption

$$ OrderDetails Table:

$$ OrderID $($Primary key $,$ Foreign Key$)$

$$ ProductID $($Primary key, Foreign Key$)$

$$ Quantity

$$ UnitPrice

$1$NF $($First Normal Form$)$:

$$ Customer Table:

$$ CustomerID $($PK$)$

$$ CustomerName

$$ CustomerAddress

$$ CustomerCategory

$$ DiscountRate

$$ Product Table:

$$ ProductID $($PK$)$

$$ ProductName

$$ Description

$$ Category

$$ Price

$$ StockLevel

$$ Order Table:

$$ OrderID $($PK$)$

$$ CustomerID $($FK$)$

$$ OrderDate

$$ PaymentOption

$$ OrderDetails Table:

$$ OrderID $($PK$,$ FK$)$

$$ ProductID $($PK$,$ FK$)$

$$ Quantity

$$ UnitPrice

$2$NF $($Second Normal Form$)$:

$$ Customer Table:

$$ CustomerID $($PK$)$

$$ CustomerName

$$ CustomerAddress

$$ CustomerCategory

$$ DiscountRate

$$ Product Table:

$$ ProductID $($PK$)$

$$ ProductName

$$ Description

$$ Category

$$ Price

$$ StockLevel

$$ VendorID $($FK$)$

$$ Order Table:

$$ OrderID $($PK$)$

$$ CustomerID $($FK$)$

$$ OrderDate

$$ PaymentOption

$$ OrderDetails Table:

$$ OrderID $($PK$,$ FK$)$

$$ ProductID $($PK$,$ FK$)$

$$ Quantity

$$ UnitPrice

o $3$NF $($Third Normal Form$)$:

o Customer Table:

$$ CustomerID $($PK$)$

$$ CustomerName

$$ CustomerAddress

$$ CustomerCategory

$$ DiscountRate

$$ Product Table:

$$ ProductID $($PK$)$

$$ ProductName

$$ Description

$$ Category

$$ Price

$$ StockLevel

$$ VendorID $($FK$)$

$$ Order Table:

$$ OrderID $($PK$)$

$$ CustomerID $($FK$)$

$$ OrderDate

$$ PaymentOption

$$ OrderDetails Table:

$$ OrderID $($PK$,$ FK$)$

$$ ProductID $($PK$,$ FK$)$

$$ Quantity

$$ UnitPrice

$$ Vendor Table:

$$ VendorID $($PK$)$

$$ VendorName

Draw $2$ ER Diagram, for initial $($before normalization$)$ and final $($after normalization$)$ with entities and relationships according to the above normalization