Consider the E-R diagram in Figure 8-24, on page 287 of the text. For the E-R di

Question

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

Explanation / Answer

Relationships:

Places: Minimum Cardinality: One to Many (Assuming one customer places or can place many orders)

Maximum Cardinality: Many to Many (Assuming many customers place many orders)

Generates: Minimum Cardinality: One to One (Assuming one Order generates one back Order that is relevant to the business purpose for processing the customer demand and processing the order)

Maximum Cardinality: Many to Many (Assuming many Order generates many back orders)

Includes: Maximum Cardinality: Many to Many (Considering that Many orders may have many products)

Minimum Cardinality: One to Many (Considering that One Order includes Many products)

Comprised of: Maximum Cardinality: One to Many (Here we consider that One Product is having multiple Components i.e subparts)

Minimum Cardinality: One to One (Here considering that one product comprises of one component)

Supplied by: Minimum Cardinality: Many to One (Considering many components are supplied by a specific vendor)

Maximum Cardinality: Many to Many (Considering Multiple components supplied by multiple vendors)

The general business rules apply to this ERD. As it is depending upon the business needs the cardinality structure can change depending upon situations.

For a default business structure the above ERD Model is all good as it covers all the modules needed currently.

Further customizations can be made on requirement basis for this business ERD.

Also base on business requirements the cardinality can be changed for the relationships and also it depends on the user purview of the model.

Above, I have presented my views.

**//Like the answer if you like my approach.

// Comment for any other explanations.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.