Question 1

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Accepted Answer

A) True 
 B)False

Question 2

Ideally, each data store on a primitive data-flow diagram will be an individual attribute.

Accepted Answer

A) True 
 B)False

Question 3

A faculty identification number could be used as an identifier.

Accepted Answer

A) True 
 B)False

Question 4

Briefly identify the four entity-relationship diagrams that are produced and analyzed during conceptual data modeling.

Accepted Answer

The four entity-relationship diagrams ar

Question 5

A relationship between the instances of one entity type is a:

Accepted Answer

A)  unary relationship. 
B)  binary relationship. 
C)  ternary relationship. 
D)  singular occurrence. 
E)  partnership occurrence. 
A)  unary relationship. 
B)  binary relationship. 
C)  ternary relationship. 
D)  singular occurrence. 
E)  partnership occurrence.

Question 6

Which of the following is a True statement regarding high-end alternatives?

Accepted Answer

A)  High-end 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)  High-end alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of high-end alternative design strategies. 
D)  High-end alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  None of the above are correct. 
A)  High-end 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)  High-end alternative design strategies represent compromise solutions. 
C)  Functionality is the primary focus of high-end alternative design strategies. 
D)  High-end alternative design strategies provide all the required functionality users demand with a system that is minimally different from the current system. 
E)  None of the above are correct.

Question 7

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 8

An association between the instances of one or more entity types that is of interest to the organization best defines:

Accepted Answer

A)  occurrence. 
B)  relationship. 
C)  natural connection. 
D)  cardinality. 
E)  entity link. 
A)  occurrence. 
B)  relationship. 
C)  natural connection. 
D)  cardinality. 
E)  entity link.

Question 9

A relationship between instances of two entity types is a:

Accepted Answer

A)  unary relationship. 
B)  binary relationship. 
C)  ternary relationship. 
D)  multiple occurrence. 
E)  partnership occurrence. 
A)  unary relationship. 
B)  binary relationship. 
C)  ternary relationship. 
D)  multiple occurrence. 
E)  partnership occurrence.

Question 10

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 11

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 12

When selecting an identifier, one should:

Accepted Answer

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

Question 13

Which of the following is a True statement?

Accepted Answer

A)  Mandatory features screen out possible solutions; essential features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
B)  Essential features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
C)  Mandatory features screen out possible solutions; essential features are those that users could live without. 
D)  Essential features screen out possible solutions; mandatory features are those that users could live without. 
E)  Desired features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
A)  Mandatory features screen out possible solutions; essential features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
B)  Essential features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies. 
C)  Mandatory features screen out possible solutions; essential features are those that users could live without. 
D)  Essential features screen out possible solutions; mandatory features are those that users could live without. 
E)  Desired features screen out possible solutions; mandatory features are the important capabilities of a system that will serve as the primary basis for comparison of different design strategies.

Question 14

Discuss unary, binary, and ternary relationships.

Accepted Answer

The number of entity types participating

Question 15

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship (E-R) diagrams.

Accepted Answer

A) True 
 B)False

Question 16

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

Accepted Answer

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

Question 17

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:

Accepted Answer

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

Question 18

Asking system users and business managers, "What are the subjects of the business?" would help determine:

Accepted Answer

A)  the data entities and their descriptions. 
B)  the candidate key. 
C)  attributes and secondary keys. 
D)  relationships and their cardinality and degrees. 
E)  integrity rules, minimum and maximum cardinality, and time dimensions of data. 
A)  the data entities and their descriptions. 
B)  the candidate key. 
C)  attributes and secondary keys. 
D)  relationships and their cardinality and degrees. 
E)  integrity rules, minimum and maximum cardinality, and time dimensions of data.

Question 19

The primary deliverable for the conceptual data-modeling step within the analysis phase is an entity-relationship diagram.

Accepted Answer

A) True 
 B)False

Question 20

A particular approach to developing an information system best describes:

Accepted Answer

A)  design strategy. 
B)  problem statement. 
C)  requirements statement. 
D)  scope. 
E)  systems service request. 
A)  design strategy. 
B)  problem statement. 
C)  requirements statement. 
D)  scope. 
E)  systems service request.

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Ideally, each data store on a primitive data-flow diagram will be an individual attribute.

A faculty identification number could be used as an identifier.

Briefly identify the four entity-relationship diagrams that are produced and analyzed during conceptual data modeling.

A relationship between the instances of one entity type is a:

Which of the following is a True statement regarding high-end alternatives?

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

An association between the instances of one or more entity types that is of interest to the organization best defines:

A relationship between instances of two entity types is a:

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

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

When selecting an identifier, one should:

Which of the following is a True statement?

Discuss unary, binary, and ternary relationships.

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship (E-R) diagrams.

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

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:

Asking system users and business managers, "What are the subjects of the business?" would help determine:

The primary deliverable for the conceptual data-modeling step within the analysis phase is an entity-relationship diagram.

A particular approach to developing an information system best describes:

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 is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Ideally, each data store on a primitive data-flow diagram will be an individual attribute.

A faculty identification number could be used as an identifier.

Briefly identify the four entity-relationship diagrams that are produced and analyzed during conceptual data modeling.

A relationship between the instances of one entity type is a:

Which of the following is a True statement regarding high-end alternatives?

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

An association between the instances of one or more entity types that is of interest to the organization best defines:

A relationship between instances of two entity types is a:

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

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

When selecting an identifier, one should:

Which of the following is a True statement?

Discuss unary, binary, and ternary relationships.

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship (E-R) diagrams.

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

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:

Asking system users and business managers, "What are the subjects of the business?" would help determine:

The primary deliverable for the conceptual data-modeling step within the analysis phase is an entity-relationship diagram.

A particular approach to developing an information system best describes:

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