WGU C175/D426 Data Management Foundations
Final Exam Practice | 50 Questions | 2026/2027.
DOMAIN 1: Core Terminology, Data Models & Business Rules (10 Questions)
Question 1 — Multiple Choice
In relational database terminology, which of the following correctly identifies the components
of a relation?
A) A relation is a column, a tuple is a table, and an attribute is a row
B) A relation is a table, a tuple is a row of data, and an attribute is a column
C) A relation is a primary key, a tuple is a foreign key, and an attribute is an index
D) A relation is a schema, a tuple is a database, and an attribute is a constraint
[CORRECT: B]
Rationale: Per Codd's relational model (1970), a relation is formally defined as a two-
dimensional table structure. A tuple represents a single row (record) within that relation, and an
attribute represents a named column defining a specific property of the data. This terminology
is foundational to all relational database theory tested on the WGU OA.
Question 2 — Multiple Choice
A database administrator is designing a schema for a university registrar system. The Student
table contains columns: Student_ID, First_Name, Last_Name, Major, and GPA. Which term
describes Major in this context?
A) Tuple
B) Relation
C) Attribute
D) Domain
[CORRECT: C]
Rationale: Major is an attribute—a named column within the Student relation that describes a
specific characteristic of each student tuple. An attribute must have a defined domain (e.g.,
valid major codes), but the column itself is the attribute per relational algebra terminology.
,Question 3 — True/False
In a relational database, a tuple can contain duplicate values across all of its attributes
simultaneously.
A) True
B) False
[CORRECT: B]
Rationale: False. By definition, all tuples (rows) in a relation must be unique. The relational
model requires that no two tuples share identical values across all attributes simultaneously.
This uniqueness is typically enforced by a primary key constraint, which guarantees tuple
distinctness as a fundamental integrity rule.
Question 4 — Multiple Choice
A SaaS inventory management application needs to track products, warehouses, and stock
levels with complex many-to-many relationships and ad-hoc querying capabilities. Which data
model is most appropriate for this modern application?
A) Hierarchical model, because it provides fast parent-child traversal
B) Network model, because it supports many-to-many relationships through pointers
C) Relational model, because it provides data independence, set-based querying via SQL, and
flexible relationship representation
D) Object-oriented model exclusively, because it eliminates the need for normalization
[CORRECT: C]
Rationale: The relational model is the industry standard for modern SaaS applications because
it provides logical and physical data independence, supports ad-hoc querying through SQL (a
declarative, set-based language), and represents relationships through foreign keys rather than
physical pointers. While the hierarchical model excels at tree-structured data, it lacks the
flexibility for complex many-to-many queries without redundancy.
Question 5 — Select-All-That-Apply
Which of the following are characteristics that make the relational model superior to the
hierarchical model for a modern inventory SaaS application? (Select all that apply)
A) Data is organized in a strict parent-child tree structure with no cycles
B) Relationships are represented logically through foreign keys rather than physical pointers
, C) Users can query data without knowing the physical storage structure
D) The model requires predefined access paths for every possible query
[CORRECT: B, C]
Rationale: The relational model's core advantages are logical data independence (users query
via SQL without knowledge of physical storage—option C) and foreign key relationships that
exist at the logical level rather than as physical pointers (option B). Option A describes the
hierarchical model's limitation, and option D describes the network/hierarchical model's rigid
access path requirement, which the relational model specifically eliminates.
Question 6 — Multiple Choice
A business analyst documents the following rule: "A Customer may place zero, one, or many
Orders, but each Order must be associated with exactly one Customer." What type of business
rule is this, and what connectivity does it establish?
A) A structural constraint establishing a mandatory 1:1 relationship
B) A connectivity business rule establishing an optional 1:M relationship
C) A domain integrity rule establishing a referential constraint
D) A cardinality rule establishing an M:N relationship
[CORRECT: B]
Rationale: This is a connectivity business rule that establishes an optional one-to-many (1:M)
relationship. The phrase "may place zero, one, or many" indicates optionality on the parent side
(Customer), while "each Order must be associated with exactly one Customer" indicates
mandatory participation on the child side. Connectivity defines the classification of the
relationship (one-to-many), while cardinality defines the numeric range (0, 1, or many).
Question 7 — Multiple Choice
In an ERD for a retail system, the business rule states: "Each Invoice must contain at least one
Line_Item, and each Line_Item belongs to exactly one Invoice." What is the minimum cardinality
on the Invoice side of this relationship?
A) 0 (optional)
B) 1 (mandatory)
C) Many
D) Not specified by the business rule
Final Exam Practice | 50 Questions | 2026/2027.
DOMAIN 1: Core Terminology, Data Models & Business Rules (10 Questions)
Question 1 — Multiple Choice
In relational database terminology, which of the following correctly identifies the components
of a relation?
A) A relation is a column, a tuple is a table, and an attribute is a row
B) A relation is a table, a tuple is a row of data, and an attribute is a column
C) A relation is a primary key, a tuple is a foreign key, and an attribute is an index
D) A relation is a schema, a tuple is a database, and an attribute is a constraint
[CORRECT: B]
Rationale: Per Codd's relational model (1970), a relation is formally defined as a two-
dimensional table structure. A tuple represents a single row (record) within that relation, and an
attribute represents a named column defining a specific property of the data. This terminology
is foundational to all relational database theory tested on the WGU OA.
Question 2 — Multiple Choice
A database administrator is designing a schema for a university registrar system. The Student
table contains columns: Student_ID, First_Name, Last_Name, Major, and GPA. Which term
describes Major in this context?
A) Tuple
B) Relation
C) Attribute
D) Domain
[CORRECT: C]
Rationale: Major is an attribute—a named column within the Student relation that describes a
specific characteristic of each student tuple. An attribute must have a defined domain (e.g.,
valid major codes), but the column itself is the attribute per relational algebra terminology.
,Question 3 — True/False
In a relational database, a tuple can contain duplicate values across all of its attributes
simultaneously.
A) True
B) False
[CORRECT: B]
Rationale: False. By definition, all tuples (rows) in a relation must be unique. The relational
model requires that no two tuples share identical values across all attributes simultaneously.
This uniqueness is typically enforced by a primary key constraint, which guarantees tuple
distinctness as a fundamental integrity rule.
Question 4 — Multiple Choice
A SaaS inventory management application needs to track products, warehouses, and stock
levels with complex many-to-many relationships and ad-hoc querying capabilities. Which data
model is most appropriate for this modern application?
A) Hierarchical model, because it provides fast parent-child traversal
B) Network model, because it supports many-to-many relationships through pointers
C) Relational model, because it provides data independence, set-based querying via SQL, and
flexible relationship representation
D) Object-oriented model exclusively, because it eliminates the need for normalization
[CORRECT: C]
Rationale: The relational model is the industry standard for modern SaaS applications because
it provides logical and physical data independence, supports ad-hoc querying through SQL (a
declarative, set-based language), and represents relationships through foreign keys rather than
physical pointers. While the hierarchical model excels at tree-structured data, it lacks the
flexibility for complex many-to-many queries without redundancy.
Question 5 — Select-All-That-Apply
Which of the following are characteristics that make the relational model superior to the
hierarchical model for a modern inventory SaaS application? (Select all that apply)
A) Data is organized in a strict parent-child tree structure with no cycles
B) Relationships are represented logically through foreign keys rather than physical pointers
, C) Users can query data without knowing the physical storage structure
D) The model requires predefined access paths for every possible query
[CORRECT: B, C]
Rationale: The relational model's core advantages are logical data independence (users query
via SQL without knowledge of physical storage—option C) and foreign key relationships that
exist at the logical level rather than as physical pointers (option B). Option A describes the
hierarchical model's limitation, and option D describes the network/hierarchical model's rigid
access path requirement, which the relational model specifically eliminates.
Question 6 — Multiple Choice
A business analyst documents the following rule: "A Customer may place zero, one, or many
Orders, but each Order must be associated with exactly one Customer." What type of business
rule is this, and what connectivity does it establish?
A) A structural constraint establishing a mandatory 1:1 relationship
B) A connectivity business rule establishing an optional 1:M relationship
C) A domain integrity rule establishing a referential constraint
D) A cardinality rule establishing an M:N relationship
[CORRECT: B]
Rationale: This is a connectivity business rule that establishes an optional one-to-many (1:M)
relationship. The phrase "may place zero, one, or many" indicates optionality on the parent side
(Customer), while "each Order must be associated with exactly one Customer" indicates
mandatory participation on the child side. Connectivity defines the classification of the
relationship (one-to-many), while cardinality defines the numeric range (0, 1, or many).
Question 7 — Multiple Choice
In an ERD for a retail system, the business rule states: "Each Invoice must contain at least one
Line_Item, and each Line_Item belongs to exactly one Invoice." What is the minimum cardinality
on the Invoice side of this relationship?
A) 0 (optional)
B) 1 (mandatory)
C) Many
D) Not specified by the business rule
