Question 1

Process,logic,and data model descriptions of a system must be consistent and complete because:

Accepted Answer

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) programming tasks require the integration of the information contained in the diagrams 
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) programming tasks require the integration of the information contained in the diagrams

Question 2

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

Accepted Answer

A) referential integrity constraints 
B) triggering operations 
C) entity integrity 
D) domains 
A) referential integrity constraints 
B) triggering operations 
C) entity integrity 
D) domains

Question 3

Analysts should substitute single-attribute surrogate keys for large composite keys.

Accepted Answer

A) True 
 B)False

Question 4

The set of all data types and ranges of values that an attribute can assume defines:

Accepted Answer

A) cardinality 
B) constraint set 
C) domain 
D) reference set 
A) cardinality 
B) constraint set 
C) domain 
D) reference set

Question 5

The ________ specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

Accepted Answer

The answer of The ________ specifies that an entity instance...

Question 6

What are multivalued attributes and repeating groups? Provide an example of each.

Accepted Answer

A multivalued attribute is an attribute

Question 7

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

Question 8

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 
A) cardinality 
B) domain 
C) ternary occurrence 
D) participation level

Question 9

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 
A) top-down approach 
B) bottom-up approach 
C) overview approach 
D) business approach

Question 10

A ________ is a subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings.

Accepted Answer

The answer of A ________ is a subgrouping of the...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

The goal of conceptual data modeling is to capture as much of the meaning of data as possible.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) logical design 
B) physical design 
C) analysis 
D) implementation 
A) logical design 
B) physical design 
C) analysis 
D) implementation

Question 14

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) coupling 
D) cardinality 
A) occurrence 
B) relationship 
C) coupling 
D) cardinality

Question 15

Assume you work for Technology Central,an organization that provides on-site technology seminars for various companies.Identify at least four entities that your company would track.Build a conceptual model.

Accepted Answer

Technology Central tracks information ab

Question 16

An ________ is 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

The answer of An ________ is an entity type that...

Question 17

Use a verb or verb phrase to name an entity.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

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 20

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

Process,logic,and data model descriptions of a system must be consistent and complete because:

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

Analysts should substitute single-attribute surrogate keys for large composite keys.

The set of all data types and ranges of values that an attribute can assume defines:

The ________ specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

What are multivalued attributes and repeating groups? Provide an example of each.

When selecting an identifier,one should:

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

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 ________ is a subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings.

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

The goal of conceptual data modeling is to capture as much of the meaning of data as possible.

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

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

Assume you work for Technology Central,an organization that provides on-site technology seminars for various companies.Identify at least four entities that your company would track.Build a conceptual model.

An ________ is 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.

Use a verb or verb phrase to name an entity.

Which of the following is a true statement?

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

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

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Designing Databases

Designing Forms and Reports

Designing Interfaces and Dialogues

Designing Distributed and Internet Systems

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Filters

Exam 8: Structuring System Data Requirements

Process,logic,and data model descriptions of a system must be consistent and complete because:

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

Analysts should substitute single-attribute surrogate keys for large composite keys.

The set of all data types and ranges of values that an attribute can assume defines:

The ________ specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

What are multivalued attributes and repeating groups? Provide an example of each.

When selecting an identifier,one should:

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

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 ________ is a subgrouping of the entities in an entity type that is meaningful to the organization and that shares common attributes or relationships distinct from other subgroupings.

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

The goal of conceptual data modeling is to capture as much of the meaning of data as possible.

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

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

Assume you work for Technology Central,an organization that provides on-site technology seminars for various companies.Identify at least four entities that your company would track.Build a conceptual model.

An ________ is 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.

Use a verb or verb phrase to name an entity.

Which of the following is a true statement?

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

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

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Designing Databases

Designing Forms and Reports

Designing Interfaces and Dialogues

Designing Distributed and Internet Systems

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Filters