Question 1

An entity instance is a single occurrence of an entity type.

Accepted Answer

A) True 
 B)False  True

Question 2

Employee identification number, name, address, and skill are examples of attributes.

Accepted Answer

A) True 
 B)False  True

Question 3

Analysts should use intelligent keys as identifiers.

Accepted Answer

A) True 
 B)False  False

Question 4

Processes, rather than data, are the most complex aspects of many modern information systems.

Accepted Answer

A) True 
 B)False

Question 5

If each employee can have more than one skill, then skill is referred to as a:

Accepted Answer

A)  gerund. 
B)  multivalued attribute. 
C)  nonexclusive attribute. 
D)  repeating attribute. 
E)  data replica. 
A)  gerund. 
B)  multivalued attribute. 
C)  nonexclusive attribute. 
D)  repeating attribute. 
E)  data replica.

Question 6

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is a True statement regarding midrange alternatives?

Accepted Answer

A)  Midrange alternative design strategies often do not involve computer technology; instead they focus on making paper flows more efficient or reducing redundancies in current processes. 
B)  Midrange alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of midrange alternative design strategies. 
D)  Midrange alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  Midrange alternative design strategies provide all the desired features using advanced technologies that often allow the system to expand to meet future requirements. 
A)  Midrange alternative design strategies often do not involve computer technology; instead they focus on making paper flows more efficient or reducing redundancies in current processes. 
B)  Midrange alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of midrange alternative design strategies. 
D)  Midrange alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  Midrange alternative design strategies provide all the desired features using advanced technologies that often allow the system to expand to meet future requirements.

Question 8

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

Accepted Answer

A) True 
 B)False

Question 9

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 10

The number of entity types that participate in a relationship refers to:

Accepted Answer

A)  cardinality. 
B)  association. 
C)  count. 
D)  degree. 
E)  normalization. 
A)  cardinality. 
B)  association. 
C)  count. 
D)  degree. 
E)  normalization.

Question 11

Which of the following types of alternatives represent compromise solutions?

Accepted Answer

A)  Low-end alternatives 
B)  High-end alternatives 
C)  Midrange alternatives 
D)  Requirements-dependent alternatives 
E)  Constraints-dependent alternatives 
A)  Low-end alternatives 
B)  High-end alternatives 
C)  Midrange alternatives 
D)  Requirements-dependent alternatives 
E)  Constraints-dependent alternatives

Question 12

One way to handle repeating data within an entity is to separate the repeating data into another entity, called a weak entity.

Accepted Answer

A) True 
 B)False

Question 13

The characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports.

Accepted Answer

A) True 
 B)False

Question 14

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

Accepted Answer

A)  systems planning and selection. 
B)  systems design. 
C)  systems analysis. 
D)  systems implementation and operation. 
E)  systems evaluation. 
A)  systems planning and selection. 
B)  systems design. 
C)  systems analysis. 
D)  systems implementation and operation. 
E)  systems evaluation.

Question 15

A ternary relationship is a relationship between instances of one entity type.

Accepted Answer

A) True 
 B)False

Question 16

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 17

An analyst would ask, "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

Accepted Answer

A) True 
 B)False

Question 18

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 19

The alternative that goes beyond simply solving the problem in question and focuses instead on systems that contain many extra features users may desire is referred to as a:

Accepted Answer

A)  low-end alternative. 
B)  high-end alternative. 
C)  quality-focused alternative. 
D)  requirements-dependent alternative. 
E)  constraints-dependent alternative. 
A)  low-end alternative. 
B)  high-end alternative. 
C)  quality-focused alternative. 
D)  requirements-dependent alternative. 
E)  constraints-dependent alternative.

Question 20

On an entity-relationship diagram, a rectangle represents a(n):

Accepted Answer

A)  data flow. 
B)  entity. 
C)  multivalued attribute. 
D)  repeating group. 
E)  relationship. 
A)  data flow. 
B)  entity. 
C)  multivalued attribute. 
D)  repeating group. 
E)  relationship.

An entity instance is a single occurrence of an entity type.

Employee identification number, name, address, and skill are examples of attributes.

Analysts should use intelligent keys as identifiers.

Processes, rather than data, are the most complex aspects of many modern information systems.

If each employee can have more than one skill, then skill is referred to as a:

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Which of the following is a True statement regarding midrange alternatives?

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

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

The number of entity types that participate in a relationship refers to:

Which of the following types of alternatives represent compromise solutions?

One way to handle repeating data within an entity is to separate the repeating data into another entity, called a weak entity.

The characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports.

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

A ternary relationship is a relationship between instances of one entity type.

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

An analyst would ask, "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

The alternative that goes beyond simply solving the problem in question and focuses instead on systems that contain many extra features users may desire is referred to as a:

On an entity-relationship diagram, a rectangle represents a(n):

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

An entity instance is a single occurrence of an entity type.

Employee identification number, name, address, and skill are examples of attributes.

Analysts should use intelligent keys as identifiers.

Processes, rather than data, are the most complex aspects of many modern information systems.

If each employee can have more than one skill, then skill is referred to as a:

In order to determine security controls and understand who really knows the meaning of data, an analyst might ask, "What natural activities or transactions of the business involve handling data about several objects of the same or different type?"

Which of the following is a True statement regarding midrange alternatives?

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

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

The number of entity types that participate in a relationship refers to:

Which of the following types of alternatives represent compromise solutions?

One way to handle repeating data within an entity is to separate the repeating data into another entity, called a weak entity.

The characteristics of data captured during data modeling are crucial in the design of databases, programs, computer screens, and printed reports.

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

A ternary relationship is a relationship between instances of one entity type.

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

An analyst would ask, "What must we know about each object in order to run a business?" in order to determine relationships, their cardinality, and degrees.

Cardinality is the number of instances of entity B that can (or must) be associated with each instance of entity A.

The alternative that goes beyond simply solving the problem in question and focuses instead on systems that contain many extra features users may desire is referred to as a:

On an entity-relationship diagram, a rectangle represents a(n):

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