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

Differentiate between major psychological theories and schools of thought.

Identify various types of psychologists and their areas of interest.

Comprehend the factors influencing the development and treatment of depression.

Recognize the role of genetics and environmental factors in the development of psychological disorders.

---

Definitions:

Clayton Act

A U.S. antitrust law enacted in 1914, aimed at promoting fair competition and preventing monopolies by prohibiting certain types of anti-competitive practices.

Sherman Act

A landmark federal statute in the field of United States antitrust law aimed at preserving competitive markets by prohibiting monopolies and other business practices that hinder competition.

Standard Oil Trust

A historically significant corporation that monopolized the oil industry in the United States through the aggressive consolidation of competing enterprises.

ALCOA Case

A landmark legal case involving the Aluminum Company of America, which led to significant developments in antitrust law regarding monopolies.