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

option D as the BCNF is stricter than 1NF,2NF,3NF. Hence a relation in BCNF,then it is also in 1NF,2NF,3NF.