Question: Develop an Entity-Relationship model for the purchasing requirements described below. 1. The purchasing department of a company issues purchase orders (PO) to its suppliers. 2.
Develop an Entity-Relationship model for the purchasing requirements described below. 1. The purchasing department of a company issues purchase orders (PO) to its suppliers. 2. A purchasing department may buy from multiple suppliers; a supplier may supply products for multiple purchasing departments. a. Each purchasing department may issue multiple POs b. Each PO comes from one purchasing department and is for one supplier c. A supplier may process POs from different purchasing departments. 3. Each PO may reference multiple products; a product may be referenced in multiple PO (through Line Items) a. Each PO has one or more line-items (PO LINE-ITEM). b. Each line item belongs to one PO. c. Each line item is for one product from a supplier. 4. A supplier may supply one or more products, a product is supplied by one supplier. 5. The status of a PO is tracked at the line item level. a. A line item can have multiple statuses. Example of statuses are line item shipped, line item received, line item rejected, line item paid, etc. b. A status can be applicable to multiple line items
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
