WGU C170 DATA MANAGEMENT
APPLICATIONS PRACTICE EXAM 2026
◉ 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.
◉ derived attribute. Answer: An attribute that does not physically
exist within the entity and is derived via an algorithm.
◉ existence-dependent. Answer: A property of an entity whose
existence depends on one or more other entities.
◉ 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 attribute. 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.
, ◉ recursive relationship. Answer: A relationship found within a
single entity type. For example, an EMPLOYEE is married to an
EMPLOYEE or a PART is a component of another PART.
◉ regular entity. Answer: See strong entity.
◉ relational schema. Answer: The organization of a relational
database as described by the database administrator.
◉ relationship degree. Answer: The number of entities or
participants associated with a relationship. A relationship degree
can be unary, binary, ternary, or higher.
◉ required attribute. Answer: In ER modeling, an attribute that must
have a value. In other words, it cannot be left empty.
◉ simple attribute. Answer: An attribute that cannot be subdivided
into meaningful components. Compare to composite attribute.
◉ single-valued attribute. Answer: An attribute that can have only
one value.
◉ strong (identifying) relationship. Answer: A relationship that
occurs when two entities are existence-dependent; from a database
APPLICATIONS PRACTICE EXAM 2026
◉ 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.
◉ derived attribute. Answer: An attribute that does not physically
exist within the entity and is derived via an algorithm.
◉ existence-dependent. Answer: A property of an entity whose
existence depends on one or more other entities.
◉ 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 attribute. 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.
, ◉ recursive relationship. Answer: A relationship found within a
single entity type. For example, an EMPLOYEE is married to an
EMPLOYEE or a PART is a component of another PART.
◉ regular entity. Answer: See strong entity.
◉ relational schema. Answer: The organization of a relational
database as described by the database administrator.
◉ relationship degree. Answer: The number of entities or
participants associated with a relationship. A relationship degree
can be unary, binary, ternary, or higher.
◉ required attribute. Answer: In ER modeling, an attribute that must
have a value. In other words, it cannot be left empty.
◉ simple attribute. Answer: An attribute that cannot be subdivided
into meaningful components. Compare to composite attribute.
◉ single-valued attribute. Answer: An attribute that can have only
one value.
◉ strong (identifying) relationship. Answer: A relationship that
occurs when two entities are existence-dependent; from a database
