1,218 views
0 votes
0 votes

Multi Valued Dependencies(MVD)  satisfied by relation R(A,B,C) with tuples: (a1,b1,c1),(a1,b1.c2), (a2,b1,c1), (a2,b1,c3)

A⇢⇢B

B⇢⇢A,   BC⇢⇢A, B⇢⇢AC

1 Answer

1 votes
1 votes

B⇢⇢A, is wrong (a1,b1,c1) and (a2,b1,c1) prove this  //For same B value different A value

BC⇢⇢A is wrong (a1,b1,c1)and(a2,b1,c1) prove this ////For same B,C values different A value

B⇢⇢AC is wrong (a1,b1,c1)and(a2,b1,c1) prove this //For same B value different A, C values

A⇢⇢B is right answer

Related questions

0 votes
0 votes
0 answers
1
Sourabh Kumar asked May 6, 2016
734 views
A.dep >>jobB.dep >>partC.both a and bD.none of these
1 votes
1 votes
0 answers
2
Sourabh Kumar asked May 6, 2016
475 views
How to find all mvd's in this table.i know mvd defination according to that we let t1,t2,t3,t4 in table but in this table ,which tuple we take t1,t2,t3,t4 .and how defin...
0 votes
0 votes
1 answer
3