The completeness constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype. b. The completeness constraint specifies whether each entity subtype occurrence must also be a member of at least one supertype. c. Partial completeness constraint means that every supertype occurrence is a member of a subtype. d. Total completeness constraint means that every subtype occurrence must be a member of at least one supertype.
Thiru DBMS
Completeness Constraint
The completeness constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype. The completeness constraint can be partial or total.
Partial completeness (symbolized by a circle over a single line) means that not every supertype occurrence is a member of a subtype; that is, there may be some supertype occurrences that are not members of any subtype.
A single horizontal line under the circle represents a partial completeness constraint. For example consider the following figure
Total completeness (symbolized by a circle over a double line) means that every supertype occurrence must be a member of at least one subtype.
A double horizontal line under the circle represents a total completeness constraint. Consider the following diagram.
Given the disjoint/overlapping subtypes and completeness constraints, it’s possible to have the specialization hierarchy constraint scenarios shown in the following Table
You May Also Like:
Entity supertype and Subtype
Specialization Hierarchy
Subtype Discriminator
Surrogate Primary key
Find Other DBMS Questions
Extended entity relationship diagram
result of adding more semantic constructs to the ER model. This model is used to make an EER diagram
contain unique subset of supertype entity set.
subtypes that contain nonunique subsets of the supertype entity set
Specifies whether each entity supertype occurrence must also be a member of at least one subtype
(circle over single line) means that not every supertype occurrence is a member of a subtype
(circle over double line) every supertype occurrence must be a member of at least one subtype
top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype
bottom-up process of identifying a higher-level more generic entity supertype from lower-level entity subtypes
a virtual entity type used to represent multiple entities and relationships in the ERD
Natural key (natural identifier)
real world identifier that uniquely identifies a real world object
Primary key created by the database designer to simplify the identification of entity instances
The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
- specialization
- uniqueness
- inheritance
- completeness
In addition to the normal behavior, the EER model also supports specialization ____ where a subtype can have multiple parents (supertypes).
- nets
- networks
- lattices
- webs
____ relationships occur when there are multiple relationship paths between related entities.
- Shared
- Redundant
- Joined
- Nonkey
A specialization hierarchy reflects the ____ relationship between EMPLOYEE and its subtypes.
A(n) ____ trap occurs when a relationship is improperly or incompletely identified and, therefore, is represented in a way that is not consistent with the real world.
- entity
- relationship
- key
- design
In modeling terms, the ____ contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
- entity supertype
- superentity
- base entity
- higher entity
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
- specialization
- generalization
- inheritance
- uniqueness
The implementation of disjoint subtypes is based on the value of the subtype discriminator attribute in the ____.
- supertype
- subtype
- primary key attribute
- foreign key attribute
The ____'s function is to guarantee entity integrity.
- entity name
- discriminator
- index
- primary key
What is the best data type for a primary key?
- numeric
- text
- boolean
- date
____ data refer to data whose values change over time and for which you must keep a history of the data changes.
- Closed
- Historical
- Time-complete
- Time-variant
Arguably, the most important characteristic of an entity is its ____.
- name
- primary key
- relationships
- attributes
____ subtypes are subtypes that contain nonunique subsets of the supertype entity set.
- Shared
- Overlapping
- Joined
- Complex
One important inheritance characteristic is that all entity subtypes inherit their ____ from their supertype.
- indexes
- foreign keys
- candidate keys
- primary key attribute
____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
- Discrimination
- Specialization
- Completeness
- Generalization
As part of database naming conventions, attribute names should use suffixes such as _ID, _NUM, or _CODE for the ____ attribute.
- primary key
- foreign key
- index
- determinant
The EER model builds on ER concepts and adds support for entity supertypes, subtypes, and entity ____.
- clustering
- housing
- joining
- extension
A(n) ____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.
- inheritance key
- subtype discriminator
- supertype selector
- subtype entity
____________ is used when an entity is composed of (or is formed by) a collection of other entities, but the entities are independent of each other. That is, the relationship can be classified as a ‘has_a’ relationship type.
- Specialization
- Generalization
- Aggregation
- Composition
__________ is used when when two entities are associated in an aggregation association with a strong identifying relationship and deleting the parent deletes the children instances.
- Specialization
- Generalization
- Clustering
- Composition