2,524 views

7 Answers

0 votes
0 votes

Need Not be Dependency Preserving.

Lossless decomposition is the fundamental thing which each and every normalization should follow.

But Preserving dependencies is followed till 2NF,3NF. But when we go for higher normalization like BCNF then  preserving the functional dependencies became difficult since the rule for BCNF are more Strict than 3NF.

0 votes
0 votes
Option C is the best ans.
Because in case of BCNF dependency preserving is not necessary . it may be preserved or not.
But in case of 3 nf Dependency preserving is necessary
0 votes
0 votes
The answer is c:

Every BCNF decomposition may or may not be dependency preserving

but remember, it will always be lossless decomposition..

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 ...