Question 1

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.

Accepted Answer

A) True 
 B)False

Question 2

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 
A) attribute 
B) data element 
C) relationship 
D) entity

Question 3

A unary relationship is the most common type of relationship encountered in data modeling.

Accepted Answer

A) True 
 B)False

Question 4

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 5

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

Question 6

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 7

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

Accepted Answer

A) the characteristics of data captured during data modeling are crucial in the design of databases,programs,computer screens,and printed reports 
B) data rather than processes are the most complex aspects of many modern information systems and thus require a central role in structuring system requirements 
C) the characteristics about data are reasonably permanent 
D) all of the above 
A) the characteristics of data captured during data modeling are crucial in the design of databases,programs,computer screens,and printed reports 
B) data rather than processes are the most complex aspects of many modern information systems and thus require a central role in structuring system requirements 
C) the characteristics about data are reasonably permanent 
D) all of the above

Question 8

An attribute that may take on more than one value for each entity instance is referred to as a:

Accepted Answer

A) gerund 
B) multivalued attribute 
C) nonexclusive attribute 
D) supertype 
A) gerund 
B) multivalued attribute 
C) nonexclusive attribute 
D) supertype

Question 9

A ________ is the set of all data types and range of values that an attribute can assume.

Accepted Answer

The answer of A ________ is the set of all...

Question 10

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 
A) gerund 
B) multivalued attribute 
C) nonexclusive attribute 
D) repeating attribute

Question 11

An E-R model with attributes is prepared during:

Accepted Answer

A) design 
B) project identification and selection 
C) analysis 
D) project initiation and planning 
A) design 
B) project identification and selection 
C) analysis 
D) project initiation and planning

Question 12

The top-down approach to data modeling derives the business rules for a data model from an intimate understanding of the nature of the business.

Accepted Answer

A) True 
 B)False

Question 13

A simultaneous relationship among instances of three entity types is a:

Accepted Answer

A) unary relationship 
B) binary relationship 
C) ternary relationship 
D) multiple occurrence 
A) unary relationship 
B) binary relationship 
C) ternary relationship 
D) multiple occurrence

Question 14

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 15

Triggers are constraints on valid values for attributes.

Accepted Answer

A) True 
 B)False

Question 16

Triggering operations are other business rules that protect the validity of attribute values.

Accepted Answer

A) True 
 B)False

Question 17

A ________ is a relationship between the instances of one entity type.

Accepted Answer

The answer of A ________ is a relationship between the...

Question 18

The three main constructs of the entity-relationship modeling notation include each of the following except:

Accepted Answer

A) data entities 
B) data flows 
C) relationships 
D) attributes 
A) data entities 
B) data flows 
C) relationships 
D) attributes

Question 19

Which of the following refers to the set of all data types and values that an attribute can assume?

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 20

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

Accepted Answer

A) degree of the relationship 
B) minimum cardinality of the relationship 
C) maximum cardinality of the relationship 
D) domain of the relationship 
A) degree of the relationship 
B) minimum cardinality of the relationship 
C) maximum cardinality of the relationship 
D) domain of the relationship

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.

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

A unary relationship is the most common type of relationship encountered in data modeling.

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

If entity B is a mandatory participant,then:

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

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

An attribute that may take on more than one value for each entity instance is referred to as a:

A ________ is the set of all data types and range of values that an attribute can assume.

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

An E-R model with attributes is prepared during:

The top-down approach to data modeling derives the business rules for a data model from an intimate understanding of the nature of the business.

A simultaneous relationship among instances of three entity types is a:

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

Triggers are constraints on valid values for attributes.

Triggering operations are other business rules that protect the validity of attribute values.

A ________ is a relationship between the instances of one entity type.

The three main constructs of the entity-relationship modeling notation include each of the following except:

Which of the following refers to the set of all data types and values that an attribute can assume?

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

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

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository.

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

A unary relationship is the most common type of relationship encountered in data modeling.

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

If entity B is a mandatory participant,then:

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

Some systems developers believe that a data model is the most important part of the statement of information system requirements because:

An attribute that may take on more than one value for each entity instance is referred to as a:

A ________ is the set of all data types and range of values that an attribute can assume.

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

An E-R model with attributes is prepared during:

The top-down approach to data modeling derives the business rules for a data model from an intimate understanding of the nature of the business.

A simultaneous relationship among instances of three entity types is a:

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

Triggers are constraints on valid values for attributes.

Triggering operations are other business rules that protect the validity of attribute values.

A ________ is a relationship between the instances of one entity type.

The three main constructs of the entity-relationship modeling notation include each of the following except:

Which of the following refers to the set of all data types and values that an attribute can assume?

The minimum number of instances of entity B that may be associated with each instance of entity A defines the:

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