The flashcards below were created by user
on FreezingBlue Flashcards.
A property by which subtype entities inherit values of all instances of all relationships of their supertype.
Attribute inheritance pg116
A model that has resulted from extending the original E-R model with new modeling constructs.
Enhanced entity-relationship model (EER) pg 112
A rule that specifies that an entity instance of a supertype is allowed not to belong to any subtype.
A vehicle can be a car or a truck but does not have to be either. (A motorcycle)
Partial specialization rule pg120
A hierarchical arrangement of supertypes and subtypes in which each subtype has only one supertype
Supertype / subtype hierarchy pg124
A type of constraint that addresses whether an instance of a supertype must also be a member of at least one subtype.
The _______ has two possible rules: Total Specialization and Partial Specialization.
Completeness Constraint pg 120
A set of one or more entity types and associated relationships groups into a single abstract entity type.
Entity cluster pg129
The process of defining one or more subtypes of the supertype and forming supertype / subtype relationships.
(A top-down process)
Each subtype is formed based on some distinguishing characteristic, such as attributes or relationships specific to the subtype.
A rule that specifies that each entity instance of a supertype must be a member of some subtype in the relationship.
A patient has to be either an outpatient or a resident patient.
Total specialization rule pg 120
A rule that specifies that an instance of a supertype may not simultaneously be a member of two or more subtypes
Disjoint rule pg 121
The process of defining a more general entity type from a set of more specialized entity types
Generalization pg 117
A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings
A generic or template data model that can be reused as a starting point for a data modeling project.
Universal data model pg 133
A constraint that addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes
Disjointness constraint pg 121
A rule that specifies that an instance of a supertype may simultaneously be a member of two or more subtypes.
Overlap rule pg 122
An attribute of a supertype whose value determines the target subtype or subtypes
Subtype discriminator pg 123
A generic entity type that has a relationship with one or more subtypes.