Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Processes,rather than data,are the most complex aspects of many modern information systems.

Accepted Answer

A) True 
 B)False

Question 3

Define domains for the following attributes: GPA,rank,and age.

Accepted Answer

A student's GPA is numeric with two deci

Question 4

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

Accepted Answer

A) True 
 B)False

Question 5

An __________ is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.

Accepted Answer

entity-rel

Question 6

Employee identification number,name,address,and skill are attributes.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Match each of the following terms with its corresponding definition.
-A relationship between the instances of one entity type.

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

Match each of the following terms with its corresponding definition.
-A named property or characteristic of an entity that is of interest to the organization.

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

Question 10

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams.

Accepted Answer

A) True 
 B)False

Question 11

Relationships are labeled with verb phrases.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following addresses the rules concerning the relationships between entity types?

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 13

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Entity integrity means each instance of an entity type must have a unique identifier that is not null.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Question 19

Briefly identify four important business rules for supertype/subtype relationships.

Accepted Answer

Total specialization,partial specializat

Question 20

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

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

Processes,rather than data,are the most complex aspects of many modern information systems.

Define domains for the following attributes: GPA,rank,and age.

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

An __________ is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.

Employee identification number,name,address,and skill are attributes.

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

Match each of the following terms with its corresponding definition. -A relationship between the instances of one entity type.

Match each of the following terms with its corresponding definition. -A named property or characteristic of an entity that is of interest to the organization.

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams.

Relationships are labeled with verb phrases.

Which of the following addresses the rules concerning the relationships between entity types?

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

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

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.

Entity integrity means each instance of an entity type must have a unique identifier that is not null.

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

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

Briefly identify four important business rules for supertype/subtype relationships.

When selecting an identifier,one should:

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

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

Processes,rather than data,are the most complex aspects of many modern information systems.

Define domains for the following attributes: GPA,rank,and age.

The minimum cardinality of a relationship is the minimum number of instances of entity B that may be associated with each instance of entity A.

An __________ is a detailed,logical representation of the entities,associations,and data elements for an organization or business area.

Employee identification number,name,address,and skill are attributes.

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

Match each of the following terms with its corresponding definition. -A relationship between the instances of one entity type.

Match each of the following terms with its corresponding definition. -A named property or characteristic of an entity that is of interest to the organization.

The names of data stores on primitive-level data flow diagrams often correspond to the names of data entities in entity-relationship diagrams.

Relationships are labeled with verb phrases.

Which of the following addresses the rules concerning the relationships between entity types?

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

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

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.

Entity integrity means each instance of an entity type must have a unique identifier that is not null.

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

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

Briefly identify four important business rules for supertype/subtype relationships.

When selecting an identifier,one should:

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