WGU C170 DATA MANAGEMENT
APPLICATIONS QUESTION BANK 2026
◉ system catalog. Answer: A detailed system data dictionary that
describes all objects in a database.
◉ theta join. Answer: A join operator that links tables using an
inequality comparison operator (<, >, <=, >=) in the join condition.
◉ UNION. Answer: In relational algebra, an operator used to merge
(append) two tables into a new table, dropping the duplicate rows.
The tables must be union-compatible.
◉ union-compatible. Answer: Two or more tables that have the
same number of columns and the corresponding columns have
compatible domains.
◉ unique index. Answer: An index in which the index key can have
only one associated pointer value (row).
◉ binary relationship. Answer: An ER term for an association
(relationship) between two entities.
,◉ cardinality. Answer: A property that assigns a specific value to
connectivity and expresses the range of allowed entity occurrences
associated with a single occurrence of the related entity.
◉ composite attribute. Answer: An attribute that can be further
subdivided to yield additional attributes.
◉ composite identifier. Answer: In ER modeling, a key composed of
more than one attribute.
◉ derived attribute. Answer: An attribute that does not physically
exist within the entity and is calculated.
◉ existence-dependent. Answer: A property of an entity whose
existence depends on one or more other entities. In such an
environment, the existence-independent table must be created and
loaded first because the existence-dependent key cannot reference a
table that does not yet exist.
◉ existence-independent. Answer: A property of an entity that can
exist apart from one or more related entities. Such a table must be
created first when referencing an existence-dependent table.
◉ identifiers. Answer: One or more attributes that uniquely identify
each entity instance.
, ◉ iterative process. Answer: A process based on repetition of steps
and procedures.
◉ mandatory participation. Answer: A relationship in which one
entity occurrence must have a corresponding occurrence in another
entity.
◉ multivalued attributes. Answer: An attribute that can have many
values for a single entity occurrence.
◉ non-identifying relationship. Answer: A relationship in which the
primary key of the related entity does not contain a primary key
component of the parent entity.
◉ optional attribute. Answer: In ER modeling, an attribute that does
not require a value; therefore, it can be left empty.
◉ optional participation. Answer: In ER modeling, a condition in
which one entity occurrence does not require a corresponding entity
occurrence in a particular relationship.
◉ participants. Answer: An ER term for entities that participate in a
relationship.
APPLICATIONS QUESTION BANK 2026
◉ system catalog. Answer: A detailed system data dictionary that
describes all objects in a database.
◉ theta join. Answer: A join operator that links tables using an
inequality comparison operator (<, >, <=, >=) in the join condition.
◉ UNION. Answer: In relational algebra, an operator used to merge
(append) two tables into a new table, dropping the duplicate rows.
The tables must be union-compatible.
◉ union-compatible. Answer: Two or more tables that have the
same number of columns and the corresponding columns have
compatible domains.
◉ unique index. Answer: An index in which the index key can have
only one associated pointer value (row).
◉ binary relationship. Answer: An ER term for an association
(relationship) between two entities.
,◉ cardinality. Answer: A property that assigns a specific value to
connectivity and expresses the range of allowed entity occurrences
associated with a single occurrence of the related entity.
◉ composite attribute. Answer: An attribute that can be further
subdivided to yield additional attributes.
◉ composite identifier. Answer: In ER modeling, a key composed of
more than one attribute.
◉ derived attribute. Answer: An attribute that does not physically
exist within the entity and is calculated.
◉ existence-dependent. Answer: A property of an entity whose
existence depends on one or more other entities. In such an
environment, the existence-independent table must be created and
loaded first because the existence-dependent key cannot reference a
table that does not yet exist.
◉ existence-independent. Answer: A property of an entity that can
exist apart from one or more related entities. Such a table must be
created first when referencing an existence-dependent table.
◉ identifiers. Answer: One or more attributes that uniquely identify
each entity instance.
, ◉ iterative process. Answer: A process based on repetition of steps
and procedures.
◉ mandatory participation. Answer: A relationship in which one
entity occurrence must have a corresponding occurrence in another
entity.
◉ multivalued attributes. Answer: An attribute that can have many
values for a single entity occurrence.
◉ non-identifying relationship. Answer: A relationship in which the
primary key of the related entity does not contain a primary key
component of the parent entity.
◉ optional attribute. Answer: In ER modeling, an attribute that does
not require a value; therefore, it can be left empty.
◉ optional participation. Answer: In ER modeling, a condition in
which one entity occurrence does not require a corresponding entity
occurrence in a particular relationship.
◉ participants. Answer: An ER term for entities that participate in a
relationship.
