1 of 28
WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM NEWEST 2025
ACTUAL EXAM 2 LATEST VERSIONS 3050 QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES (100% CORRECT AND VERIFIED ANSWERS)
|ALREADY GRADED A+
Data Storage Management - ......ANSWER........Functions performed by the DBMS to
guarantee integrity and consistency of the data in a database
Security Management - ......ANSWER........Functions performed by the DBMS to guarantee
integrity and consistency of the data in a database
Data Sharing - ......ANSWER........Enables sharing of data in a DBMS environment
Storage of Vast Volumes of Data - ......ANSWER........Increases effectiveness in working
with data in a DBMS environment
Improved Query Response Time - ......ANSWER........Advantage gained from using a
relational database management system to store customer information
Data Normalization - ......ANSWER........Method of organizing attributes into tables
Business Intelligence System - ......ANSWER........Expected to increase profitability,
throughput, and visibility while decreasing workloads and improving satisfaction
Relational Model - ......ANSWER........A database model based on mathematical principles
Domain - ......ANSWER........Set of values = 'Data Type'
Tuple - ......ANSWER........Finite sequence of values pulled from a fixed domain = 'Row'
Relation - ......ANSWER........A named set of tuples, all from the same domain = 'Table'
Attribute - ......ANSWER........A tuple position
Cardinality - ......ANSWER........Refers to the MAXIMUM number of times an instance in one
entity can be associated with an instance of another entity
,2 of 28
Unary Relationship - ......ANSWER........One entity involved in a relationship (one box, one
line)
Binary Relationship - ......ANSWER........Two entities involved in a relationship (two boxes
combined by one line)
Mandatory Entity - ......ANSWER........Depicted in an ER diagram with a single vertical line
through the relationship line
Mandatory - ......ANSWER........'M' shown on an entity in an ER diagram
Primary Identifier - ......ANSWER........'PI' shown on an entity in an ER diagram, used for
attribute(s) that uniquely identify the whole entity
Maxima and Minima - ......ANSWER........Depicted in an ER diagram as the first
letter/number shown (maxima) and the letter next to it in parentheses (minima)
Singular Attribute - ......ANSWER........Each entity instance has at most ONE attribute
instance
Plural Attribute - ......ANSWER........Each entity instance can have many attributes
instances
Unique Attribute - ......ANSWER........Each attribute instance describes only ONE entity
instance
Select Operation - ......ANSWER........Selects table rows based on logical expression (σ)
Project Operation - ......ANSWER........Selects Table Columns (II)
Join Operation - ......ANSWER........Joins two tables
Union Operation - ......ANSWER........Combines ALL rows of two compatible tables into a
single table (U)
, 3 of 28
Intersect Operation - ......ANSWER........Operates on two compatible tables and returns
only rows that appear in BOTH tables (∩)
Cardinality in ER Diagram - ......ANSWER........Appears as a 1 or M on the relationship line,
closest to the entity
One-To-Many Relationship - ......ANSWER........Describes the relationship where a pet
owner can have many pets, and a specific pet is linked to one pet owner
Entity Integrity Rule - ......ANSWER........Requires all primary keys to be unique
Two-Dimensional Structure - ......ANSWER........Perception of a table
Common Attribute - ......ANSWER........Defines how a table can be logically connected to
another table
Super key - ......ANSWER........An attribute (or group of attributes) that uniquely identifies
each entity in a table
Foreign Key - ......ANSWER........Must match a primary key in a related table
Entity Relationship Diagram (ERD) - ......ANSWER........Graphically represents the
conceptual database model
Derived Attribute - ......ANSWER........Need not be physically stored within the database
Atomic Attribute - ......ANSWER........An attribute that cannot be subdivided
Existence-Independent - ......ANSWER........An entity that can exist apart from one or more
related entities
Partial Dependencies - ......ANSWER........Dependencies based on only a part of a
composite key
WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM NEWEST 2025
ACTUAL EXAM 2 LATEST VERSIONS 3050 QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES (100% CORRECT AND VERIFIED ANSWERS)
|ALREADY GRADED A+
Data Storage Management - ......ANSWER........Functions performed by the DBMS to
guarantee integrity and consistency of the data in a database
Security Management - ......ANSWER........Functions performed by the DBMS to guarantee
integrity and consistency of the data in a database
Data Sharing - ......ANSWER........Enables sharing of data in a DBMS environment
Storage of Vast Volumes of Data - ......ANSWER........Increases effectiveness in working
with data in a DBMS environment
Improved Query Response Time - ......ANSWER........Advantage gained from using a
relational database management system to store customer information
Data Normalization - ......ANSWER........Method of organizing attributes into tables
Business Intelligence System - ......ANSWER........Expected to increase profitability,
throughput, and visibility while decreasing workloads and improving satisfaction
Relational Model - ......ANSWER........A database model based on mathematical principles
Domain - ......ANSWER........Set of values = 'Data Type'
Tuple - ......ANSWER........Finite sequence of values pulled from a fixed domain = 'Row'
Relation - ......ANSWER........A named set of tuples, all from the same domain = 'Table'
Attribute - ......ANSWER........A tuple position
Cardinality - ......ANSWER........Refers to the MAXIMUM number of times an instance in one
entity can be associated with an instance of another entity
,2 of 28
Unary Relationship - ......ANSWER........One entity involved in a relationship (one box, one
line)
Binary Relationship - ......ANSWER........Two entities involved in a relationship (two boxes
combined by one line)
Mandatory Entity - ......ANSWER........Depicted in an ER diagram with a single vertical line
through the relationship line
Mandatory - ......ANSWER........'M' shown on an entity in an ER diagram
Primary Identifier - ......ANSWER........'PI' shown on an entity in an ER diagram, used for
attribute(s) that uniquely identify the whole entity
Maxima and Minima - ......ANSWER........Depicted in an ER diagram as the first
letter/number shown (maxima) and the letter next to it in parentheses (minima)
Singular Attribute - ......ANSWER........Each entity instance has at most ONE attribute
instance
Plural Attribute - ......ANSWER........Each entity instance can have many attributes
instances
Unique Attribute - ......ANSWER........Each attribute instance describes only ONE entity
instance
Select Operation - ......ANSWER........Selects table rows based on logical expression (σ)
Project Operation - ......ANSWER........Selects Table Columns (II)
Join Operation - ......ANSWER........Joins two tables
Union Operation - ......ANSWER........Combines ALL rows of two compatible tables into a
single table (U)
, 3 of 28
Intersect Operation - ......ANSWER........Operates on two compatible tables and returns
only rows that appear in BOTH tables (∩)
Cardinality in ER Diagram - ......ANSWER........Appears as a 1 or M on the relationship line,
closest to the entity
One-To-Many Relationship - ......ANSWER........Describes the relationship where a pet
owner can have many pets, and a specific pet is linked to one pet owner
Entity Integrity Rule - ......ANSWER........Requires all primary keys to be unique
Two-Dimensional Structure - ......ANSWER........Perception of a table
Common Attribute - ......ANSWER........Defines how a table can be logically connected to
another table
Super key - ......ANSWER........An attribute (or group of attributes) that uniquely identifies
each entity in a table
Foreign Key - ......ANSWER........Must match a primary key in a related table
Entity Relationship Diagram (ERD) - ......ANSWER........Graphically represents the
conceptual database model
Derived Attribute - ......ANSWER........Need not be physically stored within the database
Atomic Attribute - ......ANSWER........An attribute that cannot be subdivided
Existence-Independent - ......ANSWER........An entity that can exist apart from one or more
related entities
Partial Dependencies - ......ANSWER........Dependencies based on only a part of a
composite key
