Question 1:

Suppose you are given a relation R with four attributes ABCD and the following set of FDs: AB?C, BC?D.

a. Identify the candidate key(s) for R (recall that keys must be minimal)

b. Determine if R is in BCNF, 3NF, or none of the above. If it is not in BCNF, decompose it into a set of BCNF relations.

Question 2:

Suppose you are given a relation R with four attributes ABCD and the following set of FDs: BC?A, AB?C, C?DA.

a. Identify the key(s) for R (recall that keys must be minimal)

b. Determine if R is in BCNF, 3NF, or none of the above. If it is not in BCNF, decompose it into a set of BCNF relations.

Note: For both questions, recall that it is not sufficient to consider the set of FDs that are given, but also its closure.