Data Modeling with the Entity-Relationship Model - Database Processing: Fundamentals, Design, and Implementation - page 219

5.35 Describe the relationship between the structure of forms and reports and the data model.
5.36 Explain two ways forms and reports are used for data modeling.

5.37 Explain why the form and report in Figure 5-15 indicate that the underlying relation-
ship is 1:1.
5.38 Why is it not possible to infer minimum cardinality from the form and report in Figure 5-15?

5.39 Describe two tests for determining if an entity is a strong entity.
5.40 Why does the form in Figure 5-17 not indicate that the underlying relationship is 1:N?
What additional information is required to make that assertion?

5.41 Explain why two forms or reports are usually needed to infer maximum cardinality.
5.42 How can you assess minimum cardinality for the entities in the form in Figure 5-17?

5.43 Explain why the form and report in Figure 5-19 indicate that the underlying relation-
ship is N:M.
5.44 Name three patterns that use ID-dependent relationships.

5.45 Explain how the association pattern differs from the N:M strong entity pattern. What
characteristic of the report in Figure 5-21 indicates that an association pattern is needed?
5.46 In general terms, explain how to differentiate an N:M strong entity pattern from an as-
sociation pattern.

5.47 Explain why two entities are needed to model multivalued attributes.
5.48 How do the forms in Figures 5-26 and 5-28 differ? How does this difference affect the
data model?

5.49 Describe, in general terms, the archetype/instance pattern. Why is an ID-dependent
relationship needed for this pattern? Use the CLASS/SECTION example shown in
Figure 5-30 in your answer.
5.50 Explain what caused the entities in Figure 5-31 to change from ID-dependent entities.

5.51 Summarize the two sides in the argument about the importance of weak, but not ID-
dependent, entities.
5.52 Give an example of the line-item pattern as it could be used to describe the contents of a
shipment. Assume that the shipment includes the names and quantities of various items
as well as each item's insured value. Place the insurance value per item in an ITEM entity.

5.53 What entity type should come to mind when you see the words “For use by” in a form?
5.54 Give examples of 1:1, 1:N, and N:M recursive relationships (other than those presented
in this chapter).

5.55 Explain why the data modeling process must be iterative. Use the Highline University
example.

Project Questions

answer the following questions using IE Crow's Foot notation.

5.56 Examine the subscription form shown in Figure 5-53. Using the structure of this form,
do the following:

Create a model with one entity. Specify the identifier and attributes. a.

Create a model with two entities, one for customer and a second for subscription.
Specify identifiers, attributes, relationship name, type, and cardinalities.

B.