UGC NET CSE | June 2019 | Part 2 | Question: 34

Question

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

• A. R is in 4NF
• B. R is not in 1NF
• C. R is in 2NF and not in 3NF
• D. R is in 2NF and 3NF

Comments

Option 4.

---

Option 4 is correct

---

Option D is correct.

Answer 1

 

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

Answer 2

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.

Answer 3

Option D.

If Relation is in BCNF then it must be 1NF,2NF,3NF.

Answer 4

It also in 2nf and 3 nf