WGU C175 Study Notecards
Flat Files - ANSWER -a file having no particular relationship.
internal hierarchy
E-R Model
Hashed Files - ANSWER -A file that has
been encrypted for security purposes. *E-R = Entity - Relationship - ANSWER -
Diagram of entities together with their
attributes and the relationship among them.
Heap File - ANSWER -An unsorted set
of records.
Intersection Data - ANSWER -It is data
that describes a many-to-many relationship.
Information - ANSWER -The
transformation of raw data into useful facts.
Modality - ANSWER -It is a minimum
number of entity occurrences that can be
Punch Card - ANSWER -A card that is involved in a relationship.
perforated and can hold commands or data.
One-to-one Binary Relationship -
Structured Data - ANSWER - ANSWER -It means that a single
Information with a high degree of occurrence of one entity type can be
organization. associated with a single occurrence of the
other entity type and vice versa.
Unstructured Data - ANSWER -
Information that does not have structure Ternary Relationship - ANSWER -
(such as text) Involves three different entity types.
Binary Relationship - ANSWER -A Unique identifier - ANSWER -It is used
relationship between two entity types. to uniquely identify each record in a database
table.
Unary Relationship - ANSWER -An
associate occurrence of an entity type with Attribute - ANSWER -A property,
other occurrences of the same entity type. characteristic, or fact that we know about an
entity.
Cardinality - ANSWER -The maximum
number of entities that can be involved in a "A salesperson works in one office."
, WGU C175 Study Notecards
What is the name of this relationship? - is authorized to sell to at least one or many
ANSWER -One-to-one binary products, and each product can be sold by at
relationship least one or many salespeople." -
ANSWER -
"A salesperson sells to many customers."
"One salesperson backs-up another
What is the name of this relationship? - salesperson."
ANSWER -One-to-many binary
relationship What is the name of this model? -
ANSWER -One-to-one unary
relationship
"A salesperson is authorized to sell many
products, and a product can be sold by many
salespersons." "A salesperson manages zero to many other
salespersons, and a salesperson is managed
What is the name of this relationship? - by exactly one other salesperson."
ANSWER -Many-to-many binary
relationship What is the name of this model? -
ANSWER -One-to-many unary
relationship
What is the positioning and meaning for
Cardinality and Modality on an E-R model? -
ANSWER -Cardinality is the outer "A product can either be part of no other
symbol; represents the maximum. products or be part of several other products,
and a product can either be composed of no
Modality is the inner symbol; represents the other products or be composed of several
minimum. other products."
What is the name of this model? -
"A salesperson works in a minimum of one ANSWER -Many-to-many unary
and a maximum of one office, and an office relationship
may be occupied by or assigned to a
minimum of zero and a maximum of one
salesperson." - ANSWER - What does 'refer' in Referential Integrity
imply? - ANSWER -This revolves around
the circumstance of trying to refer to data in
"A salesperson may have no customers or one relation in the database, based on values
many customers." - ANSWER - in another relation.
Describe the ER model for "Each salesperson Define the delete rule RESTRICT. -
Flat Files - ANSWER -a file having no particular relationship.
internal hierarchy
E-R Model
Hashed Files - ANSWER -A file that has
been encrypted for security purposes. *E-R = Entity - Relationship - ANSWER -
Diagram of entities together with their
attributes and the relationship among them.
Heap File - ANSWER -An unsorted set
of records.
Intersection Data - ANSWER -It is data
that describes a many-to-many relationship.
Information - ANSWER -The
transformation of raw data into useful facts.
Modality - ANSWER -It is a minimum
number of entity occurrences that can be
Punch Card - ANSWER -A card that is involved in a relationship.
perforated and can hold commands or data.
One-to-one Binary Relationship -
Structured Data - ANSWER - ANSWER -It means that a single
Information with a high degree of occurrence of one entity type can be
organization. associated with a single occurrence of the
other entity type and vice versa.
Unstructured Data - ANSWER -
Information that does not have structure Ternary Relationship - ANSWER -
(such as text) Involves three different entity types.
Binary Relationship - ANSWER -A Unique identifier - ANSWER -It is used
relationship between two entity types. to uniquely identify each record in a database
table.
Unary Relationship - ANSWER -An
associate occurrence of an entity type with Attribute - ANSWER -A property,
other occurrences of the same entity type. characteristic, or fact that we know about an
entity.
Cardinality - ANSWER -The maximum
number of entities that can be involved in a "A salesperson works in one office."
, WGU C175 Study Notecards
What is the name of this relationship? - is authorized to sell to at least one or many
ANSWER -One-to-one binary products, and each product can be sold by at
relationship least one or many salespeople." -
ANSWER -
"A salesperson sells to many customers."
"One salesperson backs-up another
What is the name of this relationship? - salesperson."
ANSWER -One-to-many binary
relationship What is the name of this model? -
ANSWER -One-to-one unary
relationship
"A salesperson is authorized to sell many
products, and a product can be sold by many
salespersons." "A salesperson manages zero to many other
salespersons, and a salesperson is managed
What is the name of this relationship? - by exactly one other salesperson."
ANSWER -Many-to-many binary
relationship What is the name of this model? -
ANSWER -One-to-many unary
relationship
What is the positioning and meaning for
Cardinality and Modality on an E-R model? -
ANSWER -Cardinality is the outer "A product can either be part of no other
symbol; represents the maximum. products or be part of several other products,
and a product can either be composed of no
Modality is the inner symbol; represents the other products or be composed of several
minimum. other products."
What is the name of this model? -
"A salesperson works in a minimum of one ANSWER -Many-to-many unary
and a maximum of one office, and an office relationship
may be occupied by or assigned to a
minimum of zero and a maximum of one
salesperson." - ANSWER - What does 'refer' in Referential Integrity
imply? - ANSWER -This revolves around
the circumstance of trying to refer to data in
"A salesperson may have no customers or one relation in the database, based on values
many customers." - ANSWER - in another relation.
Describe the ER model for "Each salesperson Define the delete rule RESTRICT. -
