WGU C175 COMPREHENSIVE DETAILED STUDY GUIDE
QUESTIONS AND CORRECT ANSWERS [ALREADY GRADED
A+ NEWEST EDITION 2024
What are the four major DBMS approaches? - (correct answer) - Hierarchical
- Network
- Relational
- Object-oriented
What are four key differences between a RELATION and a FILE? - (correct answer)
- The columns of a relation can be arranged in any order w/o affecting the meaning of
the data. That is not true of a file.
- Similarly, the rows of a relation can be arranged in any order, which is not true of a file.
- Every row/column position, sometimes referred to as a "cell", can have only a single
value, which is not necessarily true in a file.
- No two rows of a relation are identical, which is not necessarily true in a file.
Flat Files - (correct answer) a file having no internal hierarchy
Hashed Files - (correct answer) A file that has been encrypted for security purposes.
Heap File - (correct answer) An unsorted set of records.
Information - (correct answer) The transformation of raw data into useful facts.
Punch Card - (correct answer) A card that is perforated and can hold commands or
data.
Structured Data - (correct answer) Information with a high degree of organization.
Unstructured Data - (correct answer) Information that does not have structure (such
as text)
Binary Relationship - (correct answer) A relationship between two entity types.
Unary Relationship - (correct answer) An associate occurrence of an entity type with
other occurrences of the same entity type.
Cardinality - (correct answer) The maximum number of entities that can be involved
in a particular relationship.
E-R Model
*E-R = Entity - Relationship - (correct answer) Diagram of entities together with their
attributes and the relationship among them.
, Intersection Data - (correct answer) It is data that describes a many-to-many
relationship.
Modality - (correct answer) It is a minimum number of entity occurrences that can be
involved in a relationship.
One-to-one Binary Relationship - (correct 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 - (correct answer) Involves three different entity types.
Unique identifier - (correct answer) It is used to uniquely identify each record in a
database table.
Attribute - (correct 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? - (correct answer) One-to-one binary
relationship
"A salesperson sells to many customers."
What is the name of this relationship? - (correct 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? - (correct answer) Many-to-many binary
relationship
What is the positioning and meaning for Cardinality and Modality on an E-R model? -
(correct 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." - (correct answer)
"A salesperson may have no customers or many customers." - (correct answer)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MEGAMINDS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
