Question 1

According to naming conventions described in Chapter 2,____ would be the best name for a column representing the charges per hour in a table named JOB.

Accepted Answer

A)  JOB_CHG_HOUR 
B)  CHARGES_PER_HOUR_FOR_JOB 
C)  CHARGES_PER_HOUR 
D)  CHG_HR

Question 2

Improving ____ leads to more flexible queries.

Accepted Answer

A)  atomicity 
B)  normalization 
C)  denormalization 
D)  derived attributes

Question 3

The conflicts between design efficiency,information requirements,and processing speed are often resolved through ____.

Accepted Answer

A)  conversion from 1NF to 2NF 
B)  conversion from 2NF to 3NF 
C)  compromises that include denormalization 
D)  conversion from 3NF to 4NF

Question 4

A table that is in 1NF and includes no partial dependencies is said to be in ____.

Accepted Answer

A)  BCNF 
B)  2NF 
C)  3NF 
D)  4NF

Question 5

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

Accepted Answer

A) True 
 B)False

Question 6

Any attribute that is at least part of a key is known as a(n)____________________.

Accepted Answer

The answer of Any attribute that is at least part...

Question 7

A relational table must not contain ____________________ groups.

Accepted Answer

The answer of A relational table must not contain ____________________...

Question 8

To generate a surrogate key,Microsoft Access uses a(n)____ data type.

Accepted Answer

A)  surrogate 
B)  sequence 
C)  AutoNumber 
D)  identity

Question 9

The combination of normalization and ER modeling yields a useful ERD,whose entities may now be translated into appropriate relationship structures.

Accepted Answer

A) True 
 B)False

Question 10

____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

Accepted Answer

A)  Normalized 
B)  Data warehouse 
C)  Temporary 
D)  Report

Question 11

A good relational DBMS excels at managing denormalized relations.

Accepted Answer

A) True 
 B)False

Question 12

A table is in BCNF if every determinant in the table is a foreign key.

Accepted Answer

A) True 
 B)False

Question 13

A table where every determinant is a candidate key is said to be in ____.

Accepted Answer

A)  BCNF 
B)  2NF 
C)  3NF 
D)  4NF

Question 14

____________________ is a process to help reduce the likelihood of data anomalies.

Accepted Answer

The answer of ____________________ is a process to help reduce...

Question 15

An example of denormalization is using a ____ denormalized table to hold report data.This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.

Accepted Answer

A)  transitive 
B)  3NF 
C)  component 
D)  temporary

Question 16

In a real-world environment,we must strike a balance between design integrity and ____.

Accepted Answer

A)  robustness 
B)  flexibility 
C)  uniqueness 
D)  ease of use

Question 17

Converting a database format from 1NF to 2NF is a complex process.

Accepted Answer

A) True 
 B)False

Question 18

In order to meet performance requirements,you may have to denormalize portions of the database design.

Accepted Answer

A) True 
 B)False

Question 19

Relational models view the data as part of a table or collection of tables in which all key values must be identified.

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.

Accepted Answer

The answer of The ____________________ provides the big picture,or macro...

Exam 6: Normalization of Database Tables

According to naming conventions described in Chapter 2,____ would be the best name for a column representing the charges per hour in a table named JOB.

Improving ____ leads to more flexible queries.

The conflicts between design efficiency,information requirements,and processing speed are often resolved through ____.

A table that is in 1NF and includes no partial dependencies is said to be in ____.

A dependency of one nonprime attribute on another nonprime attribute is a partial dependency.

Any attribute that is at least part of a key is known as a(n)____________________.

A relational table must not contain ____________________ groups.

To generate a surrogate key,Microsoft Access uses a(n) ____ data type.

The combination of normalization and ER modeling yields a useful ERD,whose entities may now be translated into appropriate relationship structures.

____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

A good relational DBMS excels at managing denormalized relations.

A table is in BCNF if every determinant in the table is a foreign key.

A table where every determinant is a candidate key is said to be in ____.

____________________ is a process to help reduce the likelihood of data anomalies.

An example of denormalization is using a ____ denormalized table to hold report data.This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.

In a real-world environment,we must strike a balance between design integrity and ____.

Converting a database format from 1NF to 2NF is a complex process.

In order to meet performance requirements,you may have to denormalize portions of the database design.

Relational models view the data as part of a table or collection of tables in which all key values must be identified.

The ____________________ provides the big picture,or macro view,of an organization's data requirements and operations.