Consider the Following Elements Needed to Produce a Purchase Order

question 9

Essay

Consider the following elements needed to produce a purchase order (see figure below):
$\begin{array} { l l } \text { Purchase order number } & \text { Product number } \\\text { Purchase order date } & \text { Product description } \\\text { Vendor code } & \text { Quantity purchased } \\\text { Vendor name } & \text { Unit cost } \\\text { Vendor address } & \text { Total ordered } \\& \text { Total due }\end{array}$
PURCHASE ORDER
Purchase order number: P0156
Purchase order date:Oct 6, 2012
TO: ABC Corporation (C1704) 2500 Bay Area Blvd.
Houston, TX 77058
$\text { Thankyou 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 { F135 } & \text { Excel Book } & \$ 25.00 & 4 & \$ 100.00 \\\hline \text { G1456 } & \text { Using Access } & \$ 35.00 & 10 & \$ 350.00 \\\hline &\text { Visio for }\\\text { B3429 } & \text { Dummies } & \$ 45.00 & 5 & \$ 225.00 \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline \text { Total }&\quad\quad &\quad\quad & \quad\quad&\$675.00\\\hline\end{array}$ Using the SYSTEM OUTPUT approach, determine the tables needed and put them in third normal form. Be sure to identify primary, foreign, and/or composite (concatenated) keys as necessary. Primary keys and composite keys should be underlined, while foreign keys should be identified with an asterisk. LIST ALL TABLES FOR FIRST, SECOND and THIRD normal forms.

---

Definitions:

Frictionally Unemployed

Individuals temporarily out of work while transitioning between jobs, typically a healthy phenomenon in a dynamic economy.

Electrical Engineer

A professional who designs, develops, tests, and supervises the manufacturing of electrical equipment and systems.

Sectoral Shifts

Sectoral shifts refer to changes in the labor demand across various industries or sectors of the economy, often due to technological advances, consumer preferences, or other factors.

Frictional Unemployment

A form of temporary unemployment that occurs when workers are between jobs or are searching for new jobs that better match their skills.