WGU C175 OBJECTIVE ASSESSMENT PRACTICE TEST ANSWERS| IT CIS111 TEST BANK 1
12 views 0 purchase
Course
Information Technology
Institution
Information Technology
Chapter 2: Data Modeling
Multiple Choice
1. The Entity-Relationship (E-R) model is .
a. a diagramming technique that describes record structures (i.e. the fields that make
up the records of a file)
b. an alternative to indexing and hashing as a means for providing direct access in
files
c. a...
1. The Entity-Relationship (E-R) model is .
a. a diagramming technique that describes record structures (i.e. the fields that make
up the records of a file)
b. an alternative to indexing and hashing as a means for providing direct access in
files
c. a diagramming technique that describes entities, their attributes, and the
relationships between them
d. an alternative to file design in which attributes are used instead of fields
e. a diagramming technique that relates entities to each other, attributes to each
other, and relationships to each other
Ans: c
Response: See page 20
2. An association between entities is a(n) .
a. entity type
b. entity occurence
c. record
d. attribute
e. relationship
Ans: e
Response: See page 20
3. A binary relationship is a relationship between two .
a. entity types
b. attribute types
c. associations
d. files
e. cardinalities
Ans: a
Response: See page 20
4. The term “binary” in binary relationship indicates that the relationship is between
a. two halves of an entity type
, Chapter 2 Data Modeling
b. two entity types
c. two divisions of an entity’s attributes
d. two attributes
e. two relationships
Ans: b
Response: See page 20
5. The cardinality of a relationship is .
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.
e. The minimum number of associations that can be involved in the relationship.
Ans: b
Response: See page 23
6. The modality of a relationship is .
a. The minimum number of entities that can be involved in the relationship.
b. The maximum number of entities that can be involved in the relationship.
c. The minimum number of attributes that can be in the entity types in a relationship.
d. The maximum number of attributes that can be in the entity types in a
relationship.
e. The minimum number of associations that can be involved in the relationship.
Ans: a
Response: See page 24
7. A one-to-one binary relationship .
a. involves a single entity type
b. involves two entity types
c. allows an occurrence of one entity type to be associated with several occurrences
of another entity type
d. allows an occurrence of one entity type to be associated with several occurrences
of another entity type and vice versa
e. restricts the number of attributes that an entity has
Ans: b
Response: See page 23
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 BrilliantScores. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
