Question Three

$1$

$2$ Marks

You are given a table with unnormalized design. You are required to transform the provided table into First Normal Form $(1$NF$),$ and Second Normal Form $(2$NF$).$ For each step, provide the new table$($s$)$ and explain the changes made.

$\backslash$table$[[(),$Supplier$\_$Name,Products$\_$Info,Order$\_$Date$],[{001}_{?},$Amazon,$\backslash$table$[[$P$1,$ product$101,],[$product$102]],01-11-2024$