-
Which of the following is true?
-
- Every relation in 3NF is also in BCNF
- A relation R is in 3 NF if every non-prime attribute of R is fully functionally dependent on every key of R.
- Every relation in BCNF is also in 3 NF
-
No relation can be in both BCNF and 3NF
- Every relation in 3NF is also in BCNF
Correct Option: C
According to relation between the different normal forms i.e.,
BCNF is more restricted than 3 NF and 3 NF is more restricted than 2 NF and so on. Consider option (a):
The statement is given which is wrong because every relation which is in 3rd normal form it is not necessary that those will be in BCNF form. Hence, this is false.
Consider option (b):
When every non-prime attribute of R is fully functionally dependent on every key of R. Then, that relation is in 2 NF not in 3 NF.
Consider option (c):
Every relation which is in BCNF, then it is confirmed that it is also in 3 NF.
Consider option (d):
This statement is wrong because the relation can be in both BCNF and 3 NF.
