Question: Develop an Entity-Relationship model for the purchasing requirements described below. 1. The purchasing department of company issues purchase orders (PO) to its suppliers. 2. Each
Develop an Entity-Relationship model for the purchasing requirements described below.
1. The purchasing department of company issues purchase orders (PO) to its suppliers.
2. Each PO is for one supplier.
3. Each PO has one or more line items (PO LINE ITEM).
4. Each line item belongs to one PO.
5. Each line item is one product from a supplier.
6. A supplier may supply one or more products.
7. A product from a supplier could be on multiple purchase orders.
8. The status of a PO is tracked at the line item level.
Example of statuses are line item shipped, line item received, line item rejected, line item paid, etc.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
