2,452 views

In relational databases, if relation R is in BCNF, then which of the following is true about relation R?

1. R is in 4NF
2. R is not in 1NF
3. R is in 2NF and not in 3NF
4. R is in 2NF and 3NF

Option 4.
edited
Option 4 is correct
Option D is correct.

$\therefore$ Option $4.$ is correct.

by
A relation is  in 'N' Normal Form it means it must be in 1NF,2NF,......N-1 NF.

Standard Normal Form Hiearchy

1NF - > 2NF - > 3NF - > BCNF

So Realtion is in BCNF then it must be in 1NF,2NF & 3NF Hence Opton 4 is correct.
Option D.

If Relation is in BCNF then it must be 1NF,2NF,3NF.
It also in 2nf and 3 nf