Normalization

Question 5

Which of the following is TRUE?

A	Every relation in 3NF is also in BCNF
B	A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
C	Every relation in BCNF is also in 3NF
D	No relation can be in both BCNF and 3NF

Question 5 Explanation:

BCNF is a stronger version 3NF. So straight from definition of BCNF every relation in BCNF will also be in 3NF.

Correct Answer: C

Question 5 Explanation:

BCNF is a stronger version 3NF. So straight from definition of BCNF every relation in BCNF will also be in 3NF.