Question 1

The most likely data type for a surrogate key is ____.

Accepted Answer

A)   Character
B)   Date
C)   Logical
D)   NumericE) All of the above
F) None of the above

Question 2

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ____________________ keys.

Accepted Answer

The answer of In a real-world environment, changing granularity requirements...

Question 3

In a(n)  ____ diagram, the arrows above the attributes indicate all desirable dependencies.

Accepted Answer

A)   Chen
B)   dependency
C)   functionality
D)   ERE) A) and C)
F) A) and D)

Question 4

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

Accepted Answer

A)   primary
B)   partial
C)   incomplete
D)   compositeE) A) and D)
F) C) and D)

Question 5

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

Accepted Answer

A) True 
 B)False  True

Question 6

A determinant is any attribute whose value determines other values within a column.

Accepted Answer

A) True 
 B)False

Question 7

Data redundancy produces ____.

Accepted Answer

A)   slower lookups
B)   robust design
C)   efficient storage use
D)   data integrity problemsE) All of the above
F) C) and D)

Question 8

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

Accepted Answer

A)   entities
B)   attributes
C)   relationships
D)   formsE) A) and D)
F) B) and D)

Question 9

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 4NFE) A) and B)
F) B) and D)

Question 10

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 11

A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.

Accepted Answer

The answer of A(n) ____________________ derives its name from the...

Question 12

BCNF can be violated only if the table contains more than one ____ key.

Accepted Answer

A)   primary
B)   candidate
C)   foreign
D)   secondaryE) C) and D)
F) A) and B) B

Question 13

Normalization produces a lower normal form.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False  False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Before converting a table into 3NF, it is imperative the table already be in ____.

Accepted Answer

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

Question 18

Dependencies can be identified with the help of a dependency ____________________.

Accepted Answer

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

Question 19

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

Question 20

Some very specialized applications may require normalization beyond the ____.

Accepted Answer

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

Exam 9: Normalizing Database Designs

The most likely data type for a surrogate key is ____.

Correct AnswerverifiedShow Answer

In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of ____________________ keys.

Correct AnswerverifiedShow Answer

In a(n) ____ diagram, the arrows above the attributes indicate all desirable dependencies.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedTrue

A determinant is any attribute whose value determines other values within a column.

Correct AnswerverifiedShow Answer

Data redundancy produces ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.

Correct AnswerverifiedShow Answer

BCNF can be violated only if the table contains more than one ____ key.

Correct AnswerverifiedB

Normalization produces a lower normal form.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Before converting a table into 3NF, it is imperative the table already be in ____.

Correct AnswerverifiedShow Answer

Dependencies can be identified with the help of a dependency ____________________.

Correct AnswerverifiedShow Answer

A(n) ____ 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 AnswerverifiedShow Answer

Some very specialized applications may require normalization beyond the ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified