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