WGU C175/D426 Data Management
Exam Review 2025| COMPLETE
EXAM SET (questions and verified
answers)frequently most tested
questions | already passed!!
Save
Terms in this set (348)
Refers to the MINIMUM number of
times an instance in one entity can
be associated with instance of
Modality
another 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,
Actions to update, or delete 2. SET NULL - sets
Correct invalid foreign keys to null 3. SET
Referential DEFAULT - sets invalid foreign keys
Integrity to a default primary value 4.
Violation CASCADE - propagates primary key
changes to foreign keys.
Important Reference to data in one relation is
aspect of based on values in another relation.
Referential
Integrity
Broad definition Raw facts captured on printed or
of data digital media.
Facts that are collected and stored
Data
in a database system.
Exam Review 2025| COMPLETE
EXAM SET (questions and verified
answers)frequently most tested
questions | already passed!!
Save
Terms in this set (348)
Refers to the MINIMUM number of
times an instance in one entity can
be associated with instance of
Modality
another 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,
Actions to update, or delete 2. SET NULL - sets
Correct invalid foreign keys to null 3. SET
Referential DEFAULT - sets invalid foreign keys
Integrity to a default primary value 4.
Violation CASCADE - propagates primary key
changes to foreign keys.
Important Reference to data in one relation is
aspect of based on values in another relation.
Referential
Integrity
Broad definition Raw facts captured on printed or
of data digital media.
Facts that are collected and stored
Data
in a database system.