Question 1

The number of instances of entity B that can (or must) be associated with each instance of entity A refers to:

Accepted Answer

A)  cardinality. 
B)  domain. 
C)  ternary occurrence. 
D)  participation level. 
E)  join level. 
A)  cardinality. 
B)  domain. 
C)  ternary occurrence. 
D)  participation level. 
E)  join level.

Question 2

Asking system users and managers "Who is responsible for establishing legitimate values for these data?" helps determine:

Accepted Answer

A)  the candidate key. 
B)  security controls and understanding who really knows the meaning of data. 
C)  relationships and their cardinality and degrees. 
D)  attributes and secondary keys. 
E)  integrity rules, minimum and maximum cardinality, and time dimensions of data. 
A)  the candidate key. 
B)  security controls and understanding who really knows the meaning of data. 
C)  relationships and their cardinality and degrees. 
D)  attributes and secondary keys. 
E)  integrity rules, minimum and maximum cardinality, and time dimensions of data.

Question 3

Contrast data modeling to process modeling and logic modeling.

Accepted Answer

Data modeling focuses on the data that m

Question 4

The most conservative solutions in terms of the effort, cost, and technology involved in developing a new system are the:

Accepted Answer

A)  low-end solutions. 
B)  high-end solutions. 
C)  mid-range solutions. 
D)  constraint-dependent solutions. 
E)  requirements-dependent solutions. 
A)  low-end solutions. 
B)  high-end solutions. 
C)  mid-range solutions. 
D)  constraint-dependent solutions. 
E)  requirements-dependent solutions.

Question 5

Define the following key data modeling terms: entity, attribute, relationship, degree, cardinality, and associative entity.

Accepted Answer

An entity is a person, place, object, ev

Question 6

The identification of a system's mandatory features would be performed during systems planning and selection.

Accepted Answer

A) True 
 B)False

Question 7

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

Accepted Answer

A) True 
 B)False

Question 8

An identifier is a candidate key that has been selected as the unique, identifying characteristic for an entity type.

Accepted Answer

A) True 
 B)False

Question 9

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.)
-Functionality, not cost, is the primary focus of these alternatives.

Accepted Answer

A) High-end alternatives 
B) Midrange alternatives 
C) Low-end alternatives 
A) High-end alternatives 
B) Midrange alternatives 
C) Low-end alternatives

Question 10

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 11

Which of the following is a true statement?

Accepted Answer

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

Question 12

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

Accepted Answer

A) True 
 B)False

Question 13

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)  alternative generation and selection step of the analysis 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)  alternative generation and selection step of the analysis 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 14

Gathering the information you need for data modeling by reviewing specific business documents handled within the system describes the:

Accepted Answer

A)  bottom-up approach. 
B)  conceptual approach. 
C)  top-down approach. 
D)  investigative approach. 
E)  business approach. 
A)  bottom-up approach. 
B)  conceptual approach. 
C)  top-down approach. 
D)  investigative approach. 
E)  business approach.

Question 15

Match each of the following terms with its corresponding definition.
-An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

Accepted Answer

A) Unary relationship 
B) Ternary relationship 
C) Binary relationship 
D) Relationship 
E) Repeating group
F)Associative entity 
A) Unary relationship 
B) Ternary relationship 
C) Binary relationship 
D) Relationship 
E) Repeating group
F)Associative entity

Question 16

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n):

Accepted Answer

A)  attribute. 
B)  data element. 
C)  relationship. 
D)  entity. 
E)  process. 
A)  attribute. 
B)  data element. 
C)  relationship. 
D)  entity. 
E)  process.

Question 17

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 18

Asking system users and business managers "Is each activity or event always handled the same way or are there special circumstances?" helps determine:

Accepted Answer

A)  the candidate key. 
B)  integrity rules, minimum and maximum cardinality, and time dimensions of data. 
C)  security controls and understanding who really knows the meaning of data. 
D)  attributes and secondary keys. 
E)  relationships and their cardinality and degrees. 
A)  the candidate key. 
B)  integrity rules, minimum and maximum cardinality, and time dimensions of data. 
C)  security controls and understanding who really knows the meaning of data. 
D)  attributes and secondary keys. 
E)  relationships and their cardinality and degrees.

Question 19

A repeating group is a set of two or more multivalued attributes that are logically related.

Accepted Answer

A) True 
 B)False

Question 20

A ternary relationship occurs when a simultaneous relationship exists among instances of:

Accepted Answer

A)  the same entity. 
B)  two entity types. 
C)  three entity types. 
D)  four entity types. 
E)  nine entity types. 
A)  the same entity. 
B)  two entity types. 
C)  three entity types. 
D)  four entity types. 
E)  nine entity types.

The number of instances of entity B that can (or must) be associated with each instance of entity A refers to:

Asking system users and managers "Who is responsible for establishing legitimate values for these data?" helps determine:

Contrast data modeling to process modeling and logic modeling.

The most conservative solutions in terms of the effort, cost, and technology involved in developing a new system are the:

Define the following key data modeling terms: entity, attribute, relationship, degree, cardinality, and associative entity.

The identification of a system's mandatory features would be performed during systems planning and selection.

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

An identifier is a candidate key that has been selected as the unique, identifying characteristic for an entity type.

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.) -Functionality, not cost, is the primary focus of these alternatives.

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

Which of the following is a true statement?

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

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

Gathering the information you need for data modeling by reviewing specific business documents handled within the system describes the:

Match each of the following terms with its corresponding definition. -An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n):

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?"

Asking system users and business managers "Is each activity or event always handled the same way or are there special circumstances?" helps determine:

A repeating group is a set of two or more multivalued attributes that are logically related.

A ternary relationship occurs when a simultaneous relationship exists among instances of:

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

object-Oriented Analysis and Design

Agile Methodologies

Filters

Exam 7: Structuring System Requirements: Conceptual Data Modeling

The number of instances of entity B that can (or must) be associated with each instance of entity A refers to:

Asking system users and managers "Who is responsible for establishing legitimate values for these data?" helps determine:

Contrast data modeling to process modeling and logic modeling.

The most conservative solutions in terms of the effort, cost, and technology involved in developing a new system are the:

Define the following key data modeling terms: entity, attribute, relationship, degree, cardinality, and associative entity.

The identification of a system's mandatory features would be performed during systems planning and selection.

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

An identifier is a candidate key that has been selected as the unique, identifying characteristic for an entity type.

Match each of the following alternatives with its corresponding description.(Answers may occur more than once.) -Functionality, not cost, is the primary focus of these alternatives.

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

Which of the following is a true statement?

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

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

Gathering the information you need for data modeling by reviewing specific business documents handled within the system describes the:

Match each of the following terms with its corresponding definition. -An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n):

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?"

Asking system users and business managers "Is each activity or event always handled the same way or are there special circumstances?" helps determine:

A repeating group is a set of two or more multivalued attributes that are logically related.

A ternary relationship occurs when a simultaneous relationship exists among instances of:

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

object-Oriented Analysis and Design

Agile Methodologies

Filters