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