Question 1

Granularity refers to ____.

Accepted Answer

A)   the size of a table
B)   the level of detail represented by the values stored in a table's row
C)   the number of attributes in a table
D)   the number of rows in a tableE) A) and B)
F) A) and C) B

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A)   1NF
B)   2NF
C)   3NF
D)   4NFE) A) and B)
F) C) and D)

Question 4

When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not _________________________.

Accepted Answer

BCNF
Boyce-Codd norm...

Question 5

When designing a database,you should ____.

Accepted Answer

A)   make sure entities are in normal form before table structures are created
B)   create table structures then normalize the database
C)   only normalize the database when performance problems occur
D)   consider more important issues such as performance before normalizingE) A) and B)
F) B) and C)

Question 6

Because a partial dependency can exist only if a table's primary key is composed of several attributes,if a table in 1NF has a single-attribute primary key,then the table is automatically in 2NF.

Accepted Answer

A) True 
 B)False

Question 7

A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y,and X is the primary key.

Accepted Answer

A)   partial dependency
B)   repeating group
C)   atomic attribute
D)   transitive dependencyE) None of the above
F) All of the above D

Question 8

Describe a dependency diagram and explain its purpose.

Accepted Answer

Dependency diagrams are very helpful in ...

Question 9

Normalization is a process that is used for changing attributes to entities.

Accepted Answer

A) True 
 B)False

Question 10

Data redundancies occur from ____________________ of data on every row entry.

Accepted Answer

duplicatio...

Question 11

A table that is in 2NF and contains no transitive dependencies is said to be in ____.

Accepted Answer

A)   1NF
B)   2NF
C)   3NF
D)   4NFE) A) and B)
F) B) and C) C

Question 12

Of the following normal forms,____ is mostly of theoretical interest.

Accepted Answer

A)   1NF
B)   3NF
C)   BCNF
D)   DKNFE) B) and C)
F) A) and B)

Question 13

Explain normalization and its different forms.

Accepted Answer

Normalization is a process for evaluatin...

Question 14

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

Accepted Answer

A) True 
 B)False

Question 15

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 16

A relational table must not contain a(n) ____.

Accepted Answer

A)   entity
B)   attribute
C)   relationship
D)   repeating groupE) B) and D)
F) B) and C)

Question 17

Normalization works through a series of stages called normal forms.For most purposes in business database design,____ stages are as high as you need to go in the normalization process.

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) B) and D)
F) All of the above

Question 18

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 19

From a structural point of view,2NF is better than ____.

Accepted Answer

A)   1NF
B)   3NF
C)   4NF
D)   BCNFE) B) and C)
F) B) and D)

Question 20

Normalization should be part of the design process.

Accepted Answer

A) True 
 B)False

Exam 6: Normalization of Database Tables

Granularity refers to ____.

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not _________________________.

Correct AnswerverifiedBCNFBoyce-Codd norm...View AnswerShow Answer

When designing a database,you should ____.

Correct AnswerverifiedShow Answer

Because a partial dependency can exist only if a table's primary key is composed of several attributes,if a table in 1NF has a single-attribute primary key,then the table is automatically in 2NF.

Correct AnswerverifiedShow Answer

A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y,and X is the primary key.

Correct AnswerverifiedD

Describe a dependency diagram and explain its purpose.

Correct AnswerverifiedDependency diagrams are very helpful in ...View AnswerShow Answer

Normalization is a process that is used for changing attributes to entities.

Correct AnswerverifiedShow Answer

Data redundancies occur from ____________________ of data on every row entry.

Correct Answerverifiedduplicatio...View AnswerShow Answer

A table that is in 2NF and contains no transitive dependencies is said to be in ____.

Correct AnswerverifiedC

Of the following normal forms,____ is mostly of theoretical interest.

Correct AnswerverifiedShow Answer

Explain normalization and its different forms.

Correct AnswerverifiedNormalization is a process for evaluatin...View AnswerShow Answer

The advantage of higher processing speed must be carefully weighed against the disadvantage of data anomalies.

Correct AnswerverifiedShow Answer

Dependencies that are based on only a part of a composite primary key are called transitive dependencies.

Correct AnswerverifiedShow Answer

A relational table must not contain a(n) ____.

Correct AnswerverifiedShow Answer

Normalization works through a series of stages called normal forms.For most purposes in business database design,____ stages are as high as you need to go in the normalization process.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

From a structural point of view,2NF is better than ____.

Correct AnswerverifiedShow Answer

Normalization should be part of the design process.

Correct AnswerverifiedShow Answer

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
BCNF
Boyce-Codd norm...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified
Dependency diagrams are very helpful in ...
View Answer

Correct Answer
verified

Correct Answer
verified
duplicatio...
View Answer

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified
Normalization is a process for evaluatin...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified