Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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 B

Question 3

For each entity,the name of the identifier is:

Accepted Answer

A) identified by using a double-lined ellipse 
B) underlined on an E-R diagram 
C) bold on an E-R diagram 
D) written in all capital letters on an E-R diagram 
A) identified by using a double-lined ellipse 
B) underlined on an E-R diagram 
C) bold on an E-R diagram 
D) written in all capital letters on an E-R diagram B

Question 4

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 5

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

Accepted Answer

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

Question 6

Discuss unary,binary,and ternary relationships.Provide an example of each.

Accepted Answer

The number of entity types participating

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Match each of the following terms with its corresponding definition.
-A simultaneous relationship among instances of three 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 9

An __________ is a named property or characteristic of an entity that is of interest to the organization.

Accepted Answer

The answer of An __________ is a named property or...

Question 10

Referential integrity constraints are rules concerning the relationships between entity types.

Accepted Answer

A) True 
 B)False

Question 11

A ternary relationship is the equivalent of three binary relationships.

Accepted Answer

A) True 
 B)False

Question 12

A __________ is a generic entity type that has a relationship with one or more subtypes.

Accepted Answer

The answer of A __________ is a generic entity type...

Question 13

The data manipulation operation (insert,delete,or update)that initiates the operation is called a(n):

Accepted Answer

A) condition 
B) action 
C) user rule 
D) event 
A) condition 
B) action 
C) user rule 
D) event

Question 14

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 15

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 16

A __________ is a relationship between instances of two entity types.

Accepted Answer

The answer of A __________ is a relationship between instances...

Question 17

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 18

What is a triggering operation? What components are included? Provide an example.

Accepted Answer

A triggering operation is an assertion o

Question 19

All of the following are benefits of database patterns and packaged data models EXCEPT:

Accepted Answer

A) purchased models are proven from extensive experience 
B) systems analysis is facilitated 
C) purchased models are very specific 
D) purchased models anticipate future needs 
A) purchased models are proven from extensive experience 
B) systems analysis is facilitated 
C) purchased models are very specific 
D) purchased models anticipate future needs

Question 20

Match each of the following terms with its corresponding definition.
-An attribute that can have more than one value for each entity instance.

Accepted Answer

A) entity 
B) entity type 
C) attribute 
D) multivalued attribute 
E) entity instance
F)supertype
G)subtype 
A) entity 
B) entity type 
C) attribute 
D) multivalued attribute 
E) entity instance
F)supertype
G)subtype

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

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

For each entity,the name of the identifier is:

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.

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

Discuss unary,binary,and ternary relationships.Provide an example of each.

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

Match each of the following terms with its corresponding definition. -A simultaneous relationship among instances of three entity types.

An __________ is a named property or characteristic of an entity that is of interest to the organization.

Referential integrity constraints are rules concerning the relationships between entity types.

A ternary relationship is the equivalent of three binary relationships.

A __________ is a generic entity type that has a relationship with one or more subtypes.

The data manipulation operation (insert,delete,or update)that initiates the operation is called a(n):

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

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

A __________ is a relationship between instances of two entity types.

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

What is a triggering operation? What components are included? Provide an example.

All of the following are benefits of database patterns and packaged data models EXCEPT:

Match each of the following terms with its corresponding definition. -An attribute that can have more than one value for each entity instance.

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

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

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

For each entity,the name of the identifier is:

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.

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

Discuss unary,binary,and ternary relationships.Provide an example of each.

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

Match each of the following terms with its corresponding definition. -A simultaneous relationship among instances of three entity types.

An __________ is a named property or characteristic of an entity that is of interest to the organization.

Referential integrity constraints are rules concerning the relationships between entity types.

A ternary relationship is the equivalent of three binary relationships.

A __________ is a generic entity type that has a relationship with one or more subtypes.

The data manipulation operation (insert,delete,or update)that initiates the operation is called a(n):

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

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

A __________ is a relationship between instances of two entity types.

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

What is a triggering operation? What components are included? Provide an example.

All of the following are benefits of database patterns and packaged data models EXCEPT:

Match each of the following terms with its corresponding definition. -An attribute that can have more than one value for each entity instance.

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