WGU D426 - Data Management Foundations: Study Guide (V2)
Disclaimer: This guide is a synthesis of standard data management principles and
common WGU course objectives. Always refer to the official WGU course materials,
cohort videos, and syllabus as your primary sources. This is for illustrative study and
concept reinforcement.
Chapter 1: Data & Database Concepts
Q1: What is the primary purpose of a database?
ANSWER ✓ To provide an organized, persistent, and secure repository for structured
data that can be efficiently retrieved and managed by multiple users and applications.
Q2: Define "data redundancy" in a database context.
ANSWER ✓ Data redundancy occurs when the same piece of data is stored in multiple
places within a database, leading to potential inconsistencies, wasted storage, and
update anomalies.
Q3: What is the key difference between data and information?
ANSWER ✓ Data are raw, unorganized facts (e.g., the number 42). Information is data
that has been processed, organized, and contextualized to be meaningful and useful
(e.g., "42° Celsius is the patient's body temperature").
Q4: What is a Database Management System (DBMS)?
ANSWER ✓ A software application (e.g., MySQL, Oracle) that interacts with end-users,
applications, and the database itself to capture, analyze, and manage data. It provides
controlled access and administrative operations.
Q5: List three advantages of using a DBMS over file-based systems.
ANSWER ✓ 1. Reduced data redundancy. 2. Improved data integrity and consistency. 3.
Enhanced security and controlled access. 4. Concurrent access and crash recovery. 5.
Data abstraction and independence.
Q6: What is the role of metadata?
ANSWER ✓ Metadata is "data about data." It describes the structure, constraints, type,
and relationships of data elements within the database (e.g., the schema).
, Q7: What is a data anomaly? Name one type.
ANSWER ✓ A data anomaly is an inconsistency or error in the data, often caused by
redundancy. An update anomaly occurs when changing data in one location requires
the same change in multiple locations, risking inconsistency.
Chapter 2: Relational Model & Terminology
Q8: In the relational model, what is a relation?
ANSWER ✓ A relation is a two-dimensional table with rows (tuples) and columns
(attributes). It must have distinct rows and single-valued, atomic attributes.
Q9: What is a tuple?
ANSWER ✓ A tuple is a single, horizontal row in a relation (table), representing a unique
instance or record of the entity.
Q10: What is an attribute?
ANSWER ✓ An attribute is a named vertical column in a relation, representing a
characteristic or property of the entity (e.g., CustomerID, LastName).
Q11: What is a domain in the context of an attribute?
ANSWER ✓ The domain defines the set of all possible valid values for an attribute (e.g.,
the domain for a "Grade" attribute might be {'A', 'B', 'C', 'D', 'F'}).
Q12: What is a candidate key?
ANSWER ✓ A candidate key is a minimal set of one or more attributes that uniquely
identifies each tuple in a relation. A relation can have multiple candidate keys.
Q13: What is the primary key (PK)?
ANSWER ✓ The primary key is the candidate key selected by the database designer to
be the primary means of uniquely identifying tuples within a relation. It must contain
unique and non-NULL values.
Q14: What is a foreign key (FK)?
ANSWER ✓ A foreign key is an attribute (or set of attributes) in one relation that
references the primary key of another relation. It establishes and enforces a logical link
between the data in the two tables.
Disclaimer: This guide is a synthesis of standard data management principles and
common WGU course objectives. Always refer to the official WGU course materials,
cohort videos, and syllabus as your primary sources. This is for illustrative study and
concept reinforcement.
Chapter 1: Data & Database Concepts
Q1: What is the primary purpose of a database?
ANSWER ✓ To provide an organized, persistent, and secure repository for structured
data that can be efficiently retrieved and managed by multiple users and applications.
Q2: Define "data redundancy" in a database context.
ANSWER ✓ Data redundancy occurs when the same piece of data is stored in multiple
places within a database, leading to potential inconsistencies, wasted storage, and
update anomalies.
Q3: What is the key difference between data and information?
ANSWER ✓ Data are raw, unorganized facts (e.g., the number 42). Information is data
that has been processed, organized, and contextualized to be meaningful and useful
(e.g., "42° Celsius is the patient's body temperature").
Q4: What is a Database Management System (DBMS)?
ANSWER ✓ A software application (e.g., MySQL, Oracle) that interacts with end-users,
applications, and the database itself to capture, analyze, and manage data. It provides
controlled access and administrative operations.
Q5: List three advantages of using a DBMS over file-based systems.
ANSWER ✓ 1. Reduced data redundancy. 2. Improved data integrity and consistency. 3.
Enhanced security and controlled access. 4. Concurrent access and crash recovery. 5.
Data abstraction and independence.
Q6: What is the role of metadata?
ANSWER ✓ Metadata is "data about data." It describes the structure, constraints, type,
and relationships of data elements within the database (e.g., the schema).
, Q7: What is a data anomaly? Name one type.
ANSWER ✓ A data anomaly is an inconsistency or error in the data, often caused by
redundancy. An update anomaly occurs when changing data in one location requires
the same change in multiple locations, risking inconsistency.
Chapter 2: Relational Model & Terminology
Q8: In the relational model, what is a relation?
ANSWER ✓ A relation is a two-dimensional table with rows (tuples) and columns
(attributes). It must have distinct rows and single-valued, atomic attributes.
Q9: What is a tuple?
ANSWER ✓ A tuple is a single, horizontal row in a relation (table), representing a unique
instance or record of the entity.
Q10: What is an attribute?
ANSWER ✓ An attribute is a named vertical column in a relation, representing a
characteristic or property of the entity (e.g., CustomerID, LastName).
Q11: What is a domain in the context of an attribute?
ANSWER ✓ The domain defines the set of all possible valid values for an attribute (e.g.,
the domain for a "Grade" attribute might be {'A', 'B', 'C', 'D', 'F'}).
Q12: What is a candidate key?
ANSWER ✓ A candidate key is a minimal set of one or more attributes that uniquely
identifies each tuple in a relation. A relation can have multiple candidate keys.
Q13: What is the primary key (PK)?
ANSWER ✓ The primary key is the candidate key selected by the database designer to
be the primary means of uniquely identifying tuples within a relation. It must contain
unique and non-NULL values.
Q14: What is a foreign key (FK)?
ANSWER ✓ A foreign key is an attribute (or set of attributes) in one relation that
references the primary key of another relation. It establishes and enforces a logical link
between the data in the two tables.
