The following table contains information about customers and their orders. Customers can have only one account $($so CustomerIDs are unique$)$ and can only have one email address associated with their account. They can make multiple orders with as many items as they like, but there can be only one shipping speed $(1-$day, ground, etc.$)$ per order, though. Customers can order items on any date, so multiple customers may have the same OrderDate. Additionally, assume that customer names are unique.

CustomerID Name Email OrderNum OrderDate ShippingCode ShippingSpeed ItemID Description

$453$ Esra Croft ecroft$0$@t$-$online.de $3561/2/20220021-$Day $434$ zip ties

$453$ Esra Croft ecroft$0$@t$-$online.de $3561/2/20220021-$Day $897$ duct tape

$453$ Esra Croft ecroft$0$@t$-$online.de $3561/2/20220021-$Day $591$ trash bags

$528$ Lolita Reiach lreiach$2$@unc.edu $2513/17/2021001$ Ground $591$ trash bags

$528$ Lolita Reiach lreiach$2$@unc.edu $2513/17/2021001$ Ground $327$ dish soap

$453$ Esra Croft ecroft$0$@t$-$online.de $2202/11/2021001$ Ground $586$ chainsaw

$393$ Mandie Grob mgrob$3$@miitbeian.gov.cn $2723/17/20210032-$Day $722$ laptop

Identify the functional dependencies in the table above.

Using the functional dependencies identified in #$1,$ use the attribute closure method to identify the candidate keys of the table above.

From the candidate keys identified in #$2,$ what is the primary key of the table?

Show the following normal forms for the table above:

First Normal Form. Show all data.

Second Normal Form. Just the names of the columns for each reorganized table, with the primary key underlined is sufficient.

Third Normal Form. Just the names of the columns for each reorganized table, with the primary key underlined is sufficient.