WGU C170 - Data Management –
Applications (Latest Update)
Questions & Answers {Grade A} 100%
Correct
Cardinality - Correct answer Denotes how many instances of one object are related to
instances of another object (maximum).
Modality - Correct answer Denotes an instance of a specific entity is optional or
mandatory in a relationship (minimum).
Unary one-to-one - Correct answer A relationship between a single occurrence of an
entity type with another single occurrence of the same entity type
Unary one-to-many - Correct answer A relationship between a single occurrence of
an entity type with any number of occurrences (minimum one) of the same entity type.
Unary many-to-many - Correct answer A relationship between any occurrence of an
entity type with any number of occurrences (minimum one) of the same entity type.
,Index - Correct answer An ordered array of key values and row ID values (pointers).
They are generally used to speed up and facilitate data retrieval.
Unique index - Correct answer An index in which the index key can have only one
associated pointer value (row).
Flags - Correct answer Special codes implemented by designers to trigger a required
response, alert end users to specified conditions, or encode values. May be used to
prevent nulls by bringing attention to the absence of a value in a table.
Prime attribute - Correct answer An attribute that is part of a key or is the whole key.
Set theory - Correct answer A part of mathematical science that deals with sets, or
groups of things, and is used as the basis for data manipulation in the relational model.
Required attribute - Correct answer In ER modeling, an attribute that must have a
value. In other words, it cannot be left empty.
,Optional attribute - Correct answer In ER modeling, an attribute that does not require a
value; therefore, it can be left empty.
Identifiers - Correct answer The ERM uses one or more attributes that uniquely
identify each entity instance.
Relational schema - Correct answer The organization of a relational database as
described by the database administrator.
Composite identifier - Correct answer In ER modeling, a key composed of more than
one attribute.
Composite attribute - Correct answer An attribute that can be further subdivided to
yield additional attributes. For example, a phone number such as 615-898- 2368 may
be divided into an area code (615), an exchange number (898), and a four-digit code
(2368). Compare to simple attribute.
Single-valued attribute - Correct answer An attribute that can have only one value.
, Multivalued attribute - Correct answer An attribute that can have many values for a
single entity occurrence. For example, an EMP_DEGREE attribute might store the
string "BBA, MBA, PHD" to indicate three different degrees held.
Derived attribute - Correct answer An attribute that does not physically exist within
the entity and is computed via an algorithm.
Participants - Correct answer An ER term for entities that participate in a relationship.
Connectivity - Correct answer The classification of the relationship between entities.
Classifications include 1:1, 1:M, and M:N.
Existence-dependent - Correct answer A property of an entity whose existence
depends on one or more other entities.
Applications (Latest Update)
Questions & Answers {Grade A} 100%
Correct
Cardinality - Correct answer Denotes how many instances of one object are related to
instances of another object (maximum).
Modality - Correct answer Denotes an instance of a specific entity is optional or
mandatory in a relationship (minimum).
Unary one-to-one - Correct answer A relationship between a single occurrence of an
entity type with another single occurrence of the same entity type
Unary one-to-many - Correct answer A relationship between a single occurrence of
an entity type with any number of occurrences (minimum one) of the same entity type.
Unary many-to-many - Correct answer A relationship between any occurrence of an
entity type with any number of occurrences (minimum one) of the same entity type.
,Index - Correct answer An ordered array of key values and row ID values (pointers).
They are generally used to speed up and facilitate data retrieval.
Unique index - Correct answer An index in which the index key can have only one
associated pointer value (row).
Flags - Correct answer Special codes implemented by designers to trigger a required
response, alert end users to specified conditions, or encode values. May be used to
prevent nulls by bringing attention to the absence of a value in a table.
Prime attribute - Correct answer An attribute that is part of a key or is the whole key.
Set theory - Correct answer A part of mathematical science that deals with sets, or
groups of things, and is used as the basis for data manipulation in the relational model.
Required attribute - Correct answer In ER modeling, an attribute that must have a
value. In other words, it cannot be left empty.
,Optional attribute - Correct answer In ER modeling, an attribute that does not require a
value; therefore, it can be left empty.
Identifiers - Correct answer The ERM uses one or more attributes that uniquely
identify each entity instance.
Relational schema - Correct answer The organization of a relational database as
described by the database administrator.
Composite identifier - Correct answer In ER modeling, a key composed of more than
one attribute.
Composite attribute - Correct answer An attribute that can be further subdivided to
yield additional attributes. For example, a phone number such as 615-898- 2368 may
be divided into an area code (615), an exchange number (898), and a four-digit code
(2368). Compare to simple attribute.
Single-valued attribute - Correct answer An attribute that can have only one value.
, Multivalued attribute - Correct answer An attribute that can have many values for a
single entity occurrence. For example, an EMP_DEGREE attribute might store the
string "BBA, MBA, PHD" to indicate three different degrees held.
Derived attribute - Correct answer An attribute that does not physically exist within
the entity and is computed via an algorithm.
Participants - Correct answer An ER term for entities that participate in a relationship.
Connectivity - Correct answer The classification of the relationship between entities.
Classifications include 1:1, 1:M, and M:N.
Existence-dependent - Correct answer A property of an entity whose existence
depends on one or more other entities.
