MIS 372 - Ch. 4

The model that has resulted from extending the original E-R model with new modeling constructs.

A subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct for other subgroupings.

A generic entity type that has a relationship with one or more subtypes.

A property by which subtype entities inherit values of all attributes and instances of all relationships of the supertype.

The process of defining a more general entity type from a set of more specialized entity types.

The process of defining one or more subtypes of the supertype and forming supertype/subtype relationships.

A type of constraint that addresses the question whethe ran instance of a supertype must also be a member of at least one subtype.

Specifies that each entity instance of the supertype must be a membe rof some subtype in the relationship.

Specifies that an instance of the supertype is allowed not to belong to any subtype.

"A constraint that addresses the question whether an instance of a supertype may simultaneously be a member of two (or more) subtypes.

A rule that specifies that an instance of a supertype may not simultaneously be a member of two (or more) subtypes.

A rule that specifies that an instance of a supertype may simultaneously be a member of two (or more) subtypes.

An attribute of the supertype whose values determine the target subtype or subtypes.

A hierarchical arrangement of supertypes and subtypes, where each subtype has only one supertype.

A set of one or more entity types and associated relationships grouped into a single abstract entity type.

A generic or template data model that can be reused as a starting point for a data modeling project.

A statement derived from other knowledge in the business.

A statement that expresses some aspect of the static structure of the organization.

An operation, such as create, delete, update, or read, which may be performed on data objects.

A statement of a constraint or control on the actions of the organization.

A business rule (a fact) on which actions are limited.

A fact that is derived from business rules using an algorithm or inference.

A business rule (a fact) that influences the ability to perform an action on another business rule.