DATA MANAGEMENT (C175) –
OFFICIAL-STYLE STUDY NOTECARDS
FOR WGU SUCCESS (2026/2027)
Cardinality - THE CORRECT ANSWER-The maximum number of
entities that can be involved in a particular relationship.
E-R Model
*E-R = Entity - Relationship - THE CORRECT ANSWER-Diagram of
entities together with their attributes and the relationship
among them.
Intersection Data - THE CORRECT ANSWER-It is data that describes a
many-to-many relationship.
Modality - THE CORRECT ANSWER-It is a minimum number of entity
occurrences that can be involved in a relationship.
One-to-one Binary Relationship - THE CORRECT ANSWER-It means
that a single occurrence of one entity type can be associated
with a single occurrence of the other entity type and vice versa.
Ternary Relationship - THE CORRECT ANSWER-Involves three
different entity types.
,Unique identifier - THE CORRECT ANSWER-It is used to uniquely
identify each record in a database table.
Attribute - THE CORRECT ANSWER-A property, characteristic, or fact
that we know about an entity.
"A salesperson works in one office."
What is the name of this relationship? - THE CORRECT ANSWER-One-
to-one binary relationship
"A salesperson sells to many customers."
What is the name of this relationship? - THE CORRECT ANSWER-One-
to-many binary relationship
"A salesperson is authorized to sell many products, and a
product can be sold by many salespersons."
What is the name of this relationship? - THE CORRECT ANSWER-
Many-to-many binary relationship
What is the positioning and meaning for Cardinality and
Modality on an E-R model? - THE CORRECT ANSWER-Cardinality is
the outer symbol; represents the maximum.
Modality is the inner symbol; represents the minimum.
, "A salesperson works in a minimum of one and a maximum of
one office, and an office may be occupied by or assigned to a
minimum of zero and a maximum of one salesperson." - THE
CORRECT ANSWER-
"A salesperson may have no customers or many customers." -
THE CORRECT ANSWER-
Describe the ER model for "Each salesperson is authorized to
sell to at least one or many products, and each product can be
sold by at least one or many salespeople." - THE CORRECT ANSWER-
"One salesperson backs-up another salesperson."
What is the name of this model? - THE CORRECT ANSWER-One-to-one
unary relationship
"A salesperson manages zero to many other salespersons, and a
salesperson is managed by exactly one other salesperson."
What is the name of this model? - THE CORRECT ANSWER-One-to-
many unary relationship
"A product can either be part of no other products or be part of
several other products, and a product can either be composed of
no other products or be composed of several other products."
OFFICIAL-STYLE STUDY NOTECARDS
FOR WGU SUCCESS (2026/2027)
Cardinality - THE CORRECT ANSWER-The maximum number of
entities that can be involved in a particular relationship.
E-R Model
*E-R = Entity - Relationship - THE CORRECT ANSWER-Diagram of
entities together with their attributes and the relationship
among them.
Intersection Data - THE CORRECT ANSWER-It is data that describes a
many-to-many relationship.
Modality - THE CORRECT ANSWER-It is a minimum number of entity
occurrences that can be involved in a relationship.
One-to-one Binary Relationship - THE CORRECT ANSWER-It means
that a single occurrence of one entity type can be associated
with a single occurrence of the other entity type and vice versa.
Ternary Relationship - THE CORRECT ANSWER-Involves three
different entity types.
,Unique identifier - THE CORRECT ANSWER-It is used to uniquely
identify each record in a database table.
Attribute - THE CORRECT ANSWER-A property, characteristic, or fact
that we know about an entity.
"A salesperson works in one office."
What is the name of this relationship? - THE CORRECT ANSWER-One-
to-one binary relationship
"A salesperson sells to many customers."
What is the name of this relationship? - THE CORRECT ANSWER-One-
to-many binary relationship
"A salesperson is authorized to sell many products, and a
product can be sold by many salespersons."
What is the name of this relationship? - THE CORRECT ANSWER-
Many-to-many binary relationship
What is the positioning and meaning for Cardinality and
Modality on an E-R model? - THE CORRECT ANSWER-Cardinality is
the outer symbol; represents the maximum.
Modality is the inner symbol; represents the minimum.
, "A salesperson works in a minimum of one and a maximum of
one office, and an office may be occupied by or assigned to a
minimum of zero and a maximum of one salesperson." - THE
CORRECT ANSWER-
"A salesperson may have no customers or many customers." -
THE CORRECT ANSWER-
Describe the ER model for "Each salesperson is authorized to
sell to at least one or many products, and each product can be
sold by at least one or many salespeople." - THE CORRECT ANSWER-
"One salesperson backs-up another salesperson."
What is the name of this model? - THE CORRECT ANSWER-One-to-one
unary relationship
"A salesperson manages zero to many other salespersons, and a
salesperson is managed by exactly one other salesperson."
What is the name of this model? - THE CORRECT ANSWER-One-to-
many unary relationship
"A product can either be part of no other products or be part of
several other products, and a product can either be composed of
no other products or be composed of several other products."
