Chapter 5: Database Design 1: Normalization True / False: Cengage Learning Testing, Powered by Cognero
Chapter 5: Database Design 1: Normalization True / False: Cengage Learning Testing, Powered by Cognero
Chapter 5: Database Design 1: Normalization True / False: Cengage Learning Testing, Powered by Cognero
True / False
a. True
b. False
ANSWER:
True
POINTS:
1
REFERENCES: 156
contain problems.
a. True
b. False
ANSWER:
False
POINTS:
1
REFERENCES: 160
11. The most recent definition of third normal form
ANSWER:
a
POINTS:
1
REFERENCES: 149
b. alternate keys
c. nonkey attributes
d. contributory keys
ANSWER:
b
POINTS:
1
REFERENCES: 155
26. From all the ____ keys, one is chosen to be the
primary key.
a. alternate
b. candidate
c. functional
d. normal
ANSWER:
b
POINTS:
1
REFERENCES: 155
27. Which of the followingcontains a repeating group?
a. Orders (OrderNum, OrderDate, (ItemNum,
NumOrdered) )
b. Orders (OrderNum, OrderDate, ItemNum,
NumOrdered )
c. Orders (OrderNum, OrderDate)
d. Orders (OrderNum, ItemNum,
NumOrdered )
ANSWER:
a
POINTS:
1
REFERENCES: 155-156
28. A column is a nonkey column if it is ____.
a. in first normal form
b. in second normal form
c. a part of the primary key
d. not a part of the primary key
ANSWER:
d
POINTS:
1
REFERENCES: 157
29. Another name for a nonkey column is a ____.
a. nonkey attribute
b. key attribute
c. nonkey row
d. key table
ANSWER:
a
POINTS:
1
Page 3
a. determines
b. multidetermines
c. defines
d. identifies
ANSWER:
b
POINTS:
1
REFERENCES: 169
35. The conversion of an unnormalized table to first
normal form requires the removal of ____.
a. determinants
b. interrelation constraints
c. nonkey columns
d. repeating groups
ANSWER:
d
POINTS:
1
REFERENCES: 171
Completion
36. The ____________________ process enables you to
identify the existence of potential problems in the design
of a database.
ANSWER:
normalization
POINTS:
1
REFERENCES: 149
37. A column B is ____________________ on
1st
POINTS:
1
REFERENCES: 157
39. A column is a nonkey column if it is not a part of the
____________________.
ANSWER:
primary key
POINTS:
1
REFERENCES: 157
Page 4
ANSWER:
Normalization is a progression in
which a table that is in first normal
form is better (freer from problems)
than a table that is not in first
normal form, a table that is in
second normal form is better than
one that is in first normal form, and
so on. The goal of normalization is
to take a table or collection of tables
and produce a new collection of
tables that represents the same
information but that is free of
update anomalies.
POINTS:
1
REFERENCES: 149
47. Discuss what normal forms are and list the most
is a column or a collection of
columns on which all columns in
the table are functionally dependent;
the definition for primary key also
defines a candidate key. From all
the candidate keys, one is chosen to
be the primary key. The candidate
keys that are not chosen as the
primary key are often referred to as
alternate keys.
POINTS:
1
REFERENCES: 155
Page 5
Page 6