Shared Flashcard Set

Details

Chapter 3
The Enhanced E-R Model/MIS 380
15
Other
Undergraduate 3
02/05/2018

Additional Other Flashcards

 


 

Cards

Term
Enhanced entity-relationship (EER) model
Definition
A model that has resulted from extending the original E-R model with new modeling.
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
Attribute inheritance
Definition
a property by which subtype entities inherit values of all attributes and instances of all relationships of their supertype.
Term
Generalization
Definition
The process of defining a more general entity type from a set of more specialized entity types.
Term
Supertype
Definition
A generic entity type that has a relationship with one or more subtypes.
Term
Specialization
Definition
The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships.
Term
Completeness constraint
Definition
A type of constraint that address whether an instance of a supertype must also be a member of at least one subtype
Term
Total specialization rule
Definition
A rule that specifies each entity instances of supertype must be a member of some subtype in the relationship.
Term
Partial specialization rule
Definition
A rule that specifies that an entity instance of a supertype is allowed not to belong to any subtype.
Term
Disjointness constraint
Definition
A constraint that addresses whether an instance of a supertype may simultaneously be a member of two (or more) subtypes.
Term
Disjoint rule
Definition
A rule that specifies that an instance of a supertype may not simultaneously be a member of two (or more) subtypes
Term
Overlap rule
Definition
A rule that specifies that an instance of a supertype may simultaneously be a member of two (or more) subtypes.
Term
Subtypes discriminator
Definition
An attribute of a subtype whose values determine the target subtype or subtypes.
Term
Supertype/subtype hierarchy
Definition
A hierarchy arrangement of supertypes and subtypes in which each subtype has only one supertype.
Term
Universal data model
Definition
A generic or template data model that can be revised as a starting point for a data modeling project.
Supporting users have an ad free experience!