911 views
0 votes
0 votes
Why LHS of a 3NF or BCNF should be a super key and why not just a candidate key?

1 Answer

2 votes
2 votes
LHS(determinant) of any Non-trivial FD in BCNF must be a Super key. It could also be a Candidate key as candidate key is also a super key. And Furthermore, if you observe, All such Non-trivial FDs where determinant is a Super key(But Not a candidate key) are having extraneous attributes on the LHS(i.e. in Determinant part) as the candidate key part of this super key itself can determine the extra attributes present in the determinant(LHS). So, It wouldn't be wrong to say that LHS(determinant) of any Non-trivial FD in BCNF must be a Candidate key But then you will have to first find the minimal FD set out of given FD set to apply this test for BCNF.

Related questions

11 votes
11 votes
5 answers
1
4 votes
4 votes
2 answers
4
kalpashri asked Nov 20, 2014
9,745 views
consider a relation R(a,b,c,d,e,f,g,h,,i,j)following fd's hold-AB->CA->DEB->FF->GHD->IJdecompose the relation into 3nf and BCNF.