WGU D426 DATA MANAGEMENT
FOUNDATIONS FINAL EXAM WITH REAL
QUESTIONS AND WELL VERIFIED ANSWERS
// GUARANTEED PASS// LATEST 2024/2025
In entity-relationship modeling, ____ refers to maxima and minima of relationships
and attributes. - ANSWER-Cardinality
____ is the greatest number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-Relationship maximum
A related entity is ____ when the maximum is one and ____ when the maximum is
many. - ANSWER-Singular; plural
____ is the least number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-Relationship minimum
A related entity is ____ when the minimum is zero and ____ when the minimum is
one. - ANSWER-Optional; required
____ is the greatest number of attribute values that can describe each entity
instance. ____ is usually specified as one (singular) or many (plural). - ANSWER-
Attribute maximum
____ is the least number of attribute values that can describe each entity instances.
____ is usually specified as zero (optional) or one (required). - ANSWER-
Attribute minimum
, Each value of a ____ describes at most one entity instance. - ANSWER-Unique
attribute
An ____ is unique, singular, and required. - ANSWER-Identifying attribute
____ values correspond one-to-one to, or identify, entity instances. - ANSWER-
Identifying Attribute
____ is commonly used for software development. Software data structures are
similar to database structures, so UML includes ER conventions. - ANSWER-
Unified Modeling Language (UML)
____ stands for Information Definition version 1x. ____ became popular, in part,
due to early adoption by the United States Department of Defense. - ANSWER-
IDEF1X
____ appeared in an early ER modeling paper by Peter Chen. ____ is not
standardized but often appears in literature and tools. - ANSWER-Chen notation
A strong entity becomes a ____. The primary key must be unique and non-NULL,
and should be stable, simple, and meaningless. Single-column primary keys are
best, but if no such column exists, a composite primary key may have the required
properties. - ANSWER-Strong table
An ____ is a single-column primary key created by the database designer when no
suitable single-column or composite primary key exists. - ANSWER-Artificial key
FOUNDATIONS FINAL EXAM WITH REAL
QUESTIONS AND WELL VERIFIED ANSWERS
// GUARANTEED PASS// LATEST 2024/2025
In entity-relationship modeling, ____ refers to maxima and minima of relationships
and attributes. - ANSWER-Cardinality
____ is the greatest number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-Relationship maximum
A related entity is ____ when the maximum is one and ____ when the maximum is
many. - ANSWER-Singular; plural
____ is the least number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-Relationship minimum
A related entity is ____ when the minimum is zero and ____ when the minimum is
one. - ANSWER-Optional; required
____ is the greatest number of attribute values that can describe each entity
instance. ____ is usually specified as one (singular) or many (plural). - ANSWER-
Attribute maximum
____ is the least number of attribute values that can describe each entity instances.
____ is usually specified as zero (optional) or one (required). - ANSWER-
Attribute minimum
, Each value of a ____ describes at most one entity instance. - ANSWER-Unique
attribute
An ____ is unique, singular, and required. - ANSWER-Identifying attribute
____ values correspond one-to-one to, or identify, entity instances. - ANSWER-
Identifying Attribute
____ is commonly used for software development. Software data structures are
similar to database structures, so UML includes ER conventions. - ANSWER-
Unified Modeling Language (UML)
____ stands for Information Definition version 1x. ____ became popular, in part,
due to early adoption by the United States Department of Defense. - ANSWER-
IDEF1X
____ appeared in an early ER modeling paper by Peter Chen. ____ is not
standardized but often appears in literature and tools. - ANSWER-Chen notation
A strong entity becomes a ____. The primary key must be unique and non-NULL,
and should be stable, simple, and meaningless. Single-column primary keys are
best, but if no such column exists, a composite primary key may have the required
properties. - ANSWER-Strong table
An ____ is a single-column primary key created by the database designer when no
suitable single-column or composite primary key exists. - ANSWER-Artificial key
