Multiple Choice Questions

_____ 1) The _________ requires that the values in each column of a table are atomic. By atomic we mean that there are no sets of values within a column.

A) 1NF

B) 2NF

C) BCNF

D) None of the above

E) All of the above

Use the following information to answer the next two questions.

Consider the FD set F on a relation R with four attributes: M, O, R, E

OR M

MO R

R O

OE M

______ 2) Which of the following is a candidate key of the relation R(MORE)?

A) RE

B) ORE

C) E

D) OR

E) MEO

______ 3) The relation R is in the ___________________.

A) First Normal Form (1NF)

B) Second Normal Form (2NF)

C) Third Normal Form (3NF)

D) Boyce-Codd Normal Form (BCNF)