629chapter7multi

Process, logic, and data-model descriptions of a system must be consistent and complete since: A. they each describe different but complementary views of the same information system. B. they are prepared during the analysis phase. C. they are constructed in parallel by separate analyst teams. D. a data model indicates when the data are processed. E. a data model shows how the data are processed.

Answer: A Diff: 2 Page Ref: 191 74

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the: A. top-down approach. B. bottom-up approach. C. overview approach. D. business approach. E. conceptual approach.

Answer: A Diff: 2 Page Ref: 195 83

A single occurrence of an entity type defines: A. entity instance. B. entity appearance. C. attribute. D. data element. E. multivalued attribute.

Answer: A Diff: 2 Page Ref: 198 95

A collection of entities that share common properties or characteristics best defines: A. entity type. B. entity instance. C. entity occurrence. D. entity collection. E. data set.

Answer: A Diff: 2 Page Ref: 198 94

A named property or characteristic of an entity that is of interest to the organization defines: A. attribute. B. relationship. C. instance. D. associative entity. E. data flow.

Answer: A Diff: 2 Page Ref: 199 97

The number of instances of entity B that can (or must be associated with each instance of entity A refers to: A. cardinality. B. domain. C. ternary occurrence. D. participation level. E. join level.

Answer: A Diff: 2 Page Ref: 203 114

The most common format used for data modeling is: A. state-transition diagramming. B. entity-relationship diagramming. C. process modeling. D. logic modeling. E. a flowchart.

Answer: B Diff: 2 Page Ref: 190 75

The primary deliverable from the conceptual data-modeling step within the analysis phase is: A. a state-transition diagram. B. an entity-relationship diagram. C. a context data flow diagram. D. a decision table. E. Structured English.

Answer: B Diff: 2 Page Ref: 191-192 80

A candidate key that has been selected as the unique, identifying characteristic for an entity type is called a: A. attribute. B. identifier. C. secondary key. D. gerund. E. index.

Answer: B Diff: 2 Page Ref: 199 101

An attribute that can have more than one value for each entity instance is referred to as: A. a gerund. B. a multivalued attribute. C. a nonexclusive attribute. D. a data replica. E. none of the above.

Answer: B Diff: 2 Page Ref: 200 103

If each employee can have more than one skill, then skill is referred to as a: A. gerund. B. multivalued attribute. C. nonexclusive attribute. D. repeating attribute. E. data replica.

Answer: B Diff: 2 Page Ref: 200 104

An association between the instances of one or more entity types that is of interest to the organization best defines: A. occurrence. B. relationship. C. natural connection. D. cardinality. E. entity link.

Answer: B Diff: 2 Page Ref: 201 106

A relationship between instances of two entity types is a: A. unary relationship. B. binary relationship. C. ternary relationship. D. multiple occurrence. E. partnership occurrence.

Answer: B Diff: 2 Page Ref: 203 112

The minimum number of instances of entity B that may be associated with each instance of entity A defines the: A. degree of the relationship. B. minimum cardinality of the relationship. C. maximum cardinality of the relationship. D. domain of the relationship. E. join level.

Answer: B Diff: 2 Page Ref: 203 115

A relationship that the data modeler chooses to model as an entity type best defines: A. recursive relationship. B. associative entity. C. domain. D. complex relationship. E. complex entity.

Answer: B Diff: 2 Page Ref: 204 118

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during: A. systems planning and selection. B. systems design. C. analysis. D. systems implementation and operation. E. systems evaluation.

Answer: C Diff: 2 Page Ref: 190 73

A detailed, logical, and graphical representation of the entities, associations, and data elements for an organization or business area best describes a: A. logic model. B. data-flow diagram. C. entity-relationship diagram or E-R diagram. D. structure chart. E. data tree.

Answer: C Diff: 2 Page Ref: 197 89

An attribute (or combination of attributes that uniquely identifies each instance of an entity type defines: A. data element occurrence. B. trigger. C. candidate key. D. associative entity. E. data marker.

Answer: C Diff: 2 Page Ref: 199 99

When selecting an identifier, one should: A. use intelligent keys. B. use large composite keys instead of single-attribute surrogate keys. C. choose a candidate key that will not change its value over the life of each instance of the entity type. D. choose a candidate key such that for each instance of the entity, the attribute is guaranteed to have valid values or is null. E. choose a candidate key that allows for duplicate values.

Answer: C Diff: 2 Page Ref: 199 100

A set of two or more multivalued attributes that are logically related defines: A. relationship. B. associative entity. C. repeating group. D. class. E. repeating entity.

Answer: C Diff: 2 Page Ref: 201 105

If STUDENT and COURSE participate in a relationship, this is an example of a: A. unary relationship. B. coupled relationship. C. binary relationship. D. ternary relationship. E. extraordinary relationship.

Answer: C Diff: 2 Page Ref: 203 110

A simultaneous relationship among instances of three entity types is a: A. unary relationship. B. binary relationship. C. ternary relationship. D. multiple occurrence. E. recursive join.

Answer: C Diff: 2 Page Ref: 203 113

If entity B is a mandatory participant, then: A. the minimum cardinality of the relationship is two. B. the minimum cardinality of the relationship cannot be defined. C. the minimum cardinality of the relationship is one. D. the minimum cardinality of the relationship is optional. E. the join level is not null.

Answer: C Diff: 2 Page Ref: 203 116

Which of the following is a true statement? A. Data characteristics are dynamic. B. A data model explains the transient form of an organization. C. An information system design based on a data orientation, rather than a process or logic orientation, should have a longer useful life. D. Data flow paths are permanent. E. A data model graphically represents the processes that capture, manipulate, store, and distribute data between a system and its environment and among components within a system.

Answer: C Diff: 3 Page Ref: 190 72

Some systems developers believe that a data model is the most important part of the statement of information system requirements because: A. the characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports. B. data rather than processes are the most complex aspects of many modern information systems and thus require a central role in structuring system requirements. C. the characteristics about data are reasonably permanent. D. of all of the above.

Answer: D

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a: A. attribute. B. data element. C. relationship. D. entity. E. process.

Answer: D Diff: 2 Page Ref: 197 91

The number of entity types that participate in a relationship refers to: A. cardinality. B. association. C. count. D. degree. E. normalization.

Answer: D Diff: 2 Page Ref: 202 109

During requirements structuring:

an E-R model represents conceptual data requirements for a particular system

An E-R model with attributes is prepared during :

analysis