Consider the Following Elements Needed to Produce a Sales Order

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