Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Chapter 5: Database Design 1: Normalization
True / False
1. A table that is in first normal form is better than one that is in second normal form.
a.
True
b.
False
2. To correct update anomalies in a database, tables must be converted into various types of normal forms.
a.
True
b.
False
3. If B is functionally dependent on A, you can also say that B functionally determines A.
a.
True
b.
False
4. Functional dependencies can be determined by looking at sample data.
a.
True
b.
False
5. Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as
possible.
a.
True
b.
False
6. In general, when converting a non-first normal form table to first normal form, the primary key will usually
include the original primary key concatenated with the key to the repeating group.
a.
True
b.
False
Chapter 5: Database Design 1: Normalization
7. A table that is in first normal form may contain problems that will require you to restructure it.
a.
True
b.
False
8. If the primary key of a table contains only a single column, the table is automatically in first normal form.
a.
True
b.
False
9. In a dependency diagram, the arrows below the boxes indicate the normal dependencies.
a.
True
b.
False
10. Tables that are in second normal form do not contain problems.
a.
True
b.
False
11. The most recent definition of third normal form is referred to as the Boyce-Codd normal form.
a.
True
b.
False
12. The primary key in a table will be a determinant.
a.
True
b.
False
13. Converting to third normal form always avoids the problems related to dependencies.
a.
True
b.
False
Chapter 5: Database Design 1: Normalization
14. The normalization process used to convert a relation or collection of relations to an equivalent collection of third
normal form tables is a crucial part of the database design process.
a.
True
b.
False
15. By splitting relations to achieve third normal form tables, you create the need to express interrelation
constraints.
a.
True
b.
False
16. Potential problems in the design of a relational database are known as ____.
a.
update anomalies
b.
select anomalies
c.
modification anomalies
d.
relational anomalies
17. The fact that column B is functionally dependent on column A can be written as ____.
a.
A ® B
b.
B ® A
c.
A ® ® B
d.
B ® ® A
18. If B (an attribute) is functionally dependent on A, we can also say that ____.
a.
A functionally determines B
b.
A functionally determines another attribute in the table
c.
B functionally determines A
d.
B does not determine any other attribute
Chapter 5: Database Design 1: Normalization
19. The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no
subcollection of the columns in A has this property.
a.
functional key
b.
composite key
c.
primary key
d.
declared key
20. The definition for ____ also defines a candidate key.
a.
functional key
b.
repeating group
c.
primary key
d.
nonkey column
21. A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.
a.
index key
b.
candidate key
c.
major key
d.
special key
22. An alternate key is a ____.
a.
foreign key
b.
primary key
c.
column that could be a primary key but was not chosen
d.
row that could be a primary key but was not chosen
23. A table is in first normal form if it does not contain ____.
a.
repeating groups
b.
a foreign key
c.
a primary key
Chapter 5: Database Design 1: Normalization
d.
alternate keys
24. A table that contains a repeating group is called a(n) ____.
a.
normalized relation
b.
unnormalized relation
c.
nominal relation
d.
non-nominal relation
25. If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary
key, the others are referred to as ____.
a.
canceled keys
b.
alternate keys
c.
nonkey attributes
d.
contributory keys
26. From all the ____ keys, one is chosen to be the primary key.
a.
alternate
b.
candidate
c.
functional
d.
normal
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 )
28. A column is a nonkey column if it is ____.
a.
in first normal form
b.
in second normal form
Chapter 5: Database Design 1: Normalization
c.
a part of the primary key
d.
not a part of the primary key
29. Another name for a nonkey column is a ____.
a.
nonkey attribute
b.
key attribute
c.
nonkey row
d.
key table
30. Second normal form can be defined as a table that is in first normal form but that contains no ____.
a.
partial dependencies
b.
alternate keys
c.
nonkey columns
d.
interrelation constraints
31. Partial dependencies are dependencies on only a portion of the ____.
a.
nonkey column
b.
first column or attribute
c.
primary key
d.
index
32. ____ normal form has an additional condition that the only determinants the table contains are candidate keys.
a.
First
b.
Second
c.
Third
d.
Fourth
33. A table is in fourth normal form when it is in third normal form and there are no ____.
a.
alternate keys
b.
foreign keys
Chapter 5: Database Design 1: Normalization
c.
multivalued dependencies
d.
primary dependencies
34. To convert a table to fourth normal form, split the third normal form table into separate tables, each containing the
column that ____ the others.
a.
determines
b.
multidetermines
c.
defines
d.
identifies
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
36. The ____________________ process enables you to identify the existence of potential problems in the design of a
database.
37. A column B is ____________________ on another column A if each value for A in the database is
associated with exactly one value of B.
38. Second normal form represents an improvement over ____________________ normal form.
39. A column is a nonkey column if it is not a part of the ____________________.
Chapter 5: Database Design 1: Normalization
40. A(n) ____________________ uses arrows to indicate all the functional dependencies present in the table.
41. Any column or collection of columns that determines another column is called a(n)
42. By converting a given collection of tables to an equivalent third normal form collection of tables, you remove any
problems arising from ____________________ dependencies.
43. In a table with columns A, B, and C, there is a(n) ____________________ dependence of column B on
column A if each value for A is associated with a specific collection of values for B and, further, this collection
is independent of any values for C.
44. A→→ B signifies that B is ____________________ on A.
45. A(n) ____________________ is a condition that involves two or more relations.
46. Explain what normalization is, including the goal of normalization.
47. Discuss what normal forms are and list the most common normal forms.
48. Discuss how candidate keys, primary key, and alternate keys are related.
49. What is the difference between a table in first normal form and one in second normal form?
50. Describe the procedure for converting a table to the third normal form.
