Monday 23 November 2015

Q9,p3,J15.select the False statement from the following statements about Normal forms.

A) Loss less  preserving decomposition in to 3nf is always possible.
B)Loss less preserving decomposition in to BCNF is always possible.
C)Any relation with two attributes is in BCNF.
D)BCNF is stronger than 3NF.
Answer B.
explanation.
Table 1(A,B,C) with FD  AB->C and C->B  cannot be preserved  when decomposition is done.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.