Computer Science > QUESTIONS & ANSWERS > WGU C175 OBJECTIVE ASSESSMENT PRACTICE TEST ANSWERS| IT CIS111 TEST BANK 1 (All)

WGU C175 OBJECTIVE ASSESSMENT PRACTICE TEST ANSWERS| IT CIS111 TEST BANK 1

Document Content and Description Below

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 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 Chapter 2 Data Modeling 8. A one-to-many binary relationship allows an occurrence of the entity type on the “one side” of the relationship to be associated with . a. a single occurrence of the same entity type b. multiple occurrences of the same entity type c. a single occurrence of the entity type on the “many side” of the relationship d. multiple occurrences of the entity type on the “many side” of the relationship e. multiple occurrences of the entity type on the “one side” of the relationship Ans: d Response: See page 23 9. A many-to-many binary relationship allows an occurrence of one entity type to be associated with . a. a single occurrence of the same entity type b. multiple occurrences of the same entity type c. a single occurrence of another entity type d. multiple occurrences of another entity type e. multiple occurrences of three entity types Ans: d Response: See page 24 10. A business school’s faculty parking lot has assigned parking spaces. Each professor is entitled to one parking space. This is an example of a relationship. a. one-to-one binary b. one-to-many binary c. many-to-many binary d. one-to-one unary e. one-to-many unary Ans: a Response: See page 24 11. Each building on a university campus has several faculty offices. Each professor has one office. The relationship between campus buildings and professors is a relationship. a. one-to-one binary b. one-to-many binary c. many-to-many binary d. one-to-one unary e. one-to-many unary Ans: b Chapter 2 Data Modeling Response: See page 24 12. In a university, the relationship between courses and their sections can best be described as a relationship. a. one-to-one binary b. one-to-many binary c. many-to-many binary d. one-to-one unary e. one-to-many unary Ans: b Response: See page 24 13. In a university setting, the relationship between students and the professors who have been their instructors is a relationship. a. one-to-one binary b. one-to-many binary c. many-to-many binary d. one-to-one unary e. one-to-many unary Ans: b Response: See page 24 14. Intersection data . a. is an attribute of the entity on the “one side” of a one-to-many relationship b. is an attribute of the entity on the “many side” of a one-to-many relationship c. describes the relationship between two entities in a many-to-many relationship d. describes one of the entities in a many-to-many relationship e. describes one of the entities in a ternary relationship Ans: c Response: See page 25 15. Each student at a university takes many courses; each course is taken by many students. The semester that a student took a course and the grade that the student received in the course is called data. a. index b. key c. pointer d. direct access e. intersection [Show More]

Last updated: 1 year ago

Preview 1 out of 15 pages

Add to cart

Instant download

document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Add to cart

Instant download

Reviews( 0 )

$15.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

REQUEST DOCUMENT
49
0

Document information


Connected school, study & course


About the document


Uploaded On

Jun 07, 2022

Number of pages

15

Written in

Seller


seller-icon
Book Worm, Certified

Member since 3 years

21 Documents Sold


Additional information

This document has been written for:

Uploaded

Jun 07, 2022

Downloads

 0

Views

 49

Document Keyword Tags

More From Book Worm, Certified

View all Book Worm, Certified's documents »

$15.00
What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·