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

5.7 Define attribute . Give an example attribute for the entity in your answer to Review
Question 5.5.
5.8 Define identifier . Give an example identifier for the entity in your answer to Review
Question 5.5.
5.9 Give an example of a composite identifier.
5.10 Define relationship . Give an example of a relationship (other than one presented in this
chapter). Name your relationship.
5.11 Explain the difference between a relationship class and a relationship instance.
5.12 What is the degree of relationship? Give an example of a relationship of degree three
(other than one presented in this chapter).
5.13 What is a binary relationship?
5.14 Explain the difference between an entity and a table. Why is this difference important?
5.15 What does cardinality mean?
5.16 Define the terms maximum cardinality and minimum cardinality .
5.17 Give examples of 1:1, 1:N, and N:M relationships (other than those presented in this
chapter). Draw two E-R diagrams for each of your examples, one using the traditional
diamond notation, and one using IE Crow's Foot notation.
5.18 Give an example for which the maximum cardinality must be an exact number.
5.19 Give examples of M-M, M-O, O-M, and O-O relationships (other than those presented
in this chapter). Draw two E-R diagrams for each of your examples, one using the tradi-
tional diamond notation, and one using IE Crow's Foot notation.
5.20 Explain, in general terms, how the traditional E-R model, the IE Crow's Foot version, the
IDEF1X version, and the UML version differ. Which version is used primarily in this text?
5.21 Explain how the notations shown in Figure 5-7 differ.
5.22 Explain how the notations shown in Figure 5-9 differ.
5.23 What is an ID-dependent entity? Give an example of an ID-dependent entity (other
than one presented in this chapter).
5.24 Explain how to determine the minimum cardinality of both sides of an ID-dependent
relationship.
5.25 What rules exist when creating an instance of an ID-dependent entity? What rules
exist when deleting the parent of an ID-dependent entity?
5.26 What is an identifying relationship? How is it used?
5.27 Explain why the relationship between BUILDING and APARTMENT discussed on
page 189 is an identifying relationship.
5.28 What is a weak entity? How do weak entities relate to ID-dependent entities?
5.29 What distinguishes a weak entity from a strong entity that has a required relationship
to another entity?
5.30 Define subtype and supertype . Give an example of a subtype-supertype relationship
(other than one presented in this chapter).
5.31 Explain the difference between exclusive subtypes and inclusive subtypes. Give an
example of each.
5.32 What is a discriminator?
5.33 Explain the difference between IS-A and HAS-A relationships.
5.34 What is the most important reason for using subtypes in a data model?