Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need Visio diagram Students should classify the entities in this situation into the following categories: a. Resources -INVENTORY Events PURCHASE ORDERS Agents VENDORS SHIPMENTS PURCHASE
Need Visio diagram
Students should classify the entities in this situation into the following categories: a. Resources -INVENTORY Events PURCHASE ORDERS Agents VENDORS SHIPMENTS PURCHASE CLERKS b. The six entity-relationship pairs might be described as follows: 1. Purchase clerks process or generate purchase orders. Each purchase order is processed by only one purchase clerk (1), but a purchase clerk can process many purchase orders (N), a 1 to N relationship. Purchase orders are sent to vendors. A vendor may receive many (N) orders, but each purchase order is for only one (1) vendor, an N to 1 relationship. 2. 3. Purchase orders are for inventory items. Each purchase order may contain many items (M), and inventory items may be included on many purchase orders (N), an M to N relationship. Purchase orders are filled by shipments. Each shipment is for one purchase order (1), but many shipments (N) may be required to fill an order, a 1 to N relationship. 4. 5. Inventory items are received in shipments. Inventory items (M) may be included in many shipments, and each shipment (N) may contain many inventory items, an M to N relationship 6. Shipments are made by vendors, Many shipments (N) are made from a vendor, but each shipment is made from only one vendor (1), an N to 1 relationship Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started