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:

IMF

The International Monetary Fund, an organization aiming to promote global monetary cooperation, secure financial stability, facilitate international trade, promote high employment, and reduce poverty around the world.

Sustainable Economic Growth

Economic development that aims to meet the needs of the present without compromising the ability of future generations to meet their own needs, typically focusing on environmental, social, and economic balance.

Just War Theory

A theory for determining when a war can be considered legally and morally correct.

Competent Authority

The requirement that just war may be declared and run only by legitimately recognized nation-states.