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 1 / 2
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
- / 2