Question 1

A __________ is an association between the instances of one or more entity types that is of interest to the organization.

Accepted Answer

The answer of A __________ is an association between the...

Question 2

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

Accepted Answer

A) state-transition diagram 
B) E-R diagram 
C) context data flow diagram 
D) decision tree 
A) state-transition diagram 
B) E-R diagram 
C) context data flow diagram 
D) decision tree

Question 3

Business rules are specifications that preserve the integrity of the physical data model.

Accepted Answer

A) True 
 B)False

Question 4

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 5

During requirements structuring:

Accepted Answer

A) an E-R model represents conceptual data requirements for a particular system 
B) the conceptual E-R data model is refined before it is translated into a logical format from which database definition and physical database design are done 
C) an enterprise-wide data model with very broad categories of data and little detail is prepared 
D) a specific E-R model is built to help explain the scope of a particular systems analysis and design effort 
A) an E-R model represents conceptual data requirements for a particular system 
B) the conceptual E-R data model is refined before it is translated into a logical format from which database definition and physical database design are done 
C) an enterprise-wide data model with very broad categories of data and little detail is prepared 
D) a specific E-R model is built to help explain the scope of a particular systems analysis and design effort

Question 6

A candidate key that has been selected as the unique,identifying characteristic for an entity type is called a(n):

Accepted Answer

A) attribute 
B) identifier 
C) secondary key 
D) gerund 
A) attribute 
B) identifier 
C) secondary key 
D) gerund

Question 7

Match each of the following terms with its corresponding definition.
-Specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

Accepted Answer

A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule 
A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Question 8

Match each of the following terms with its corresponding definition.
-On E-R diagrams,relationships are labeled with verb phrases.

Accepted Answer

A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule 
A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Question 9

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 10

What is the role of CASE in conceptual modeling? What information is placed in the CASE repository during conceptual modeling?

Accepted Answer

During conceptual modeling,CASE tools ma

Question 11

A relationship that the data modeler chooses to model as an entity type best defines:

Accepted Answer

A) recursive relationship 
B) associative entity 
C) domain 
D) complex relationship 
A) recursive relationship 
B) associative entity 
C) domain 
D) complex relationship

Question 12

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

Accepted Answer

An entity is a person,place,object,event

Question 13

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 best defines:

Accepted Answer

A) child node 
B) disjoined entity 
C) subtype 
D) supertype 
A) child node 
B) disjoined entity 
C) subtype 
D) supertype

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Match each of the following terms with its corresponding definition.
-Specifications that preserve the integrity of a conceptual or logical data model.

Accepted Answer

A) business rule 
B) disjoint rule 
C) overlap rule 
D) partial specialization rule 
E) total specialization rule 
A) business rule 
B) disjoint rule 
C) overlap rule 
D) partial specialization rule 
E) total specialization rule

Question 16

A plural relationship is a relationship that the data modeler chooses to model as entity type.

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

A collection of entities that share common properties or characteristics defines:

Accepted Answer

A) entity type 
B) entity instance 
C) entity occurrence 
D) entity collection 
A) entity type 
B) entity instance 
C) entity occurrence 
D) entity collection

Question 19

Match each of the following terms with its corresponding definition.
-A many-to-many (or one-to-one)relationship that the data modeler chooses to model as an entity type with several associated one-to-many relationships with other entity types.

Accepted Answer

A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule 
A) unary relationship 
B) ternary relationship 
C) binary relationship 
D) relationship 
E) repeating group
F)associative entity
G)disjoint rule
H)overlap rule
I)partial specialization rule
J)total specialization rule

Question 20

Book,supplier,and state are entity types.

Accepted Answer

A) True 
 B)False

A __________ is an association between the instances of one or more entity types that is of interest to the organization.

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

Business rules are specifications that preserve the integrity of the physical data model.

Which of the following is a true statement?

During requirements structuring:

A candidate key that has been selected as the unique,identifying characteristic for an entity type is called a(n):

Match each of the following terms with its corresponding definition. -Specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

Match each of the following terms with its corresponding definition. -On E-R diagrams,relationships are labeled with verb phrases.

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

What is the role of CASE in conceptual modeling? What information is placed in the CASE repository during conceptual modeling?

A relationship that the data modeler chooses to model as an entity type best defines:

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

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 best defines:

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

Match each of the following terms with its corresponding definition. -Specifications that preserve the integrity of a conceptual or logical data model.

A plural relationship is a relationship that the data modeler chooses to model as entity type.

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

A collection of entities that share common properties or characteristics defines:

Match each of the following terms with its corresponding definition. -A many-to-many (or one-to-one)relationship that the data modeler chooses to model as an entity type with several associated one-to-many relationships with other entity types.

Book,supplier,and state are entity types.

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

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

Object-Oriented Analysis and Design: Sequence Diagrams

Filters

Exam 8: Structuring System Data Requirements

A __________ is an association between the instances of one or more entity types that is of interest to the organization.

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

Business rules are specifications that preserve the integrity of the physical data model.

Which of the following is a true statement?

During requirements structuring:

A candidate key that has been selected as the unique,identifying characteristic for an entity type is called a(n):

Match each of the following terms with its corresponding definition. -Specifies that an entity instance can simultaneously be a member of two (or more)subtypes.

Match each of the following terms with its corresponding definition. -On E-R diagrams,relationships are labeled with verb phrases.

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

What is the role of CASE in conceptual modeling? What information is placed in the CASE repository during conceptual modeling?

A relationship that the data modeler chooses to model as an entity type best defines:

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

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 best defines:

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

Match each of the following terms with its corresponding definition. -Specifications that preserve the integrity of a conceptual or logical data model.

A plural relationship is a relationship that the data modeler chooses to model as entity type.

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

A collection of entities that share common properties or characteristics defines:

Match each of the following terms with its corresponding definition. -A many-to-many (or one-to-one)relationship that the data modeler chooses to model as an entity type with several associated one-to-many relationships with other entity types.

Book,supplier,and state are entity types.

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

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

Object-Oriented Analysis and Design: Sequence Diagrams

Filters