Question 1

If entity B is a mandatory participant, then:

Accepted Answer

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. 
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.

Question 2

A ternary relationship is the equivalent of three binary relationships.

Accepted Answer

A) True 
 B)False

Question 3

In order to determine the integrity rules, minimum and maximum cardinality, and time dimensions of data, an analyst might ask, "Are values for data characteristics limited in any way?"

Accepted Answer

A) True 
 B)False

Question 4

The primary deliverable from the conceptual data-modeling step within the analysis phase is:

Accepted Answer

A)  a state-transition diagram. 
B)  an entity-relationship diagram. 
C)  a context data flow diagram. 
D)  a decision table. 
E)  Structured English. 
A)  a state-transition diagram. 
B)  an entity-relationship diagram. 
C)  a context data flow diagram. 
D)  a decision table. 
E)  Structured English.

Question 5

A multivalued attribute is an attribute that may take on more than one value for each entity instance.

Accepted Answer

A) True 
 B)False

Question 6

Since a name represents a set of entities, it is plural on an entity-relationship diagram.

Accepted Answer

A) True 
 B)False

Question 7

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

Accepted Answer

A) True 
 B)False

Question 8

Social security number, last name, and first name are examples of entity types.

Accepted Answer

A) True 
 B)False

Question 9

An order number is a good example of a candidate key.

Accepted Answer

A) True 
 B)False

Question 10

Analysts should consider substituting single-attribute surrogate keys for large composite keys.

Accepted Answer

A) True 
 B)False

Question 11

Vehicle identification number, color, weight, and horsepower best exemplify:

Accepted Answer

A)  entities. 
B)  entity types. 
C)  data markers. 
D)  identifiers. 
E)  attributes. 
A)  entities. 
B)  entity types. 
C)  data markers. 
D)  identifiers. 
E)  attributes.

Question 12

A collection of entities that share common properties or characteristics best defines:

Accepted Answer

A)  entity type. 
B)  entity instance. 
C)  entity occurrence. 
D)  entity collection. 
E)  data set. 
A)  entity type. 
B)  entity instance. 
C)  entity occurrence. 
D)  entity collection. 
E)  data set.

Question 13

Briefly discuss generating alternative design strategies.

Accepted Answer

The generation of at least three alterna

Question 14

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 15

A join is an association between the instances of one or more entity types that is of interest to the organization.

Accepted Answer

A) True 
 B)False

Question 16

An ideal number of alternatives to generate is:

Accepted Answer

A)  3. 
B)  2. 
C)  4. 
D)  5. 
E)  7. 
A)  3. 
B)  2. 
C)  4. 
D)  5. 
E)  7.

Question 17

Cost is the primary focus of high-end alternatives.

Accepted Answer

A) True 
 B)False

Question 18

Contrast data modeling to process modeling and logic modeling.

Accepted Answer

Data modeling focuses on the data that m

Question 19

Enumerating different potential implementation environments that could be used to deliver the different sets of capabilities occurs during the:

Accepted Answer

A)  requirements structuring step of the analysis phase. 
B)  shaping alternative system design strategies phase. 
C)  testing step of the implementation and operation phase. 
D)  project initiation and planning step of the planning and selection phase. 
E)  designing the human interface step of the design phase. 
A)  requirements structuring step of the analysis phase. 
B)  shaping alternative system design strategies phase. 
C)  testing step of the implementation and operation phase. 
D)  project initiation and planning step of the planning and selection phase. 
E)  designing the human interface step of the design phase.

Question 20

Which of the following is a True statement?

Accepted Answer

A)  A data model explains what the organization does and what rules govern how work is done in the organization. 
B)  To construct a data model, you need to know how data are processed. 
C)  To construct a data model, you need to know when data are processed. 
D)  A data flow diagram graphically illustrates the structure and relationships among data items. 
E)  During conceptual data modeling, the preparation of a Network diagram is necessary. 
A)  A data model explains what the organization does and what rules govern how work is done in the organization. 
B)  To construct a data model, you need to know how data are processed. 
C)  To construct a data model, you need to know when data are processed. 
D)  A data flow diagram graphically illustrates the structure and relationships among data items. 
E)  During conceptual data modeling, the preparation of a Network diagram is necessary.

If entity B is a mandatory participant, then:

A ternary relationship is the equivalent of three binary relationships.

In order to determine the integrity rules, minimum and maximum cardinality, and time dimensions of data, an analyst might ask, "Are values for data characteristics limited in any way?"

The primary deliverable from the conceptual data-modeling step within the analysis phase is:

A multivalued attribute is an attribute that may take on more than one value for each entity instance.

Since a name represents a set of entities, it is plural on an entity-relationship diagram.

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

Social security number, last name, and first name are examples of entity types.

An order number is a good example of a candidate key.

Analysts should consider substituting single-attribute surrogate keys for large composite keys.

Vehicle identification number, color, weight, and horsepower best exemplify:

A collection of entities that share common properties or characteristics best defines:

Briefly discuss generating alternative design strategies.

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

A join is an association between the instances of one or more entity types that is of interest to the organization.

An ideal number of alternatives to generate is:

Cost is the primary focus of high-end alternatives.

Contrast data modeling to process modeling and logic modeling.

Enumerating different potential implementation environments that could be used to deliver the different sets of capabilities occurs during the:

Which of the following is a True statement?

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Designing the Human Interface

Designing Databases

Systems Implementation and Operation

Filters

Exam 7: Structuring System Requirements: Conceptual Data Modeling

If entity B is a mandatory participant, then:

A ternary relationship is the equivalent of three binary relationships.

In order to determine the integrity rules, minimum and maximum cardinality, and time dimensions of data, an analyst might ask, "Are values for data characteristics limited in any way?"

The primary deliverable from the conceptual data-modeling step within the analysis phase is:

A multivalued attribute is an attribute that may take on more than one value for each entity instance.

Since a name represents a set of entities, it is plural on an entity-relationship diagram.

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

Social security number, last name, and first name are examples of entity types.

An order number is a good example of a candidate key.

Analysts should consider substituting single-attribute surrogate keys for large composite keys.

Vehicle identification number, color, weight, and horsepower best exemplify:

A collection of entities that share common properties or characteristics best defines:

Briefly discuss generating alternative design strategies.

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

A join is an association between the instances of one or more entity types that is of interest to the organization.

An ideal number of alternatives to generate is:

Cost is the primary focus of high-end alternatives.

Contrast data modeling to process modeling and logic modeling.

Enumerating different potential implementation environments that could be used to deliver the different sets of capabilities occurs during the:

Which of the following is a True statement?

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Designing the Human Interface

Designing Databases

Systems Implementation and Operation

Filters