开发者

NormalizAtion concept in DB

Is this statment correct?

"A Prime attribute can be transitively dependon a key in a BCNF relation" ?

according to me it is wrong

if it is wrong then what is the Normal Form of given Relation

R(A,B,C,D) and its functional dependenc开发者_JS百科y set is { AB->C ,AB->D , CD->A ,CD->B ,AB->CD }


A BCNF relation can satisfy a transitive FD like A->B->C only if A and B are both superkeys or if either A->B or B->C is trivial.

Gramatical errors aside the statement is strictly correct - it's just not very interesting or useful. Normally we are interested in whether a relation satisfies any non-superkey, non-trivial FDs, which are the ones that BCNF prohibits. I suggest you recheck the quotation to make sure you have it right.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜