Homework Help-Developing an Entity-Relationship model for the purchasing requirements

Homework Help-Developing an Entity-Relationship model for the purchasing requirements

Develop an Entity-Relationship model for the purchasing requirements described below.

The purchasing department of a company issues purchase orders (PO) to its suppliers.

Each PO is for one supplier.

Each PO has one or more line items (PO LINE ITEM).

Each line item belongs to one PO.

Each line item is for one product from a supplier.

A supplier may supply one or more products.

A product from a supplier could be in multiple purchase orders

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.