CIS 4600 Chapter 3 Terms.txt

Card Set Information

Author:
icdavidson
ID:
173891
Filename:
CIS 4600 Chapter 3 Terms.txt
Updated:
2012-09-27 16:06:47
Tags:
Business Modern Database Management 11th Edition Hoffer Ramesh Topi CIS4600
Folders:

Description:
Modern Database Management 11th Edition Chapter 3 Terms Vocabulary
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user icdavidson on FreezingBlue Flashcards. What would you like to do?


  1. A property by which subtype entities inherit values of all instances of all relationships of their supertype.
    Attribute inheritance pg116
  2. A model that has resulted from extending the original E-R model with new modeling constructs.
    Enhanced entity-relationship model (EER) pg 112
  3. A rule that specifies that an entity instance of a supertype is allowed not to belong to any subtype.
    Example:
    A vehicle can be a car or a truck but does not have to be either. (A motorcycle)
    Partial specialization rule pg120
  4. A hierarchical arrangement of supertypes and subtypes in which each subtype has only one supertype
    Supertype / subtype hierarchy pg124
  5. 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
  6. A set of one or more entity types and associated relationships groups into a single abstract entity type.
    Entity cluster pg129
  7. 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.
    Specialization pg119
  8. A rule that specifies that each entity instance of a supertype must be a member of some subtype in the relationship.

    Example:
    A patient has to be either an outpatient or a resident patient.
    Total specialization rule pg 120
  9. 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
  10. The process of defining a more general entity type from a set of more specialized entity types
    Generalization pg 117
  11. 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
    Subtype pg113
  12. A generic or template data model that can be reused as a starting point for a data modeling project.
    Universal data model pg 133
  13. A constraint that addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes
    Disjointness constraint pg 121
  14. A rule that specifies that an instance of a supertype may simultaneously be a member of two or more subtypes.
    Overlap rule pg 122
  15. An attribute of a supertype whose value determines the target subtype or subtypes
    Subtype discriminator pg 123
  16. A generic entity type that has a relationship with one or more subtypes.
    Supertype pg 113

What would you like to do?

Home > Flashcards > Print Preview