2,524 views

7 Answers

1 votes
1 votes

OPTION C

BCNF need not be FD preserving always. It may be or may not be.

1 votes
1 votes
C)Need not be dependency preserving
0 votes
0 votes

Option C will be right option for it bcz every table in BCNF should not be in FDs preserving but it is not case of 3NF.This is very -very important difference in 3NF as well as BCNF.

Related questions

1 votes
1 votes
2 answers
1
aditi19 asked Apr 14, 2019
1,845 views
Decompose into BCNFR(A, B, C, D, E)FD: AB->C, C->D, D>B, D->E
2 votes
2 votes
1 answer
2
Na462 asked Jul 14, 2018
1,856 views
3 votes
3 votes
1 answer
3
aditi19 asked Nov 29, 2018
1,096 views
R(A, B, C, D)FD: B->C, D->Ais the following decomposition in BCNF?R1(B, C), R2(A, D), R3(C, D)
2 votes
2 votes
2 answers
4
pradeepchaudhary asked Jun 8, 2018
1,750 views
Given: The Relation R(A,B,C,D,E) having (A,B) as Primary key. The set of functional dependencies: (A,C) >D , (B,D) >E. I want to Know whether the functional dependencies ...