Transform the Relation in Figure TB 5 $\text { Customers }$

Essay

Transform the relation in Figure TB 5.5 to third normal form (3NF). Label each new relation with a name that describes the attributes.
$\text { Customers }$
$\begin{array}{|r|l|l|l|l|l|l|}\hline \text { Number } & \begin{array}{c}\text { First } \\\text { Name }\end{array} & {\begin{array}{c}\text { Last } \\\text { Name }\end{array}} & {\text { Address }} & {\text { City }} & \text { State } & {\begin{array}{c}\text { Zip } \\\text { Code }\end{array}} \\\hline 104 & \text { Joln } & \text { Welch } & 123 \text { East St. } & \text { Ocoee } & \text { FL } & 32761 \\106 & \text { Mary } & \text { Best } & 745 \text { Webster Lare } & \text { Pensacola } & \text { FL } & 32809 \\106 & \text { Adam } & \text { Camp } & 4842 \text { Highand } & \text { Orange Lake } & \text { FL } & 32681 \\107 & \text { Patrick } & \text { Gaston } & 54 \text { Randh Road } & \text { Pensacola } & \text { FL } & 32809 \\100 & \text { Jaric } & \text { Lambert } & 27 \text { Rabin Hood } & \text { Orange Lake } & \text { FL } & 32681 \\\hline\end{array}$
$\text { Figure TB } 5.5 \text { Relation in Second Normal Form (2NF) }$