1|Page
WGU D426 OBJECTIVE ASSESSMENT FINAL
EXAM NEWEST 2025 ACTUAL EXAM
COMPLETE 100 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
A ____ does not have an identifying attribute. Instead, a weak
entity usually has a relationship, called an ____, to another
entity, called an ____. Cardinality of the identifying entity is
1(1). - ANSWER-Weak entity; identifying relationship;
identifying entity
A ____ is a subset of another entity type, called the supertype
entity. - ANSWER-Subtype entity
A supertype entity identifies its subtype entities. The identifying
relationship is called an ____. - ANSWER-IsA relationship
____ are entities that have many common attributes and
relationships. - ANSWER-Similar entities
,2|Page
A ____ of a supertype entity is a group of mutually exclusive
subtype entities. - ANSWER-Partition
Each partition corresponds to an optional ____ of the supertype
entity. - ANSWER-Partition attribute
Variations in cardinality conventions are common. One popular
convention, called ____, depicts cardinality as a circle (zero), a
short line (one), or three short lines (many). The three short lines
look like a bird's foot, hence the name "____". - ANSWER-
Crow's foot notation
Decompose a complex model into a group of related entities,
called a ____. - ANSWER-Subject area
Refer to strong entities as ____ and weak entities as ____. -
ANSWER-Independent; dependent
____ is commonly used for software development. Software
data structures are similar to database structures, so UML
includes ER conventions. - ANSWER-Unified Modeling
Language (UML)
, 3|Page
____ 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
A subtype entity becomes a ____. - ANSWER-Subtype table
A weak entity becomes a ____. - ANSWER-Weak table
WGU D426 OBJECTIVE ASSESSMENT FINAL
EXAM NEWEST 2025 ACTUAL EXAM
COMPLETE 100 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+
A ____ does not have an identifying attribute. Instead, a weak
entity usually has a relationship, called an ____, to another
entity, called an ____. Cardinality of the identifying entity is
1(1). - ANSWER-Weak entity; identifying relationship;
identifying entity
A ____ is a subset of another entity type, called the supertype
entity. - ANSWER-Subtype entity
A supertype entity identifies its subtype entities. The identifying
relationship is called an ____. - ANSWER-IsA relationship
____ are entities that have many common attributes and
relationships. - ANSWER-Similar entities
,2|Page
A ____ of a supertype entity is a group of mutually exclusive
subtype entities. - ANSWER-Partition
Each partition corresponds to an optional ____ of the supertype
entity. - ANSWER-Partition attribute
Variations in cardinality conventions are common. One popular
convention, called ____, depicts cardinality as a circle (zero), a
short line (one), or three short lines (many). The three short lines
look like a bird's foot, hence the name "____". - ANSWER-
Crow's foot notation
Decompose a complex model into a group of related entities,
called a ____. - ANSWER-Subject area
Refer to strong entities as ____ and weak entities as ____. -
ANSWER-Independent; dependent
____ is commonly used for software development. Software
data structures are similar to database structures, so UML
includes ER conventions. - ANSWER-Unified Modeling
Language (UML)
, 3|Page
____ 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
A subtype entity becomes a ____. - ANSWER-Subtype table
A weak entity becomes a ____. - ANSWER-Weak table
