Q$\mathrm{.}3(30\%)$ According to the database normalization guidelines, reform the following flat$-$structured transactional data into a relational table structure

Customer First Name Customer last Name Store

Member Date Time Item unit Quantity Unit price Product Origin

John Dean N $2023/10/118$:$30$ bread pkg $23\mathrm{.}99$ Canada

John Dean N $2023/10/118$:$30$ apple lb $5\mathrm{.}42\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ apple lb $12\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ bread pkg $32\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ pineapple piece $34\mathrm{.}99$ MexicoQ$\mathrm{.}3(30\%)$ According to the database normalization guidelines, reform the following flat$-$structured transactional data into a relational table structure

Customer First Name Customer last Name Store

Member Date Time Item unit Quantity Unit price Product Origin

John Dean N $2023/10/118$:$30$ bread pkg $23\mathrm{.}99$ Canada

John Dean N $2023/10/118$:$30$ apple lb $5\mathrm{.}42\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ apple lb $12\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ bread pkg $32\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ pineapple piece $34\mathrm{.}99$ MexicoQ$\mathrm{.}3(30\%)$ According to the database normalization guidelines, reform the following flat$-$structured transactional data into a relational table structure

Customer First Name Customer last Name Store

Member Date Time Item unit Quantity Unit price Product Origin

John Dean N $2023/10/118$:$30$ bread pkg $23\mathrm{.}99$ Canada

John Dean N $2023/10/118$:$30$ apple lb $5\mathrm{.}42\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ apple lb $12\mathrm{.}99$ Canada

Mary Brown Y $2023/10/211$:$10$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ bread pkg $32\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ milk bag $16\mathrm{.}99$ Canada

Tony White Y $2023/10/513$:$12$ pineapple piece $34\mathrm{.}99$ Mexico