January 2009
Beginner to intermediate
641 pages
26h 48m
English
book
The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
by Paul Agnew, Len Silverston
Content preview from The Data Model Resource Book, Volume 3: Universal Patterns for Data Modeling
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Silverston bindex.tex V1 - 11/26/2008 3:36pm Page 594
594 Index ■ E
email address, 311
electronic address, 333
EMPLOYEE, 38
EMPLOYEE role, 43
EMPLOYMENT APPLICATION,
75
enterprise data models, 470
Sands Distribution, 492–503
entities, 18
associative, 25
many-to-many relationships,
26–27
classifying, 197
consolidation, 277
enterprise data models, 492
self association, 165
status, number of, 260
status types, 241
in statuses, 245
subentities, 19
subtypes, 257
ENTITY
attributes, 76
classifications, 190–191, 198
contextual roles, 76
instances, roles, 76
parents, 148
status type id attribute, 257
SUBTYPE 1, 198
SUBTYPE 2, 198
SUBTYPE 3, 198
ENTITY 1
aggregation and, 139
foreign key, 147
hierarchy and, 139
parent entity id foreign key,
147
ENTITY 2
aggregation and, 139
hierarchy and, 139
ENTITY 3
aggregation and, 139
hierarchy and, 139
ENTITY 1 CONTACT
MECHANISM, 350
ENTITY ASSOCIATION, 165–167
ENTITY ASSOCIATION 1, 156
ENTITY ASSOCIATION 2, 156
ENTITY ASSOCIATION RULE,
174, 176
ENTITY ASSOCIATION TYPE,
157, 165–167
ENTITY CATEGORY, 209–210
recursion, 211
ENTITY CATEGORY
CLASSIFICATION, 209
ENTITY CATEGORY ROLLUP,
225
ENTITY CATEGORY ROLLUP
RULE, 229
ENTITY CATEGORY TYPE,
209–210
classification and, 211
hierarchy, 211–212
schemes, 223
ENTITY CATEGORY TYPE
ROLLUP, 225
ENTITY CATEGORY TYPE
ROLLUP RULE, 229
ENTITY CATEGORY TYPE
SCHEME, 223
ENTITY CONTACT
MECHANISM, 327, 350
Entity-Relationship Modeling, 4
ENTITY STATUS, 262
status datetime attribute, 263
status