Review the E- R diagram in Figure and:

a. List the resources, events, and agents that are represented as entities in this diagram.
b. Write a description for each of the six relationships in the diagram. In your description, include the cardinalities. For example, you might describe the relationship between VENDORS and PUR-CHASE ORDERS as: “Purchase orders are sent to vendors. A vendor may receive many (N) orders, but each purchase order is for only one ( 1) vendor.”
c. Redraw Figure using Microsoft Visio (or othersoftware).

Transcribed Image Text:

PURCHASE CLERKS processed by PURCHASE N sent to ORDERS VENDORS order item made by INVENTORY M received item NI SHIPMENTS