Question 1

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

Accepted Answer

The answer of An __________ is a candidate key that...

Question 2

Match each of the following terms with its corresponding definition.
-A singular noun is used to name 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 3

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

Accepted Answer

A) True 
 B)False

Question 4

A faculty identification number can serve as an identifier.

Accepted Answer

A) True 
 B)False

Question 5

One way to handle repeating data within an entity is to separate the repeating data into another entity,called a weak entity.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Match each of the following terms with its corresponding definition.
-To illustrate a multivalued attribute,enclose it in curly brackets.

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.
-A generic entity type that has a relationship with one or more subtypes.

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 9

Match each of the following terms with its corresponding definition.
-To illustrate a multivalued attribute,separate the repeating data into another entity,then using a relationship,link the weak entity to its associated regular entity.

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 10

Match each of the following terms with its corresponding definition.
-The name of the identifier of each entity is underlined on an E-R diagram.

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 11

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

Referencing an employee entity,an employee's skills are a multivalued attribute.

Accepted Answer

A) True 
 B)False

Question 13

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository

Accepted Answer

A) True 
 B)False

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

Match each of the following terms with its corresponding definition. -A singular noun is used to name an entity type.

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

A faculty identification number can serve as an identifier.

One way to handle repeating data within an entity is to separate the repeating data into another entity,called a weak entity.

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

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,enclose it in curly brackets.

Match each of the following terms with its corresponding definition. -A generic entity type that has a relationship with one or more subtypes.

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,separate the repeating data into another entity,then using a relationship,link the weak entity to its associated regular entity.

Match each of the following terms with its corresponding definition. -The name of the identifier of each entity is underlined on an E-R diagram.

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.

Referencing an employee entity,an employee's skills are a multivalued attribute.

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository

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

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

Match each of the following terms with its corresponding definition. -A singular noun is used to name an entity type.

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

A faculty identification number can serve as an identifier.

One way to handle repeating data within an entity is to separate the repeating data into another entity,called a weak entity.

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

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,enclose it in curly brackets.

Match each of the following terms with its corresponding definition. -A generic entity type that has a relationship with one or more subtypes.

Match each of the following terms with its corresponding definition. -To illustrate a multivalued attribute,separate the repeating data into another entity,then using a relationship,link the weak entity to its associated regular entity.

Match each of the following terms with its corresponding definition. -The name of the identifier of each entity is underlined on an E-R diagram.

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.

Referencing an employee entity,an employee's skills are a multivalued attribute.

A deliverable from conceptual data modeling is a set of entries about data objects to be stored in the project dictionary or repository

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