1. Home
  2. Database Software
  3. Database Management System H.w. Help Please?

Discuss in my Forum

Database Management System H.w. Help Please?

By admin Posted in: Database Software

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

  1. ? Says

    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!

Leave a Reply

You must be logged in to post a comment.

More Interesting Things

©2011 Softwares Reviews, All rights reserved.