Question: Problem 2 Consider a relation R with five attributes ABCDE. For each of the following instances of R, state whether it violates the functional dependency
Problem 2 Consider a relation R with five attributes ABCDE. For each of the following instances of R, state whether it violates the functional dependency (FD) BC D. If an instance violates the FD, state two tuples which violate it. In the given instances, digits denote actual attribute values and "a" denotes a variable representing any attribute value. If an instance violates the FD only for certain values of a, state these values. a) (a,2,3,4,5), (2,a,3,5,5)) b) (a,2,3,4,5), (2,a,3,4,5), (a,2,3,6,5)) c) (a,2,3,4,5), (a,2,3,6,5), (a,2,3,6,6), (2,a,3,4,6)3 d) If each of the instances of R listed above is legal, what can we say about the FD (2 points) (2 points) 2 points) AB: it holds, it does not hold or we don't know whether it holds? (2 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
