Set: Modern Database Management - Chapter 4

Familiarize

Learn

Test

Play Scatter

Play Space Race

Voice Race

Combine with other sets Login to add to Favorites
Print: Term List | Flashcards Editing not allowed
Export Deleting not allowed

Share these flash cards

With group: None
HTML link to set: Tiny link:
Share on Facebook Share on MySpace

All 23 terms

TermDefinition
Enhanced entity-relationship (EER) modelThe model that has resulted from extending the original E-R model with new modeling constructs.
SubtypeA 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 subgrouping of the entities in an entity type that has attributes distinct from those in other subgroupings
SupertypeA generic entity type that has a relationship with one or more subtypes
Attribute inheritanceA property by which subtype entities inherit and stances of all relationships of the supertype.
GeneralizationThe process of defining a more general entity type from a set of more specialized entity types.
SpecializationThe process of defining one ore more subtypes of the supertype and forming supertupe/subtype relationships.
Completeness constraintA type of constraint that addresses the question whether an instance of a supertype must also be a member of at least one subtype.
Total specialization ruleSpecifies that each entity instance of the supertype must be a member of some subtype in the relationship.
Partial specialization ruleSpecifies that an entity instance of the supertype is allowed not to belong to any subtype.
Disjointness constraintA constraint that addresses the question whether an instance of a supertype may simultaneously be a member of two (or more) subtypes.
Disjoint ruleSpecifies that if an entity instance (of the supertype) is a member of one subtype, it cannot simultaneously be a memeber of any other subtype.
Overlap ruleSpecifies that an entity instance can simultaneously be a member of two (or more) subtypes.
Subtype discriminatorthe attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related (p187)
Supertype/subtype hierarchyA hierarchical arrangement and subtypes, where each subtype has only one supertype.
Entity clusterA set of one or more entity types and associated relationship grouped into a single abstract entity type.
Universal data modelA generic or template data model that can be reused as a starting point for a data modeling project.
DerivationA statement derived from other knowledge in the business
Action assertionA statement of a constraint or control on the actions of the organization.
Structural assertionA statment that expresses some aspect of the static structure of the organization.
Derived factA fact is derived from business rules using an algorithm or inference
Anchor objectA business rule (a fact) on which actions are limited.
ActionAn operation, such as create. delete, update, or read, which may be performed on data object.
Corresponding objectA business rule (a fact) that influences the ability to perform an action on another business rule.

Set Information

Terms 23
Creator kdetaylor
Created September 17, 2009
Groups None
Subject The Enhanced E-R Model and Business Rules
Access Anyone
Edit Creator Only
Get rid of ads on Quizlet
Pop out

Discuss

No Messages
Last Message: never

You must be logged in to discuss this set.