Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Utopia The Social Audit

Authors: Travis E. Hughes

1st Edition

1505493374, 978-1505493375

More Books

Students also viewed these Accounting questions