Concept Check -- Key Determination from Functional Dependencies

156 views Asked by At

This is more of a concept check than anything, but suppose I have a relation R on attributes ABCD with the functional dependencies B -> ACD and C -> D. The solitary key for this relation is B, and a superkey for this relation is BC, correct?

2

There are 2 answers

0
Alexander Serebrenik On BEST ANSWER

The only candidate key in your example is indeed B. Any collection of attributes containing B will be a superkey, e.g., B itself, AB, BC or ABD.

0
miten On

candidate key is B.

As all the attributes can be derived from B, B becomes superkey..