Consider the E-R diagram in Figure 8-24, on page 287 of the text. For the E-R diagram provided in Figure 8-24, rather than draw in the cardinalities, describe the minimum and maximum cardinalities for each relationship shown on the ERD and listed below. Describe any assumptions you must make about relevant business rules. Are there any changes or additions you would make to this diagram to make it better? Why or why not?

You MUST provide a cardinality in EACH direction of EACH relationship.

Relationship:

Place

Generates

Includes

Comprised of

Supplied by

CHAPTER 8 STRUCTURING SYSTEM DATA REQUIREMENTS FIGURE 8-24 ER diagram for Problem and Exercises 854 and 8-55 CUSTOMER Places ORDER BACKORDER Generates Includes PRODUCTC Comprised of COMPONENT Suppliled by VENDOR