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

question 27

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) }$

---

Definitions:

IUPAC Name

The systematic naming of chemical compounds based on the rules established by the International Union of Pure and Applied Chemistry.

Wood Alcohol

Another term for methanol, a simple alcohol that is used as a solvent, antifreeze, or fuel, and is dangerous to consume.

Methanol

A simple alcohol with the formula CH3OH, used as a solvent, antifreeze, fuel, and as a feedstock in chemical synthesis.

IUPAC Name

The systematic naming of chemical compounds according to the rules set by the International Union of Pure and Applied Chemistry.