Consider the Following Elements Needed to Produce a Purchase Order

question 44

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 { Purchase Agent Name } & \text { Total ordered } \\& \text { Total due }\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.
PURCHASE ORDER
Purchase order number:
Purchase order date:
TO: Vendar Cade
Name
Address
Purchase Agent Name
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 & & & & \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline & & & & \\\hline \text { Total }&\quad\quad &\quad\quad & \quad\quad&\quad\quad \\\hline\end{array}$

---

Definitions:

Treasury Bill Rates

The interest rates associated with short-term government securities issued by the Treasury of a country, considered low-risk investments.

Risk-Free Rates

The return on investment that is guaranteed for a risk-free asset, where there is no risk of financial loss.

Corporate Bond Rate

The interest rate paid by corporations on their issued debt securities (bonds), reflecting the cost of borrowing for the firm and the risk perceived by investors.

Credit Card Debt

The total amount of money owed by consumers that have been accrued through the use of credit cards, often bearing high interest rates.