# Chapter 5

## Unlock all answers in this set

question
The conversion of an unnormalized table to first normal form requires the removal of ____.​
repeating groups
question
An alternate key is a ____.​
column that could be a primary key but was not chosen
question
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 ____.​
alternate keys
question
Potential problems in the design of a relational database are known as ____.​
update anomalies
question
If B (an attribute) is functionally dependent on A, we can also say that ____.​
A functionally determines B
question
A table is in first normal form if it does not contain ____.​
repeating groups
question
​A table is in fourth normal form when it is in third normal form and there are no ____.
multivalued dependencies
question
The definition for ____ also defines a candidate key.​
​primary key
question
From all the ____ keys, one is chosen to be the primary key.​
candidate
question
The fact that column B is functionally dependent on column A can be written as ____.​
A -> B
question
____ normal form has an additional condition that the only determinants the table contains are candidate keys.​
Third
question
Which of the following contains a repeating group?​ ​Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) ) ​Orders (OrderNum, ItemNum, NumOrdered ) ​Orders (OrderNum, OrderDate) ​Orders (OrderNum, OrderDate, ItemNum, NumOrdered )
Orders (OrderNum, OrderDate, (ItemNum, NumOrdered) )
question
Second normal form can be defined as a table that is in first normal form but that contains no ____.​
Partial Dependencies
question
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.​
​primary key
question
​A table that contains a repeating group is called a(n) ____.
unnormalized relation
question
A table that is in first normal form is better than one that is in second normal form.​
False
question
By splitting relations to achieve third normal form tables, you create the need to express interrelation constraints.​
True
question
If the primary key of a table contains only a single column, the table is automatically in first normal form.​
False
question
Converting to third normal form always avoids the problems related to dependencies.​
False
question
Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.​
True
question
A table that is in first normal form may contain problems that will require you to restructure it.​
True
question
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.​
True
question
The primary key in a table will be a determinant.​
True
question
If B is functionally dependent on A, you can also say that B functionally determines A.​
False
question
In a dependency diagram, the arrows below the boxes indicate the normal dependencies.​
False
question
A column is a nonkey column if it is ____.​
not a part of the primary key
question
A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.​
​candidate key
question
To convert a table to fourth normal form, split the third normal form table into separate tables, each containing the column that ____ the others.​
multidetermines
question
Another name for a nonkey column is a ____.​
nonkey attribute
question
Partial dependencies are dependencies on only a portion of the ____.​