845 views
1 votes
1 votes
Suppose the  functional dependencies B--->C

holds in a relation R(A,B,C,D).which additional FD will make R be in 3NF ,but not in BCNF?

a)D--->AB        b)AC--->D

c)CD-->B         d)AD--->B

1 Answer

Best answer
5 votes
5 votes

Check one by one...

option A:-  D->AB

Now My Functional Dependency set is {B->C and D->AB} therefore D is the Key for the relation, now B->C leads to non-prime transitivity, therefore It is not in 3NF

 

option B:-  AC->D

Now My Functional Dependency set is {B->C and AC->D} therefore AB is the Key for the relation, now B->C leads to partial functional dependency, therefore It is not in 2NF ===> It is not in 3NF

 

option C:-  CD->B

Now My Functional Dependency set is {B->C and CD->B} therefore ABD or ACD are the Keys for the relation, now B->C leads to prime transitivity, therefore It is not in BCNF but It can in 3NF

 

option D:-  AD->B

Now My Functional Dependency set is {B->C and AD->B} therefore AD is the Key for the relation, now B->C leads to non-prime transitivity, therefore It is not in 3NF.

 

Option C is correct

selected by

Related questions

1 votes
1 votes
1 answer
1
Syed Sauban asked Nov 4, 2018
561 views
How are the minimum number of tables required two? Can anyone please explain me?
0 votes
0 votes
0 answers
2
SHUBHAM DOMBE asked Oct 20, 2018
232 views
CONSIDER the relation R(ABC) with functional dependency F={A->B,AB->C,C->A} Which of the following is Super key but not candidate key?(a) A(b) AB(c)C(d) None
0 votes
0 votes
2 answers
3
meethunjadhav asked Aug 7, 2018
253 views
which of the following is not a strict schedule?A) R1(A),R2(A),W1(A),Abort1,W2(A),Commit2B) R1(A),R2(A),W1(A),Commit1,W2(A),Abort2C) R1(A),R2(A),W2(A),Commit2,W1(A),Commi...