Question 1

Match each of the following terms with its corresponding definition.
-A single occurrence of an entity type.

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 2

If STUDENT and COURSE participate in a relationship,their relationship is a(n):

Accepted Answer

A) unary relationship 
B) binary relationship 
C) ternary relationship 
D) extraordinary relationship 
A) unary relationship 
B) binary relationship 
C) ternary relationship 
D) extraordinary relationship

Question 3

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

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 4

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 5

Match each of the following terms with its corresponding definition.
-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) 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 6

An __________ is a single occurrence of an entity type.

Accepted Answer

The answer of An __________ is a single occurrence of...

Question 7

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

Accepted Answer

A) True 
 B)False

Question 8

The most common format used for data modeling is:

Accepted Answer

A) state-transition diagramming 
B) entity-relationship diagramming 
C) process modeling 
D) decision table diagramming 
A) state-transition diagramming 
B) entity-relationship diagramming 
C) process modeling 
D) decision table diagramming

Question 9

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 10

A __________ is a simultaneous relationship among instances of three entity types.

Accepted Answer

ternary re

Question 11

Match each of the following terms with its corresponding definition.
-Upper- and lower-case letters are used in naming an 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 12

Which of the following refers to an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete?

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

A single occurrence of an entity type defines:

Accepted Answer

A) entity instance 
B) entity appearance 
C) attribute 
D) data element 
A) entity instance 
B) entity appearance 
C) attribute 
D) data element

Question 14

An order number is a good example of a candidate key.

Accepted Answer

A) True 
 B)False

Question 15

What are multivalued attributes and repeating groups? Provide an example of each.

Accepted Answer

A multivalued attribute is an attribute

Question 16

Universal data models and industry-specific data models are two types of packaged conceptual data models.

Accepted Answer

A) True 
 B)False

Question 17

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business,rather than from any specific information requirements in screens,reports,or business forms,is referred to as the:

Accepted Answer

A) top-down approach 
B) bottom-up approach 
C) overview approach 
D) business approach 
A) top-down approach 
B) bottom-up approach 
C) overview approach 
D) business approach

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Match each of the following terms with its corresponding definition.
-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

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 20

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

Match each of the following terms with its corresponding definition. -A single occurrence of an entity type.

If STUDENT and COURSE participate in a relationship,their relationship is a(n):

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

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

Match each of the following terms with its corresponding definition. -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.

An __________ is a single occurrence of an entity type.

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

The most common format used for data modeling is:

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 __________ is a simultaneous relationship among instances of three entity types.

Match each of the following terms with its corresponding definition. -Upper- and lower-case letters are used in naming an entity type.

Which of the following refers to an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete?

A single occurrence of an entity type defines:

An order number is a good example of a candidate key.

What are multivalued attributes and repeating groups? Provide an example of each.

Universal data models and industry-specific data models are two types of packaged conceptual data models.

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business,rather than from any specific information requirements in screens,reports,or business forms,is referred to as the:

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

Match each of the following terms with its corresponding definition. -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 attribute that may take on more than one value for each entity instance is referred to as a:

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

Match each of the following terms with its corresponding definition. -A single occurrence of an entity type.

If STUDENT and COURSE participate in a relationship,their relationship is a(n):

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

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

Match each of the following terms with its corresponding definition. -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.

An __________ is a single occurrence of an entity type.

The purpose of the conceptual data model is to show as many rules about the meaning and interrelationships among data as possible.

The most common format used for data modeling is:

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 __________ is a simultaneous relationship among instances of three entity types.

Match each of the following terms with its corresponding definition. -Upper- and lower-case letters are used in naming an entity type.

Which of the following refers to an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete?

A single occurrence of an entity type defines:

An order number is a good example of a candidate key.

What are multivalued attributes and repeating groups? Provide an example of each.

Universal data models and industry-specific data models are two types of packaged conceptual data models.

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business,rather than from any specific information requirements in screens,reports,or business forms,is referred to as the:

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

Match each of the following terms with its corresponding definition. -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 attribute that may take on more than one value for each entity instance is referred to as a:

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