Question 1

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

Accepted Answer

A) True 
 B)False

Question 2

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) A) and C)
F) A) and B)

Question 3

The conflicts between design efficiency, information requirements, and performance are often resolved through_____.

Accepted Answer

A)   compromises that include normalization
B)   conversion from 2NF to 3NF
C)   compromises that include denormalization
D)   conversion from 3NF to 4NFE) A) and B)
F) C) and D)

Question 4

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have based on this composite candidate key even when the primary key chosen is a single attribute.

Accepted Answer

A)   Boyce-Codd normal forms
B)   redundancies
C)   time-variances
D)   partial dependenciesE) A) and B)
F) A) and C)

Question 5

Explain how database designers design and normalize databases.

Accepted Answer

First, an ERD is created through an iter...

Question 6

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

Accepted Answer

A)   BCNF
B)   2NF
C)   1NF
D)   4NFE) A) and D)
F) None of the above

Question 7

Since 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 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

Normalization represents a micro view of the entities within the ERD.

Accepted Answer

A) True 
 B)False

Exam 6: Normalization of Database Tables

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

Correct Answer
verified

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

Correct Answer
verified

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

Correct Answer
verified

Since 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 Answer
verified

Explain how database designers design and normalize databases.

Correct Answer
verified
First, an ERD is created through an iter...
View Answer

The conflicts between design efficiency, information requirements, and performance are often resolved through_____.

Correct Answer
verified

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 Answer
verified

Normalization represents a micro view of the entities within the ERD.

Correct Answer
verified

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have based on this composite candidate key even when the primary key chosen is a single attribute.

Correct Answer
verified

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

Correct Answer
verified

Exam 6: Normalization of Database Tables

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

It is possible for a table in 2NF to exhibit transitive dependency, where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes.

Correct AnswerverifiedShow Answer

Since 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

Explain how database designers design and normalize databases.

Correct AnswerverifiedFirst, an ERD is created through an iter...View AnswerShow Answer

The conflicts between design efficiency, information requirements, and performance are often resolved through_____.

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

Normalization represents a micro view of the entities within the ERD.

Correct AnswerverifiedShow Answer

If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have based on this composite candidate key even when the primary key chosen is a single attribute.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
First, an ERD is created through an iter...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified