Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Create an E-R diagram with maximum cardinalities for the shipping of inventory to customers. Show this diagram as an REA model identifying resources, events, and agents. Write a description for each...

1 answer below »

Create an E-R diagram with maximum cardinalities for the shipping of inventory to customers. Show this diagram as an REA model identifying resources, events, and agents.

Write a description for each of the relationships in the diagram. In your description, include the cardinalities.

Answered Same Day Dec 22, 2021

Solution

Robert answered on Dec 22 2021
127 Votes
1
n m
m
1 1
m 1
m 0
n
m
m
1
1 0 m 1
m
Customer
Sales Person
Shipping Person
Cash Receipt
clerk
Order
Places
Takes
Shipping
Product
Ships
Receives
Causes
Receive Cash
Process
Inventory
Cash
Increases
Reduces
Reserves
Duality
Relationships:
Places – exists between Customer and Order. Its cardinality is 1:M as one customer can place more than
one order.
Takes – exists between Sales Person and Order. Its cardinality is...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here