Chapter 5

25 July 2022
4.7 (114 reviews)
33 test answers

Unlock all answers in this set

Unlock answers (29)
question
The conversion of an unnormalized table to first normal form requires the removal of ____.‚Äč
answer
repeating groups
question
An alternate key is a ____.‚Äč
answer
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 ____.‚Äč
answer
alternate keys
question
Potential problems in the design of a relational database are known as ____.‚Äč
answer
update anomalies
question
If B (an attribute) is functionally dependent on A, we can also say that ____.‚Äč
answer
A functionally determines B
question
A table is in first normal form if it does not contain ____.‚Äč
answer
repeating groups
question
‚ÄčA table is in fourth normal form when it is in third normal form and there are no ____.
answer
multivalued dependencies
question
The definition for ____ also defines a candidate key.‚Äč
answer
‚Äčprimary key
question
From all the ____ keys, one is chosen to be the primary key.‚Äč
answer
candidate
question
The fact that column B is functionally dependent on column A can be written as ____.‚Äč
answer
A -> B
question
____ normal form has an additional condition that the only determinants the table contains are candidate keys.‚Äč
answer
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 )
answer
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 ____.‚Äč
answer
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.‚Äč
answer
‚Äčprimary key
question
‚ÄčA table that contains a repeating group is called a(n) ____.
answer
unnormalized relation
question
A table that is in first normal form is better than one that is in second normal form.‚Äč
answer
False
question
By splitting relations to achieve third normal form tables, you create the need to express interrelation constraints.‚Äč
answer
True
question
If the primary key of a table contains only a single column, the table is automatically in first normal form.‚Äč
answer
False
question
Converting to third normal form always avoids the problems related to dependencies.‚Äč
answer
False
question
Removal of repeating groups is the starting point in the quest to create tables that are as free of problems as possible.‚Äč
answer
True
question
A table that is in first normal form may contain problems that will require you to restructure it.‚Äč
answer
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.‚Äč
answer
True
question
The primary key in a table will be a determinant.‚Äč
answer
True
question
If B is functionally dependent on A, you can also say that B functionally determines A.‚Äč
answer
False
question
In a dependency diagram, the arrows below the boxes indicate the normal dependencies.‚Äč
answer
False
question
A column is a nonkey column if it is ____.‚Äč
answer
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.‚Äč
answer
‚Äč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.‚Äč
answer
multidetermines
question
Another name for a nonkey column is a ____.‚Äč
answer
nonkey attribute
question
Partial dependencies are dependencies on only a portion of the ____.‚Äč
answer
‚Äčprimary key
question
Tables that are in second normal form do not contain problems.‚Äč
answer
False
question
The most recent definition of third normal form is referred to as the Boyce-Codd normal form.‚Äč
answer
True
question
Functional dependencies can be determined by looking at sample data.‚Äč
answer
False