WGU C175 Study Notecards
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
1. Flat Files a file having no internal hi-
erarchy
2. Hashed Files A file that has been en-
crypted for security pur-
poses.
3. Heap File An unsorted set of
records.
4. Information The transformation of raw
data into useful facts.
5. Punch Card A card that is perforated
and can hold commands
or data.
6. Structured Data Information with a high
degree of organization.
7. Unstructured Data Information that does not
have structure (such as
text)
8. Binary Relationship A relationship between
two entity types.
9. Unary Relationship An associate occurrence of
an entity type with other
occurrences of the same
entity type.
10. Cardinality The maximum number of
entities that can be in-
, WGU C175 Study Notecards
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
volved in a particular rela-
tionship.
11. E-R Model Diagram of entities to-
gether with their attrib-
*E-R = Entity - Relationship utes and the relationship
among them.
12. Intersection Data It is data that describes
a many-to-many relation-
ship.
13. Modality It is a minimum number of
entity occurrences that can
be involved in a relation-
ship.
14. One-to-one Binary Relationship It means that a single oc-
currence of one entity type
can be associated with a
single occurrence of the
other entity type and vice
versa.
15. Ternary Relationship Involves three different
entity types.
16. Unique identifier It is used to uniquely iden-
tify each record in a data-
base table.
17. Attribute
, WGU C175 Study Notecards
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
A property, characteristic,
or fact that we know about
an entity.
18. "A salesperson works in one office." One-to-one binary rela-
tionship
What is the name of this relationship?
19. "A salesperson sells to many customers." One-to-many binary rela-
tionship
What is the name of this relationship?
20. "A salesperson is authorized to sell many products, Many-to-many binary re-
and a product can be sold by many salespersons." lationship
What is the name of this relationship?
21. What is the positioning and meaning for Cardinality Cardinality is the out-
and Modality on an E-R model? er symbol; represents the
maximum.
Modality is the inner sym-
bol; represents the mini-
mum.
22. "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."
23. "A salesperson may have no customers or many cus-
tomers."
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
1. Flat Files a file having no internal hi-
erarchy
2. Hashed Files A file that has been en-
crypted for security pur-
poses.
3. Heap File An unsorted set of
records.
4. Information The transformation of raw
data into useful facts.
5. Punch Card A card that is perforated
and can hold commands
or data.
6. Structured Data Information with a high
degree of organization.
7. Unstructured Data Information that does not
have structure (such as
text)
8. Binary Relationship A relationship between
two entity types.
9. Unary Relationship An associate occurrence of
an entity type with other
occurrences of the same
entity type.
10. Cardinality The maximum number of
entities that can be in-
, WGU C175 Study Notecards
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
volved in a particular rela-
tionship.
11. E-R Model Diagram of entities to-
gether with their attrib-
*E-R = Entity - Relationship utes and the relationship
among them.
12. Intersection Data It is data that describes
a many-to-many relation-
ship.
13. Modality It is a minimum number of
entity occurrences that can
be involved in a relation-
ship.
14. One-to-one Binary Relationship It means that a single oc-
currence of one entity type
can be associated with a
single occurrence of the
other entity type and vice
versa.
15. Ternary Relationship Involves three different
entity types.
16. Unique identifier It is used to uniquely iden-
tify each record in a data-
base table.
17. Attribute
, WGU C175 Study Notecards
WGU C175 Study Notecards
Study online at https://quizlet.com/_4en0lz
A property, characteristic,
or fact that we know about
an entity.
18. "A salesperson works in one office." One-to-one binary rela-
tionship
What is the name of this relationship?
19. "A salesperson sells to many customers." One-to-many binary rela-
tionship
What is the name of this relationship?
20. "A salesperson is authorized to sell many products, Many-to-many binary re-
and a product can be sold by many salespersons." lationship
What is the name of this relationship?
21. What is the positioning and meaning for Cardinality Cardinality is the out-
and Modality on an E-R model? er symbol; represents the
maximum.
Modality is the inner sym-
bol; represents the mini-
mum.
22. "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."
23. "A salesperson may have no customers or many cus-
tomers."
