Consider the Following Elements Needed to Produce a Sales Order

question 32

Essay

Consider the following elements needed to produce a sales order (see figure below):
$\begin{array}{lll}\text { Date } &\text { Customer zip code } &\text {Cost per unit }\\\text { Sales order number } & \text {Employee name } & \text {Quantity ordered }\\\text { Customer name } & \text { Employee region } & \text { Total price } \\\text { Customer address } & \text { Product number } & \text { Total sales order } \\\text { Customer city } & \text { Product description } &\end{array}$
Determine the tables necessary to put this information in third normal form. SHOW ALL RESULTING TABLES FROM FIRST, SECOND, and THIRD normal forms. Be sure to identify primary keys, concatenated keys and foreign keys. Primary keys and concatenated keys should be underlined, and foreign keys should be indicated with an asterisk (*).
SALES ORDER
Sales order number: S10-
99876
Sales order date: October 30 ,
20XX
TO: ABC Corporation
2987 Bay Oaks Dr.
Clear Lake City, TX 77057
John Smith, Houston region
Thank you for your order!

$\begin{array}{|l|l|l|l|l|}\hline &&\text { Unit }\\\text { Product No}&\text { Description }&\text {Price }&\text {Quantity }&\text {Total }\\\hline &\text { Card-playing }\\\text { P198765 } & \text { dogs } & \$ 15.00 & 25 & \$ 375.00 \\\hline \text { P349842 } & \text { Velvet Elvis } & \$ 14.00 & 20 & \$ 280.00 \\\hline \text { P368742 } & \text { Looney Tunes } & \$ 20.00 & 45 & \$ 900.00 \\\hline \text { P498111 } & \text { Celine Dion } & \$ 16.00 & 10 & \$ 160.00 \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline \text { Total sales order}&&&&\$1,715.00\\\hline\end{array}$

---

Definitions:

Lonely People

Individuals who experience a significant lack of social connections or a deep sense of isolation from others.

Interpersonal Relationships

Emotional, social connections or bonds between two or more individuals, varying in degree from intimate to acquaintance.

Psychological Problems

These refer to mental health issues that affect mood, thinking, and behavior, potentially causing distress or impairment in daily functioning.

Interpersonal Relationships

Connections or associations between two or more people, which may vary in duration and significance.