C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
1. The Entity-Relationship (E-R) model is . C
a) a diagramming technique that describes record
structures (i.e. the fields that make up the records of
a file)
b) an alternative to indexing and hashing as a means
for providing direct access in files
c) a diagramming technique that describes entities,
their attributes, and the relationships between them
d) an alternative to file design in which attributes are
used instead of fields
e) a diagramming technique that relates entities to
each other, attributes to each other, and relationships
to each other
2. An association between entities is a(n) . E
a) entity type
b) entity occurrence
c) record
d) attribute
e) relationship
3. A binary relationship is a relationship between two A
.
a) entity types
b) attribute types
c) associations
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
d) files
e) cardinalities
4. The term "binary" in binary relationship indicates that B
the relationship is between .
a) two halves of an entity type
b) two entity types
c) two divisions of an entity's attributes
d) two attributes
e) two relationships
5. The cardinality of a relationship is . B
a) The minimum number of entities that can be in-
volved in the relationship.
b) The maximum number of entities that can be in-
volved in the relationship.
c) The minimum number of attributes that can be in
the entity types in a relationship.
d) The maximum number of attributes that can be in
the entity types in a relationship.
e) The minimum number of associations that can be
involved in the relationship.
6. The modality of a relationship is . A
a) The minimum number of entities that can be in-
volved in the relationship.
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
b) The maximum number of entities that can be in-
volved in the relationship.
c) The minimum number of attributes that can be in
the entity types in a relationship.
d) The maximum number of attributes that can be in
the entity types in a relationship.
e) The minimum number of associations that can be
involved in the relationship.
7. A one-to-one binary relationship . B
a) involves a single entity type
b) involves two entity types
c) allows an occurrence of one entity type to be asso-
ciated with several occurrences of another entity type
d) allows an occurrence of one entity type to be asso-
ciated with several occurrences of another entity type
and vice versa
e) restricts the number of attributes that an entity has
8. A one-to-many binary relationship allows an occur- D
rence of the entity type on the "one side" of the rela-
tionship to be associated with .
a) a single occurrence of the same entity type
b) multiple occurrences of the same entity type
c) a single occurrence of the entity type on the "many
side" of the relationship
d) multiple occurrences of the entity type on the
"many side" of the relationship
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
e) multiple occurrences of the entity type on the "one
side" of the relationship
9. A many-to-many binary relationship allows an occur- D
rence of one entity type to be associated with .
a) a single occurrence of the same entity type
b) multiple occurrences of the same entity type
c) a single occurrence of another entity type
d) multiple occurrences of another entity type
10. A business school's faculty parking lot has assigned A
parking spaces. Each professor is entitled to one park-
ing space. This is an example of a relationship.
a) one-to-one binary
b) one-to-many binary
c) many-to-many binary
d) one-to-one unary
e) one-to-many unary
11. Each building on a university campus has several fac- B
ulty offices. Each professor has one office. The rela-
tionship between campus buildings and professors is
a relationship.
a) one-to-one binary
b) one-to-many binary
c) many-to-many binary
d) one-to-one unary
e) one-to-many unary
12. B
Exam Practice Guide 2026 Test
1. The Entity-Relationship (E-R) model is . C
a) a diagramming technique that describes record
structures (i.e. the fields that make up the records of
a file)
b) an alternative to indexing and hashing as a means
for providing direct access in files
c) a diagramming technique that describes entities,
their attributes, and the relationships between them
d) an alternative to file design in which attributes are
used instead of fields
e) a diagramming technique that relates entities to
each other, attributes to each other, and relationships
to each other
2. An association between entities is a(n) . E
a) entity type
b) entity occurrence
c) record
d) attribute
e) relationship
3. A binary relationship is a relationship between two A
.
a) entity types
b) attribute types
c) associations
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
d) files
e) cardinalities
4. The term "binary" in binary relationship indicates that B
the relationship is between .
a) two halves of an entity type
b) two entity types
c) two divisions of an entity's attributes
d) two attributes
e) two relationships
5. The cardinality of a relationship is . B
a) The minimum number of entities that can be in-
volved in the relationship.
b) The maximum number of entities that can be in-
volved in the relationship.
c) The minimum number of attributes that can be in
the entity types in a relationship.
d) The maximum number of attributes that can be in
the entity types in a relationship.
e) The minimum number of associations that can be
involved in the relationship.
6. The modality of a relationship is . A
a) The minimum number of entities that can be in-
volved in the relationship.
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
b) The maximum number of entities that can be in-
volved in the relationship.
c) The minimum number of attributes that can be in
the entity types in a relationship.
d) The maximum number of attributes that can be in
the entity types in a relationship.
e) The minimum number of associations that can be
involved in the relationship.
7. A one-to-one binary relationship . B
a) involves a single entity type
b) involves two entity types
c) allows an occurrence of one entity type to be asso-
ciated with several occurrences of another entity type
d) allows an occurrence of one entity type to be asso-
ciated with several occurrences of another entity type
and vice versa
e) restricts the number of attributes that an entity has
8. A one-to-many binary relationship allows an occur- D
rence of the entity type on the "one side" of the rela-
tionship to be associated with .
a) a single occurrence of the same entity type
b) multiple occurrences of the same entity type
c) a single occurrence of the entity type on the "many
side" of the relationship
d) multiple occurrences of the entity type on the
"many side" of the relationship
, C175 WGU Data Management Foundations
Exam Practice Guide 2026 Test
e) multiple occurrences of the entity type on the "one
side" of the relationship
9. A many-to-many binary relationship allows an occur- D
rence of one entity type to be associated with .
a) a single occurrence of the same entity type
b) multiple occurrences of the same entity type
c) a single occurrence of another entity type
d) multiple occurrences of another entity type
10. A business school's faculty parking lot has assigned A
parking spaces. Each professor is entitled to one park-
ing space. This is an example of a relationship.
a) one-to-one binary
b) one-to-many binary
c) many-to-many binary
d) one-to-one unary
e) one-to-many unary
11. Each building on a university campus has several fac- B
ulty offices. Each professor has one office. The rela-
tionship between campus buildings and professors is
a relationship.
a) one-to-one binary
b) one-to-many binary
c) many-to-many binary
d) one-to-one unary
e) one-to-many unary
12. B
