WGU C175 OBJECTIVE - ANSWERS| IT CIS111 TEST BANK 1 written by ACEMY...

WGU C175 OBJECTIVE

ASSESSMENT PRACTICE TEST

ANSWERS| IT CIS111 TEST BANK 1

written by

ACEMYWORK

The Marketplace to Buy and Sell your Study Material At Stuvia, you will find the best notes, summaries, flashcards & other study material. Search for your school or uni and find the study material you need.www.stuvia.com

Downloaded by: ACEMYWORK | [email protected]

Distribution of this document is illegal Want to earn $1.236 extra per year?

Chapter 2 Data Modeling

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 Stuvia.com - The Marketplace to Buy and Sell your Study Material

Downloaded by: ACEMYWORK | [email protected]

Distribution of this document is illegal Want to earn $1.236 extra per year?

Stuvia.com - The Marketplace to Buy and Sell your Study MaterialChapter 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 Stuvia.com - The Marketplace to Buy and Sell your Study Material

Downloaded by: ACEMYWORK | [email protected]

Distribution of this document is illegal Want to earn $1.236 extra per year?

Stuvia.com - The Marketplace to Buy and Sell your Study MaterialChapter 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 Stuvia.com - The Marketplace to Buy and Sell your Study Material

Downloaded by: ACEMYWORK | [email protected]

Distribution of this document is illegal Want to earn $1.236 extra per year?