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
c.
primary key
b.
composite key
d.
declared key
____ 63. A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent.
a.
index key
c.
major key
b.
candidate key
d.
special key
__A__ 64. A table is in first normal form if it does not contain ____.
a.
repeating groups
c.
a primary key
b.
a foreign key
d.
alternate keys
____ 65. A table that contains a repeating group is called a(n) ____.
a.
normalized relation
c.
nominal relation
b.
unnormalized relation
d.
non-nominal relation
____ 66. From all the ____ keys, one is chosen to be the primary key.
a.
alternate
c.
functional
b.
candidate
d.
normal
____ 67. A column is a nonkey column if it is ____.
a.
in first normal form
c.
a part of the primary key
b.
in second normal form
d.
not a part of the primary key
____ 68. Second normal form can be defined as a table that is in first normal form but that contains no ____.
a.
partial dependencies
c.
nonkey columns
b.
alternate keys
d.
interrelation constraints
____ 69. ____ normal form has an additional condition that the only determinants the table contains are candidate keys.
a.
First
c.
Third
b.
Second
d.
Fourth


62. primary key
63. candidate key
64. repeating groups
65. unnormalized relation
66. candidate
67. not a part of the primary key
68. partial dependencies
69. Not sure. Most probably, third!