Register

Doubt in BCNF

396 views
0 votes
0 votes
Does BCNF completely eliminate redundancy?
User Avatar

2 Answers

2 votes
2 votes

BCNF completely eliminate  redundancy over functional dependency . Its not free from redundancy over multivalued dependency.

So your statement is wrong .

 

 

User Avatar
1 votes
1 votes
BCNF is optimal form ,it removes redundancy nearly 0% but not completely.
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
2
srestha asked Apr 11, 2018
1,556 views
Normalization-(prime attribute -> prime attribute dependency is there in BCNF)
$AB\rightarrow CD$ $CD\rightarrow AB$ $A\rightarrow C$ Is it in 3NF or BCNF? Is prime attribute -> prime attribute dependency is there in BCNF?
$AB\rightarrow CD$$CD\rightarrow AB$$A\rightarrow C$Is it in 3NF or BCNF?Is prime attribute - prime attribute dependency is there in BCNF?
User Avatar
2 votes
2 votes
1 answer
3
sumit goyal 1 asked Jan 11, 2018
467 views
plz someone decompose it in BCNF
$R(ABCD)$ Functional depedndency : { $AB \rightarrow CD , D\rightarrow A$ } AB and DB are candidate key
$R(ABCD)$ Functional depedndency : { $AB \rightarrow CD , D\rightarrow A$ }AB and DB are candidate key
User Avatar
0 votes
0 votes
1 answer
4
hem chandra joshi asked Nov 5, 2017
436 views
which of the following is in BCNF Form AND LOSSY OR LOSSLESS JOIN ?
R(A,B,C,D) 1. A->B , B->CD 2. A->B , B->C , C->D 3. AB->C , C->AD 4. A->BCD
R(A,B,C,D)1. A->B , B->CD2. A->B , B->C , C->D3. AB->C , C->AD4. A->BCD
User Avatar
Link Copied!