UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
Subtypes that contain nonunique subsets of the supertype entity set are known as ________.
overlapping subtypes
Every subtype can ________.
have only one supertype to which it is related
________ refer to data whose values change in the future and for which you must keep a history of
the data changes.
Time-variant data
Which of the following is true of entity supertypes and subtypes?
A supertype contains those attributes that are common to all of its subtypes.
Which of the following types of primary key is useful to represent M:N relationships?
Composite key
A specialization hierarchy reflects the ________.
1:1 relationship between an entity supertype and its subtypes
The ________ adds support for entity supertypes, subtypes, and entity clustering.
extended entity relationship model
A ________ is especially helpful when there is no natural key.
surrogate primary key
In an organization's data model, employees are grouped to ________.
avoid nulls when some employees have characteristics that are not shared by other employees
In MS Visio, the completeness constraint is based on the ________.
category shape
When defining a 1:1 relationship where both sides of the relationship are mandatory, ________.
the foreign key that causes the fewest nulls should be selected
A(n) ________ occurs when a relationship is improperly or incompletely identified and, therefore, is
represented in a way that is not consistent with the real world.
design trap
LATEST UPDATE (ALREADY GRADED A+)
Subtypes that contain nonunique subsets of the supertype entity set are known as ________.
overlapping subtypes
Every subtype can ________.
have only one supertype to which it is related
________ refer to data whose values change in the future and for which you must keep a history of
the data changes.
Time-variant data
Which of the following is true of entity supertypes and subtypes?
A supertype contains those attributes that are common to all of its subtypes.
Which of the following types of primary key is useful to represent M:N relationships?
Composite key
A specialization hierarchy reflects the ________.
1:1 relationship between an entity supertype and its subtypes
The ________ adds support for entity supertypes, subtypes, and entity clustering.
extended entity relationship model
A ________ is especially helpful when there is no natural key.
surrogate primary key
In an organization's data model, employees are grouped to ________.
avoid nulls when some employees have characteristics that are not shared by other employees
In MS Visio, the completeness constraint is based on the ________.
category shape
When defining a 1:1 relationship where both sides of the relationship are mandatory, ________.
the foreign key that causes the fewest nulls should be selected
A(n) ________ occurs when a relationship is improperly or incompletely identified and, therefore, is
represented in a way that is not consistent with the real world.
design trap
