WGU C175 Study NotecardS- ACTUAL EXAM
NEWEST VERSION 2025/2026 QUESTION AND
CORRECT DETAILED VERIFIED ANSWERS FROM
VERIFIED SOURCES RATED A GRADE.
Save
Terms in this set (123)
Flat Files a file having no internal hierarchy
Hashed Files A file that has been encrypted for security purposes.
Heap File An unsorted set of records.
Information The transformation of raw data into useful facts.
A card that is perforated and can hold commands or
Punch Card
data.
Structured Data Information with a high degree of organization.
Unstructured Data Information that does not have structure (such as text)
Binary Relationship A relationship between two entity types.
An associate occurrence of an entity type with other
Unary Relationship
occurrences of the same entity type.
The maximum number of entities that can be involved
Cardinality
in a particular relationship.
E-R Model Diagram of entities together with their attributes and
the relationship among them.
*E-R = Entity - Relationship
Intersection Data It is data that describes a many-to-many relationship.
, It is a minimum number of entity occurrences that can
Modality
be involved in a relationship.
It means that a single occurrence of one entity type
One-to-one Binary
can be associated with a single occurrence of the
Relationship
other entity type and vice versa.
Ternary Relationship Involves three different entity types.
It is used to uniquely identify each record in a
Unique identifier
database table.
A property, characteristic, or fact that we know about
Attribute
an entity.
"A salesperson works in One-to-one binary relationship
one office."
What is the name of this
relationship?
"A salesperson sells to One-to-many binary
many customers." relationship
What is the name of this
relationship?
"A salesperson is Many-to-many binary
authorized to sell many relationship
products, and a product
can be sold by many
salespersons."
What is the name of this
relationship?
What is the positioning Cardinality is the outer symbol; represents the
and meaning for maximum.
Cardinality and Modality
on an E-R model? 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."
"A salesperson may have
no customers or many
customers."
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."
"One salesperson backs- One-to-one unary relationship
up another salesperson."
What is the name of this
model?
"A salesperson manages One-to-many unary relationship
zero to many other
salespersons, and a
salesperson is managed
by exactly one other
salesperson."
What is the name of this
model?
NEWEST VERSION 2025/2026 QUESTION AND
CORRECT DETAILED VERIFIED ANSWERS FROM
VERIFIED SOURCES RATED A GRADE.
Save
Terms in this set (123)
Flat Files a file having no internal hierarchy
Hashed Files A file that has been encrypted for security purposes.
Heap File An unsorted set of records.
Information The transformation of raw data into useful facts.
A card that is perforated and can hold commands or
Punch Card
data.
Structured Data Information with a high degree of organization.
Unstructured Data Information that does not have structure (such as text)
Binary Relationship A relationship between two entity types.
An associate occurrence of an entity type with other
Unary Relationship
occurrences of the same entity type.
The maximum number of entities that can be involved
Cardinality
in a particular relationship.
E-R Model Diagram of entities together with their attributes and
the relationship among them.
*E-R = Entity - Relationship
Intersection Data It is data that describes a many-to-many relationship.
, It is a minimum number of entity occurrences that can
Modality
be involved in a relationship.
It means that a single occurrence of one entity type
One-to-one Binary
can be associated with a single occurrence of the
Relationship
other entity type and vice versa.
Ternary Relationship Involves three different entity types.
It is used to uniquely identify each record in a
Unique identifier
database table.
A property, characteristic, or fact that we know about
Attribute
an entity.
"A salesperson works in One-to-one binary relationship
one office."
What is the name of this
relationship?
"A salesperson sells to One-to-many binary
many customers." relationship
What is the name of this
relationship?
"A salesperson is Many-to-many binary
authorized to sell many relationship
products, and a product
can be sold by many
salespersons."
What is the name of this
relationship?
What is the positioning Cardinality is the outer symbol; represents the
and meaning for maximum.
Cardinality and Modality
on an E-R model? 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."
"A salesperson may have
no customers or many
customers."
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."
"One salesperson backs- One-to-one unary relationship
up another salesperson."
What is the name of this
model?
"A salesperson manages One-to-many unary relationship
zero to many other
salespersons, and a
salesperson is managed
by exactly one other
salesperson."
What is the name of this
model?