WGU C170 Data Management
Applications 2025/2026 Exam All
Answers and Illustrations Given
domain - 🧠ANSWER ✔✔In data modeling, the construct used to organize and
describe an attribute's set of possible values
superkey - 🧠ANSWER ✔✔An attribute or attributes that uniquely identify each
entity in a table. Any composite key with this is also this.
candidate key - 🧠ANSWER ✔✔A minimal superkey; that is, a key that does not
contain a subset of attributes that is itself a superkey
entity integrity - 🧠ANSWER ✔✔The property of a relational table that guarantees
each entity has a unique value in a primary key and that the key has no null values
referential integrity - 🧠ANSWER ✔✔A condition by which a dependent table's
foreign key must have either a null entry or a matching entry in the related table
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
data dictionary - 🧠ANSWER ✔✔A DBMS component that stores metadata. It
contains the data definition & their characteristics and relationships; may also
include data external to the DBMS
system catalog - 🧠ANSWER ✔✔A detailed system data dictionary that describes
all objects in a database
homonym - 🧠ANSWER ✔✔The use of the same name to label different attributes,
much like similar-sounding words with different meanings
synonym - 🧠ANSWER ✔✔The use of different names to identify the same object,
such as an entity, an attribute, or a relationship. These should generally be avoided.
not null and unique - 🧠ANSWER ✔✔Any candidate key must have these two
constraints enforced
cardinality - 🧠ANSWER ✔✔Term for how many instances of one object are
related to instances of another object (maximum)
modality - 🧠ANSWER ✔✔Term for whether an instance of a specific entity is
optional or mandatory in a relationship (minimum)
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED