expand icon
book Accounting Information Systems 8th Edition by James Hall cover

Accounting Information Systems 8th Edition by James Hall

Edition 8ISBN: 978-1111972141
book Accounting Information Systems 8th Edition by James Hall cover

Accounting Information Systems 8th Edition by James Hall

Edition 8ISBN: 978-1111972141
Exercise 79
NORMALIZATION OF DATAPURCHASE ORDER
Acme Plywood Company uses the purchase order shown in the diagram for Problem 14. Acme business rules:
1. Each vendor may supply many items; an item is supplied by only one vendor.
2. A purchase order may list many items; an item may be listed on many purchase orders.
3. An employee may complete several purchase orders, but only one employee may fill out an individual PO.
Prepare the 3NF base tables needed to produce this purchase order.
NORMALIZATION OF DATAPURCHASE ORDER  Acme Plywood Company uses the purchase order shown in the diagram for Problem 14. Acme business rules:  1. Each vendor may supply many items; an item is supplied by only one vendor.  2. A purchase order may list many items; an item may be listed on many purchase orders.  3. An employee may complete several purchase orders, but only one employee may fill out an individual PO. Prepare the 3NF base tables needed to produce this purchase order.
Explanation
Verified
like image
like image

Normalization of Purchase Order:
Remove...

close menu
Accounting Information Systems 8th Edition by James Hall
cross icon