CS305 Final UPDATED ACTUAL
Questions and CORRECT Answers
The conversion of an unnormalized table to first normal form requires the removal of ____. -
CORRECT ANSWER- ✔✔repeating groups
If B is functionally dependent on A, you can also say that B functionally determines A. -
CORRECT ANSWER- ✔✔False
Tables that are in second normal form do not update anomalies. - CORRECT ANSWER-
✔✔False
____ normal form has an additional condition that the only determinants the table contains
are candidate keys. - CORRECT ANSWER- ✔✔Third
Another name for a nonkey column is a ____. - CORRECT ANSWER- ✔✔nonkey attribute
If B (an attribute) is functionally dependent on A, we can also say that ____. - CORRECT
ANSWER- ✔✔A functionally determines B
A column is a nonkey column if it is ____. - CORRECT ANSWER- ✔✔not a part of the
primary key
The possibility of data dependence is one of the four categories of update anomalies. -
CORRECT ANSWER- ✔✔False
A table is in first normal form if it does not contain ____. - CORRECT ANSWER-
✔✔repeating groups
A column is a nonkey attribute when it is not part of the primary key. - CORRECT
ANSWER- ✔✔True
, The primary key in a table is a determinant but candidate keys are not determinants. -
CORRECT ANSWER- ✔✔False
A(n) ____ is a column or collection of columns on which all columns in the table are
functionally dependent. - CORRECT ANSWER- ✔✔candidate key
In a dependency diagram, the arrows below the boxes indicate the partial dependencies. -
CORRECT ANSWER- ✔✔True
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. - CORRECT ANSWER- ✔✔True
From all the ____ keys, one is chosen to be the primary key. - CORRECT ANSWER-
✔✔candidate
To convert a table to fourth normal form, split the third normal form table into separate
tables, each containing the column that ____ the others. - CORRECT ANSWER-
✔✔multidetermines
___ contains a repeating group. - CORRECT ANSWER- ✔✔Orders (OrderNum, OrderDate,
(PartNum, NumOrdered) )
An alternate key is a ____. - CORRECT ANSWER- ✔✔column that could be a primary key
but was not chosen
If the primary key of a table contains only a single column, the table is automatically in third
normal form. - CORRECT ANSWER- ✔✔False
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. -
CORRECT ANSWER- ✔✔primary key
Questions and CORRECT Answers
The conversion of an unnormalized table to first normal form requires the removal of ____. -
CORRECT ANSWER- ✔✔repeating groups
If B is functionally dependent on A, you can also say that B functionally determines A. -
CORRECT ANSWER- ✔✔False
Tables that are in second normal form do not update anomalies. - CORRECT ANSWER-
✔✔False
____ normal form has an additional condition that the only determinants the table contains
are candidate keys. - CORRECT ANSWER- ✔✔Third
Another name for a nonkey column is a ____. - CORRECT ANSWER- ✔✔nonkey attribute
If B (an attribute) is functionally dependent on A, we can also say that ____. - CORRECT
ANSWER- ✔✔A functionally determines B
A column is a nonkey column if it is ____. - CORRECT ANSWER- ✔✔not a part of the
primary key
The possibility of data dependence is one of the four categories of update anomalies. -
CORRECT ANSWER- ✔✔False
A table is in first normal form if it does not contain ____. - CORRECT ANSWER-
✔✔repeating groups
A column is a nonkey attribute when it is not part of the primary key. - CORRECT
ANSWER- ✔✔True
, The primary key in a table is a determinant but candidate keys are not determinants. -
CORRECT ANSWER- ✔✔False
A(n) ____ is a column or collection of columns on which all columns in the table are
functionally dependent. - CORRECT ANSWER- ✔✔candidate key
In a dependency diagram, the arrows below the boxes indicate the partial dependencies. -
CORRECT ANSWER- ✔✔True
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. - CORRECT ANSWER- ✔✔True
From all the ____ keys, one is chosen to be the primary key. - CORRECT ANSWER-
✔✔candidate
To convert a table to fourth normal form, split the third normal form table into separate
tables, each containing the column that ____ the others. - CORRECT ANSWER-
✔✔multidetermines
___ contains a repeating group. - CORRECT ANSWER- ✔✔Orders (OrderNum, OrderDate,
(PartNum, NumOrdered) )
An alternate key is a ____. - CORRECT ANSWER- ✔✔column that could be a primary key
but was not chosen
If the primary key of a table contains only a single column, the table is automatically in third
normal form. - CORRECT ANSWER- ✔✔False
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. -
CORRECT ANSWER- ✔✔primary key
