WGU C175 2026/2027 Study
Notecards Fully Set Exam For
Guaranteed Pass
Flat Files -- Verified--Solution----a file having no internal hierarchy
Hashed Files -- Verified--Solution----A file that has been encrypted for
security purposes.
Heap File -- Verified--Solution----An unsorted set of records.
Information -- Verified--Solution----The transformation of raw data into
useful facts.
Punch Card -- Verified--Solution----A card that is perforated and can
hold commands or data.
Structured Data -- Verified--Solution----Information with a high degree
of organization.
Unstructured Data -- Verified--Solution----Information that does not
have structure (such as text)
,2 | Page
Binary Relationship -- Verified--Solution----A relationship between two
entity types.
Unary Relationship -- Verified--Solution----An associate occurrence of
an entity type with other occurrences of the same entity type.
Cardinality -- Verified--Solution----The maximum number of entities
that can be involved in a particular relationship.
E-R Model
*E-R = Entity - Relationship -- Verified--Solution----Diagram of entities
together with their attributes and the relationship among them.
Intersection Data -- Verified--Solution----It is data that describes a
many-to-many relationship.
Modality -- Verified--Solution----It is a minimum number of entity
occurrences that can be involved in a relationship.
One-to-one Binary Relationship -- Verified--Solution----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.
, 3 | Page
Ternary Relationship -- Verified--Solution----Involves three different
entity types.
Unique identifier -- Verified--Solution----It is used to uniquely identify
each record in a database table.
Attribute -- Verified--Solution----A property, characteristic, or fact that
we know about an entity.
"A salesperson works in one office."
What is the name of this relationship? -- Verified--Solution----One-to-
one binary relationship
"A salesperson sells to many customers."
What is the name of this relationship? -- Verified--Solution----One-to-
many binary relationship
"A salesperson is authorized to sell many products, and a product can be
sold by many salespersons."