Enhanced ERD

Question 1

A subgrouping of the entities in an entity type that has attributes distinct from those in other subgrouping

Answer 1

Subtype

Question 2

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

Answer 2

Supertype

Question 3

An instance of a subtype is also an instance of the?

Answer 3

supertype

Question 4

______ entities inherit values of all attributes of the supertype

Answer 4

subtype

Question 5

Relationships at the _________ level indicate that all subtypes will participate in the relationship

Answer 5

supertype

Question 6

The instances of a __________ may participate in a relationship unique to that subtype.

Answer 6

subtype

Question 7

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

Answer 7

Generalization (BOTTOM-UP)

Question 8

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

Answer 8

Specialization (TOP-DOWN)

Question 9

Whether an instance of a supertype must also be a member of at least one subtype.

Answer 9

Completeness Constraints

Question 10

Total specialization Rule

Answer 10

double line

Question 11

Partial Specialization Rule

Answer 11

single line

Question 12

Whether an instance of a supertype may simultaneously be a member of two (or more) subtypes

Answer 12

Disjointness Constraints

Question 13

An instance of the supertype can be only ONE of the subtypes

Answer 13

Disjoint Rule

Question 14

An instance of the supertype could be more than one of the subtypes

Answer 14

Overlap Rule

Question 15

An attribute of the supertype whose values determine the target subtype(s)

Answer 15

Subtype Discriminator

Question 16

a simple attribute with alternative values to indicate the possible subtypes

Answer 16

Disjoint

Question 17

A composite attribute whose subparts pertain to different subtypes. Each subpart contains a boolean value to indicate whether or not the instance belongs to the associated subtype

Answer 17

Overlapping

Question 18

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

Answer 18

Entity cluster

Question 19

Derived from other knowledge, often in the form of a formula using attribute values.

Answer 19

Derivation-rule

Question 20

Expressing static structure. Includes attributes, relationships, and definitions.

Answer 20

Structural assertion-rule

Question 21

Expressing contraints/control of organizational actions.

Answer 21

Action assertion-rule

Question 22

an object on which actions are limited

Answer 22

Anchor Object

Question 23

an object influencing the ability to perform an action on another business rule

Answer 23

Corresponding Objects