Raghu Ramakrishnan-3e-Chapter 19-Exercise 19.13

If anyone having any idea how to solve mainly the (b) part. Please help me out. Consider a relation R with five attributes ABCDE.For each of the following instances of R, state whether it violates (a) the FD BC→ D and (b) the MVD BC →→ D: (a) { } (i.e., empty relation) (b) {(a,2, ... a,2,3,6,6)} (g) {(a,2,3,4,5), (a,2,3,6,5), (a,2,3,6,6), (a,2,3,4,6)}
If anyone having any idea how to solve mainly the (b) part. Please help me out. Consider a relation R with five attributes ABCDE.For each of the following instances of R, state whether it violates (a) the FD BC→ D and (b) the MVD BC →→ D: (a) { } (i.e., empty relation) (b) {(a,2,3,4,5), (2,a,3,5,5)} (c) {(a,2, ... , (a,2,3,6,5), (a,2,3,6,6)} (g) {(a,2,3,4,5), (a,2,3,6,5), (a,2,3,6,6), (a,2,3,4,6)}

asked
Sep 13
in Databases
कुशाग्र गुप्ता
46 points
4 views