WGU C175 Study questions with answers.

WGU C175 Study questions with answers
|\ |\ |\ |\ |\




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. |\ |\ |\

,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.
|\ |\ |\ |\ |\ |\




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
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


✔✔One-to-one binary relationship |\ |\




"A salesperson sells to many customers."
|\ |\ |\ |\ |\




What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


✔✔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? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\


✔✔Many-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.
|\ |\ |\ |\ |\ |\ |\