D426 WGU EXAM / WGU D426 LATEST EXAM STUDY GUIDE
ACTUAL EXAM QUESTIONS AND WELL ELABORATED ANSWERS
(MOST TESTED QUESTIONS WITH VERIFIED ANSWERS) LATEST
UPDATES 2024 |ALREADY GRADED A+ (REVISED EXAM)
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
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)
____ 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
Column A depends on Column B, means each B value is
related to at most one A value. - ANSWER-Depends on
Dependence of one column on another is called ____. -
ANSWER-Functional dependence
____ and ____ entail dependencies between three or more
columns. - ANSWER-Multivalued dependence; join dependence
ACTUAL EXAM QUESTIONS AND WELL ELABORATED ANSWERS
(MOST TESTED QUESTIONS WITH VERIFIED ANSWERS) LATEST
UPDATES 2024 |ALREADY GRADED A+ (REVISED EXAM)
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
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)
____ 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
Column A depends on Column B, means each B value is
related to at most one A value. - ANSWER-Depends on
Dependence of one column on another is called ____. -
ANSWER-Functional dependence
____ and ____ entail dependencies between three or more
columns. - ANSWER-Multivalued dependence; join dependence
