Question 1

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

Accepted Answer

A) True 
 B)False

Question 2

yields better performance.

Accepted Answer

A)  Denormalization 
B)  Normalization 
C)  Atomization 
D)  Compression

Question 3

In the , no row may contain two or more multivalued facts about an entity.

Accepted Answer

The answer of In the , no row may contain...

Question 4

Normalization is a very important database design ingredient, and the highest level is always the most desirable.

Accepted Answer

A) True 
 B)False

Question 5

A dependency based on only a part of a composite primary key is called a .

Accepted Answer

The answer of A dependency based on only a part...

Question 6

Data redundancy produces data anomalies.

Accepted Answer

A) True 
 B)False

Question 7

Dependencies can be identified with the help of a dependency .

Accepted Answer

The answer of Dependencies can be identified with the help...

Question 8

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

Accepted Answer

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

Question 9

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 10

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

Accepted Answer

A) True 
 B)False

Question 11

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

Accepted Answer

A) True 
 B)False

Question 12

A relational table must not contain a(n) .

Accepted Answer

A)  entity 
B)  attribute 
C)  relationship 
D)  repeating group

Question 13

Normalization purity is often easy to sustain in the modern database environment.

Accepted Answer

A) True 
 B)False

Question 14

A(n) exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key.

Accepted Answer

A)  atomic attribute 
B)  repeating group 
C)  partial dependency 
D)  transitive dependency

Question 15

Attribute A attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Accepted Answer

A)  determines 
B)  derives from 
C)  controls 
D)  owns

Question 16

The price paid for increased performance through denormalization is a larger amount of .

Accepted Answer

The answer of The price paid for increased performance through...

Question 17

The problem with transitive dependencies is that they still yield data .

Accepted Answer

The answer of The problem with transitive dependencies is that...

Question 18

Atomic attributes are attributes that can be further subdivided.

Accepted Answer

A) True 
 B)False

Question 19

Most designers consider the BCNF as a special case of the .

Accepted Answer

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

Question 20

In order to meet requirements, you may have to denormalize some portions of a database design.

Accepted Answer

The answer of In order to meet requirements, you may...

Exam 6: Normalization of Database Tables

The objective of normalization is to ensure that each table conforms to the concept of well-formed relations.

yields better performance.

In the , no row may contain two or more multivalued facts about an entity.

Normalization is a very important database design ingredient, and the highest level is always the most desirable.

A dependency based on only a part of a composite primary key is called a .

Data redundancy produces data anomalies.

Dependencies can be identified with the help of a dependency .

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

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

Dependency diagrams are very helpful in getting a bird's-eye view of all the relationships among a table's attributes.

A table is in fourth normal form if it is in third normal form and has no independent multivalued dependencies.

A relational table must not contain a(n) .

Normalization purity is often easy to sustain in the modern database environment.

A(n) exists when there are functional dependencies such that XY is functionally dependent on WZ, X is functionally dependent on W, and XY is the primary key.

Attribute A attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

The price paid for increased performance through denormalization is a larger amount of .

The problem with transitive dependencies is that they still yield data .

Atomic attributes are attributes that can be further subdivided.

Most designers consider the BCNF as a special case of the .

In order to meet requirements, you may have to denormalize some portions of a database design.