Question: Below are two cardinality problems. For each one indicate which cardinalities would go into each spot and why. (1) WalInc sells millions of item types
Below are two cardinality problems. For each one indicate which cardinalities would go into each spot and why.
(1) WalInc sells millions of item types (inventory). Wallnc may have multiple quantities of each inventory type, none of which are uniquely identifiable. Customers often purchase multiple items on one sale. What is the relationship between inventory and sales? WallInc doesnt sell services.
inventory types<--------->sales invoices
(2) She She is an upscale ladies clothing store. Customers have been known to spend more than $100,000 per visit. The employees are paid on commission, so each sales person who assists on a sale is recorded to earn part of the commission.
Sales to customers<--------->sales persons
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
