WGU C175 Exam Questions and Answers
Graded A+
Flat Files - Correct answer-a file having no internal hierarchy
Hashed Files - Correct answer-A file that has been encrypted for security purposes.
Heap File - Correct answer-An unsorted set of records.
Information - Correct answer-The transformation of raw data into useful facts.
Punch Card - Correct answer-A card that is perforated and can hold commands or
data.
Structured Data - Correct answer-Information with a high degree of organization.
Unstructured Data - Correct answer-Information that does not have structure (such
as text)
Binary Relationship - Correct answer-A relationship between two entity types.
Unary Relationship - Correct answer-An associate occurrence of an entity type
with other occurrences of the same entity type.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
,Cardinality - Correct answer-The maximum number of entities that can be
involved in a particular relationship.
E-R Model
*E-R = Entity - Relationship - Correct answer-Diagram of entities together with
their attributes and the relationship among them.
Intersection Data - Correct answer-It is data that describes a many-to-many
relationship.
Modality - Correct answer-It is a minimum number of entity occurrences that can
be involved in a relationship.
One-to-one Binary Relationship - 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 - Correct answer-Involves three different entity types.
Unique identifier - Correct answer-It is used to uniquely identify each record in a
database table.
Attribute - Correct answer-A property, characteristic, or fact that we know about an
entity.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
, "A salesperson works in one office."
What is the name of this relationship? - Correct answer-One-to-one binary
relationship
"A salesperson sells to many customers."
What is the name of this relationship? - 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? - Correct answer-Many-to-many binary
relationship
What is the positioning and meaning for Cardinality and Modality on an E-R
model? - Correct answer-Cardinality is the outer symbol; represents the maximum.
Modality is the inner symbol; represents the minimum.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 3
Graded A+
Flat Files - Correct answer-a file having no internal hierarchy
Hashed Files - Correct answer-A file that has been encrypted for security purposes.
Heap File - Correct answer-An unsorted set of records.
Information - Correct answer-The transformation of raw data into useful facts.
Punch Card - Correct answer-A card that is perforated and can hold commands or
data.
Structured Data - Correct answer-Information with a high degree of organization.
Unstructured Data - Correct answer-Information that does not have structure (such
as text)
Binary Relationship - Correct answer-A relationship between two entity types.
Unary Relationship - Correct answer-An associate occurrence of an entity type
with other occurrences of the same entity type.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
,Cardinality - Correct answer-The maximum number of entities that can be
involved in a particular relationship.
E-R Model
*E-R = Entity - Relationship - Correct answer-Diagram of entities together with
their attributes and the relationship among them.
Intersection Data - Correct answer-It is data that describes a many-to-many
relationship.
Modality - Correct answer-It is a minimum number of entity occurrences that can
be involved in a relationship.
One-to-one Binary Relationship - 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 - Correct answer-Involves three different entity types.
Unique identifier - Correct answer-It is used to uniquely identify each record in a
database table.
Attribute - Correct answer-A property, characteristic, or fact that we know about an
entity.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
, "A salesperson works in one office."
What is the name of this relationship? - Correct answer-One-to-one binary
relationship
"A salesperson sells to many customers."
What is the name of this relationship? - 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? - Correct answer-Many-to-many binary
relationship
What is the positioning and meaning for Cardinality and Modality on an E-R
model? - Correct answer-Cardinality is the outer symbol; represents the maximum.
Modality is the inner symbol; represents the minimum.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 3
