Page 235 - Using MIS

MyMISLab 203

MyMISLab ™

Go to mymislab.com for Auto-graded writing questions as well as the following
Assisted-graded writing questions:

5-17. Using your answer to question 5-3, draw an E-R diagram for the data entry
form in Figure 5-28. Specify cardinalities. State your assumptions.
5-18. The partial E-R diagram in Figure 5-38 is for a sales order. Assume there is
only one Salesperson per SalesOrder.
a. Specify the maximum cardinalities for each relationship. State your
assumptions, if necessary.
b. Specify the minimum cardinalities for each relationship. State your
assumptions, if necessary.

SalesOrder Customer
Salesperson
OrderNumber Name
Name OrderDate Street
Phone SubTotal City
EmailAddress
?? ?? Shipping ?? ?? State
Tax ZipCode
OrderTotal EmailAddress
??

Line-Item ?? Item
Quantity ItemNumber
QuotedPrice Cost
ExtendPrice ?? ?? Price
Figure 5-38 QuantityOnHand
Partial E-R Diagram for
SalesOrder