WGU C170 EXAM WITH 100% CORRECT
AND VERIFIED ANSWERS
Correct 174
100%
Incorrect 00
Your answers
1 of 174
Definition
An entity designed to transform an M:N relationship into
two 1:M
relationships. The composite entity's primary key comprises
at least the primary keys of the entities that it connects.
Also known as a bridge entity. See also linking table.
Give this one a try later!
repeating group composite entity
reserved words predicate logic
Don't know?
2 of 174
,Term
,nonkey attribute
Give this one a try later!
An attribute that
cannot be subdivided
In relational algrebra, see
SELECT into meaningful
components. Compare
to composite attribute.
A branch of mathematics that
See nonprime
attribute. uses the logical operators OR,
AND, and NOT.
Don't know?
3 of 174
Definition
A SQL aggregate function that outputs the number
of rows containing not null values for a given
column or expression, sometimes used in
conjunction with the DISTINCT clause.
Give this one a try later!
SUM COUNT
JOIN closure
Don't know?
, 4 of 174
Term
participants
Give this one a try later!
The level of detail An ER term for entities
represented by the values that participate in a
stored in a table's row. relationship.
A process based on Dealing with or related to
repetition of steps and sets, or groups of things.
procedures.
Don't know?
5 of 174
Term
cascading order sequence
Give this one a try later!
The second stage in the normalization process, in which a relation is in
1NF and there are no partial dependencies (dependencies in only
part of the primary key).
A nested ordering sequence for a set of rows, such as a list in
which all last names are alphabetically ordered and, within the last
names, all first names are ordered.
AND VERIFIED ANSWERS
Correct 174
100%
Incorrect 00
Your answers
1 of 174
Definition
An entity designed to transform an M:N relationship into
two 1:M
relationships. The composite entity's primary key comprises
at least the primary keys of the entities that it connects.
Also known as a bridge entity. See also linking table.
Give this one a try later!
repeating group composite entity
reserved words predicate logic
Don't know?
2 of 174
,Term
,nonkey attribute
Give this one a try later!
An attribute that
cannot be subdivided
In relational algrebra, see
SELECT into meaningful
components. Compare
to composite attribute.
A branch of mathematics that
See nonprime
attribute. uses the logical operators OR,
AND, and NOT.
Don't know?
3 of 174
Definition
A SQL aggregate function that outputs the number
of rows containing not null values for a given
column or expression, sometimes used in
conjunction with the DISTINCT clause.
Give this one a try later!
SUM COUNT
JOIN closure
Don't know?
, 4 of 174
Term
participants
Give this one a try later!
The level of detail An ER term for entities
represented by the values that participate in a
stored in a table's row. relationship.
A process based on Dealing with or related to
repetition of steps and sets, or groups of things.
procedures.
Don't know?
5 of 174
Term
cascading order sequence
Give this one a try later!
The second stage in the normalization process, in which a relation is in
1NF and there are no partial dependencies (dependencies in only
part of the primary key).
A nested ordering sequence for a set of rows, such as a list in
which all last names are alphabetically ordered and, within the last
names, all first names are ordered.
