Chapter 6

Question 1

A table that displays data redundancies yields _____.

a) fewer attributes
b) anomalies
c) consistencies
d) more entities

Answer 1

b) anomalies

Question 2

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

a) candidate
b) secondary
c) primary
d) foreign

Answer 2

a) candidate

Question 3

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 are stored in the table as rows.

a) temporary
b) 3NF
c) component
d) transitive

Answer 3

a) temporary

Question 4

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

A) true
B) false

Answer 4

B) false

Question 5

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

A) true
B) false

Answer 5

A) true

Question 6

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

a) sequence
b) AutoNumber
c) identity
d) character

Answer 6

b) AutoNumber

Question 7

Atomic attributes are attributes that can be further subdivided.

A) true
B) false

Answer 7

B) false

Question 8

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.

a) owns
b) determines
c) derives from
d) controls

Answer 8

b) determines

Question 9

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

A) true
B) false

Answer 9

B) false

Question 10

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

A) true
B) false

Answer 10

B) false

Question 11

An attribute that is part of a key is known as a(n) _____ attribute.

a) nonprime
b) prime
c) entity
d) important

Answer 11

b) prime

Question 12

For most business transactional databases, we should normalize relations into _____.

a) 1NF
b) 2NF
c) 3NF
d) 6NF

Answer 12

c) 3NF

Question 13

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

A) true
B) false

Answer 13

A) true

Question 14

Repeating groups must be eliminated by ensuring that each row defines a single entity.

A) true
B) false

Answer 14

A) true

Question 15

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

A) true
B) false

Answer 15

A) true

Question 16

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

a) BCNF
b) 3NF
c) 4NF
d) 1NF

Answer 16

d) 1NF

Question 17

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

A) true
B) false

Answer 17

B) false

Question 18

An atomic attribute _____.

a) displays multiplicity
b) cannot exist in a relational table
c) is always chosen to be a foreign key
d) cannot be further subdivided

Answer 18

d) cannot be further subdivided

Question 19

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

A) true
B) false

Answer 19

B) false

Question 20

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

A) true
B) false

Answer 20

A) true