Reference no: EM132899988

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