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?
Concept Check -- Key Determination from Functional Dependencies
156 views Asked by tdark At
2
The only candidate key in your example is indeed
B
. Any collection of attributes containingB
will be a superkey, e.g.,B
itself,AB
,BC
orABD
.