These are the business rules to build an external model (end user view) of an ERD for our Purchasing Department.These are our business rules:

__________________________________________________________________________

A PURCHASE ORDER (PO) is issued by a purchasing AGENT.

Each AGENT can issue many POs, but each PO is issued by a single AGENT.

Each PO is issued to a single VENDOR. However, each VENDOR can have many POs from us.

Each PO can request many products. HINT: This means that each PO can include many detail lines (LINE), each of which describes one PRODUCT supplied to us by the VENDOR.

The product information is stored in a PRODUCT entity.

The products vendor information is found in a VENDOR entity.

We deal with VENDORs who supply us our raw materials PRODUCTs. And we do purchase the same PRODUCT from multiple VENDORs.

Some of our VENDORS are under approval; therefore, we have some VENDORs from which we have not yet purchased a product.

Create an ERD (visio) based on the business rules that are listed