WGU C175/D426 Data Management
Exam Review 2025 Complete
Questions And Verified Answers/
Complete Solutions With Rationales
|Get It 100% Accurate!! Already
graded A+
Save
Terms in this set (348)
Refers to the MINIMUM number of
times an instance in one entity can be
associated with instance of another
Modality
entity (minima). Appears as a 0 or 1 on
the relationship line, next to
cardinality.
, Requires that ALL foreign key values
Referential
must either be fully NULL or match
Integrity
some primary key value.
1. Primary key is updated 2. Foreign
Ways Referential
key is updated 3. Row containing
Integrity can be
primary key is DELETED 4. Row
violated
containing foreign key is INSERTED.
1. RESTRICT - rejects an insert, update,
or delete 2. SET NULL - sets invalid
Actions to
foreign keys to null 3. SET DEFAULT -
Correct
sets invalid foreign keys to a default
Referential
primary value 4. CASCADE -
Integrity Violation
propagates primary key changes to
foreign keys.
Important aspect Reference to data in one relation is
of Referential based on values in another relation.
Integrity
Broad definition Raw facts captured on printed or
of data digital media.
Facts that are collected and stored in
Data
a database system.
Determining It does not follow a data model.
characteristic of
unstructured data
Exam Review 2025 Complete
Questions And Verified Answers/
Complete Solutions With Rationales
|Get It 100% Accurate!! Already
graded A+
Save
Terms in this set (348)
Refers to the MINIMUM number of
times an instance in one entity can be
associated with instance of another
Modality
entity (minima). Appears as a 0 or 1 on
the relationship line, next to
cardinality.
, Requires that ALL foreign key values
Referential
must either be fully NULL or match
Integrity
some primary key value.
1. Primary key is updated 2. Foreign
Ways Referential
key is updated 3. Row containing
Integrity can be
primary key is DELETED 4. Row
violated
containing foreign key is INSERTED.
1. RESTRICT - rejects an insert, update,
or delete 2. SET NULL - sets invalid
Actions to
foreign keys to null 3. SET DEFAULT -
Correct
sets invalid foreign keys to a default
Referential
primary value 4. CASCADE -
Integrity Violation
propagates primary key changes to
foreign keys.
Important aspect Reference to data in one relation is
of Referential based on values in another relation.
Integrity
Broad definition Raw facts captured on printed or
of data digital media.
Facts that are collected and stored in
Data
a database system.
Determining It does not follow a data model.
characteristic of
unstructured data
