Question 1

File and database design occurs in two steps.

Accepted Answer

A) True 
 B)False

Question 2

Match each of the following terms with its corresponding definition.
-A value a field will assume unless an explicit value is entered for that field.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 3

A __________ is a foreign key in a relation that references the primary key values of that same relation.

Accepted Answer

recursive

Question 4

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

Accepted Answer

A) True 
 B)False

Question 5

A __________ is a coding scheme recognized by system software for representing organizational data.

Accepted Answer

The answer of A __________ is a coding scheme recognized...

Question 6

Match each of the following terms with its corresponding definition.
-A relation is in this form if every nonprimary key attribute is functionally dependent on the whole primary key.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation

Question 7

Match each of the following terms with its corresponding definition.
-The process of converting complex data structures into simple,stable data structures.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation

Question 8

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

Accepted Answer

A) first normal form 
B) second normal form 
C) Boyce-Codd normal form 
D) third normal form 
A) first normal form 
B) second normal form 
C) Boyce-Codd normal form 
D) third normal form

Question 9

An __________ is a table used to determine the location of rows in a file that satisfy some condition.

Accepted Answer

The answer of An __________ is a table used to...

Question 10

A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete rows without errors or inconsistencies is a(n):

Accepted Answer

A) independent relation 
B) simple relation 
C) unnormalized relation 
D) well-structured relation 
A) independent relation 
B) simple relation 
C) unnormalized relation 
D) well-structured relation

Question 11

A __________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

Accepted Answer

The answer of A __________ is an attribute that appears...

Question 12

Match each of the following E-R structures with its relational representation.
-Create a relation with the primary key associated with the relationship or associative entity,plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities.

Accepted Answer

A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key 
A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question 13

A field of data that can be used to locate a related field or row of data best describes:

Accepted Answer

A) pointer 
B) marker 
C) field locator 
D) reference locator 
A) pointer 
B) marker 
C) field locator 
D) reference locator

Question 14

Normalization is based on an analysis of weak entities.

Accepted Answer

A) True 
 B)False

Question 15

Each column in a relation corresponds to an entity type.

Accepted Answer

A) True 
 B)False

Question 16

Transitive attributes are attributes that determine other attributes.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following statements is true regarding normalization?

Accepted Answer

A) Normalization is a top-down process. 
B) Normalization produces a set of well-structured relations that contain all of the data mentioned in system inputs and outputs. 
C) Through the use of anomalies,stable structures are produced. 
D) Normalization is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation. 
A) Normalization is a top-down process. 
B) Normalization produces a set of well-structured relations that contain all of the data mentioned in system inputs and outputs. 
C) Through the use of anomalies,stable structures are produced. 
D) Normalization is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Question 18

Outline the four key steps in logical database modeling and design.

Accepted Answer

The four key steps in logical database m

Question 19

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Accepted Answer

A) represent entities 
B) represent relationships 
C) normalize the relations 
D) denormalize the relations 
A) represent entities 
B) represent relationships 
C) normalize the relations 
D) denormalize the relations

Question 20

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

Accepted Answer

A) True 
 B)False

File and database design occurs in two steps.

Match each of the following terms with its corresponding definition. -A value a field will assume unless an explicit value is entered for that field.

A __________ is a foreign key in a relation that references the primary key values of that same relation.

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

A __________ is a coding scheme recognized by system software for representing organizational data.

Match each of the following terms with its corresponding definition. -A relation is in this form if every nonprimary key attribute is functionally dependent on the whole primary key.

Match each of the following terms with its corresponding definition. -The process of converting complex data structures into simple,stable data structures.

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

An __________ is a table used to determine the location of rows in a file that satisfy some condition.

A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete rows without errors or inconsistencies is a(n):

A __________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

Match each of the following E-R structures with its relational representation. -Create a relation with the primary key associated with the relationship or associative entity,plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities.

A field of data that can be used to locate a related field or row of data best describes:

Normalization is based on an analysis of weak entities.

Each column in a relation corresponds to an entity type.

Transitive attributes are attributes that determine other attributes.

Which of the following statements is true regarding normalization?

Outline the four key steps in logical database modeling and design.

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

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

Structuring System Data Requirements

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 9: Designing Databases

File and database design occurs in two steps.

Match each of the following terms with its corresponding definition. -A value a field will assume unless an explicit value is entered for that field.

A __________ is a foreign key in a relation that references the primary key values of that same relation.

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

A __________ is a coding scheme recognized by system software for representing organizational data.

Match each of the following terms with its corresponding definition. -A relation is in this form if every nonprimary key attribute is functionally dependent on the whole primary key.

Match each of the following terms with its corresponding definition. -The process of converting complex data structures into simple,stable data structures.

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

An __________ is a table used to determine the location of rows in a file that satisfy some condition.

A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete rows without errors or inconsistencies is a(n):

A __________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

Match each of the following E-R structures with its relational representation. -Create a relation with the primary key associated with the relationship or associative entity,plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities.

A field of data that can be used to locate a related field or row of data best describes:

Normalization is based on an analysis of weak entities.

Each column in a relation corresponds to an entity type.

Transitive attributes are attributes that determine other attributes.

Which of the following statements is true regarding normalization?

Outline the four key steps in logical database modeling and design.

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

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

Structuring System Data Requirements

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