Question 1

A true data entity will have many possible instances,each with a distinguishing characteristic,as well as one or more other descriptive pieces of data.

Accepted Answer

A) True 
 B)False

Question 2

Contrast data modeling to process modeling and logic modeling.

Accepted Answer

Data modeling,process modeling,and logic

Question 3

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

Accepted Answer

A) True 
 B)False

Question 4

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 5

A detailed,logical representation of the entities,associations,and data elements for an organization or business area defines:

Accepted Answer

A) entity-relationship diagram 
B) conceptual model 
C) entity-relationship model 
D) data flow diagram 
A) entity-relationship diagram 
B) conceptual model 
C) entity-relationship model 
D) data flow diagram

Question 6

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 7

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

Accepted Answer

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

Question 8

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 9

The __________ specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.

Accepted Answer

The answer of The __________ specifies that if an entity...

Question 10

Which of the following specifies that an entity instance can simultaneously be a member of two (or more)subtypes?

Accepted Answer

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

Question 11

Match each of the following terms with its corresponding definition.
-A set of two or more multivalued attributes that are logically related.

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 12

A __________ is an attribute that may take on more than one value for each entity instance.

Accepted Answer

multivalue

Question 13

Analysts should use intelligent keys as identifiers.

Accepted Answer

A) True 
 B)False

Question 14

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

Accepted Answer

A) True 
 B)False

Question 15

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 16

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

Accepted Answer

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

Question 17

Match each of the following terms with its corresponding definition.
-A recursive relationship is a relationship between the instances of two 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 18

Match each of the following terms with its corresponding definition.
-Specifies that an entity instance of the supertype is allowed not to belong to any subtype.

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 19

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 20

Match each of the following terms with its corresponding definition.
-A relationship between instances of two 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

A true data entity will have many possible instances,each with a distinguishing characteristic,as well as one or more other descriptive pieces of data.

Contrast data modeling to process modeling and logic modeling.

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

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

A detailed,logical representation of the entities,associations,and data elements for an organization or business area defines:

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

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

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

The __________ specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.

Which of the following 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. -A set of two or more multivalued attributes that are logically related.

A __________ is an attribute that may take on more than one value for each entity instance.

Analysts should use intelligent keys as identifiers.

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

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.

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

Match each of the following terms with its corresponding definition. -A recursive relationship is a relationship between the instances of two entity types.

Match each of the following terms with its corresponding definition. -Specifies that an entity instance of the supertype is allowed not to belong to any subtype.

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.

Match each of the following terms with its corresponding definition. -A relationship between instances of two 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 true data entity will have many possible instances,each with a distinguishing characteristic,as well as one or more other descriptive pieces of data.

Contrast data modeling to process modeling and logic modeling.

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

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

A detailed,logical representation of the entities,associations,and data elements for an organization or business area defines:

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

Which of the following specifies that an entity instance of the supertype is allowed not to belong to any subtype?

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

The __________ specifies that if an entity instance of the supertype is a member of one subtype,it cannot simultaneously be a member of any other subtype.

Which of the following 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. -A set of two or more multivalued attributes that are logically related.

A __________ is an attribute that may take on more than one value for each entity instance.

Analysts should use intelligent keys as identifiers.

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

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.

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

Match each of the following terms with its corresponding definition. -A recursive relationship is a relationship between the instances of two entity types.

Match each of the following terms with its corresponding definition. -Specifies that an entity instance of the supertype is allowed not to belong to any subtype.

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.

Match each of the following terms with its corresponding definition. -A relationship between instances of two 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