f f
andDesign f
Seventh Edition f
Jeffrey A. Hoffer Jo f f f
ey F. George Josep
f f f
hS.Valacich
f f
Chapter 8 Structuring f f f
SystemData
f
Requirements
,LearningObjectives f
✓ Concisely define each of the following key data mo
f f f f f f f f
deling terms: entity type, attribute, multivalued attr
f f f f f f
ibute, relationship, degree, cardinality, business r
f f f f f
ule, associative entity, trigger, supertype, subtype
f f f f f
.
✓ Draw an entity-relationship (E-
f f f
R) diagram to represent common business situ
f f f f f f
ations.
✓ Explain the role of conceptual data modeling in the o
f f f f f f f f f
verall analysis and design of an information system.
f f f f f f f
Chapterf8 ©f2014fPearsonfEducation,fInc.fPublishingfasfPrenticefHall 2
,LearningObjectives(Cont.) f f
✓ Explain the role of prepackaged database m
f f f f f f
odels (patterns) in data modeling.
f f f f
✓ Distinguish between unary, binary, and ternary rel
f f f f f f
ationships and give an example of each.
f f f f f f
✓ Define four basic types of business rules in a con
f f f f f f f f f
ceptual data model. f f
✓ Relate data modeling to process and logic mod
f f f f f f f
eling as different views of describing an informa
f f f f f f f
tion system.
f
Chapterf8 ©f2014fPearsonfEducation,fInc.fPublishingfasfPrenticefHall 3
, ConceptualData Modeling f f
■ Conceptual data modeling: a detailed mod
f f f f f
el thatcaptures theoverall structureof data in a
f f f f f f f f f
n organization
f
□Independent of any database management sy
f f f f f
stem (DBMS) or other implementation consid
f f f f f
erations
Chapterf8 ©f2014fPearsonfEducation,fInc.fPublishingfasfPrenticefHall 4