Shared Flashcard Set

Details

Modern Database Management Ch. 3
N/A
16
Computer Science
Graduate
03/02/2014

Additional Computer Science Flashcards

 


 

Cards

Term
enhanced entity-relationship (EER) model
Definition
a model that has resulted from extending the original E-R model with new modeling constructs
Term
subtype
Definition
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
Term
supertype
Definition
a generic entity type that has a relationship with one or more subtypes
Term
inheritance
Definition
change to higher level (supertype) filters to all lower levels (subtypes) automatically
Term
generalization
Definition
the process of defining a more general entity from a set of more specialized entity types
Term
specialization
Definition
the process of defining one or more subtypes of the supertype and forming super type/subtype relationships; each subtype is formed based on some distinguishing characteristic
Term
completeness constraint
Definition
a type of constraint that addresses whether an instance of a super type must also be a member of at least one subtype
Term
total specialization rule
Definition
a rule that specifies that each entity instance of a super type must be a member of some subtype in the relationship
Term
partial specialization
Definition
a rule that specifies that an entity instance of a super type is allowed not to belong to any subtype; motorcycle example
Term
disjointness constraint
Definition
a constraint that addresses whether an instance of a super type may simultaneously be a member of two (or more) subtypes
Term
disjoint rule
Definition
a rule that specifies that an instance of a super type may not simultaneously be a member of two (or more) subtypes (versus overlap rule)
Term
overlap rule
Definition
a rule that specifies that an instance of a super type may simultaneously be a member of two (or more) subtypes (versus disjoint rule)
Term
subtype discriminator
Definition
an attribute of a super type whose values determine the target subtype or subtypes
Term
supertype/subtype hierarchy
Definition
a hierarchical arrangement of super types and subtypes in which each subtype has only one supertype
Term
entity cluster
Definition
a set of one or more entity types and associated relationships grouped into a single abstract entity type
Term
universal data model
Definition
a generic or template data model that can be reused as a starting point for a data modeling project
Supporting users have an ad free experience!