NIELIT 2017 DEC Scientist B - Section B: 24

Question

Which of the following is TRUE?

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

Comments

https://gateoverflow.in/34/gate2012-2

---

Detailed Video Solution: https://youtu.be/H00icXp3Bvc 

Option B is the definition of 2NF, Not of 3NF. 

Complete Normalization Playlist: Normalization Complete Playlist 

Answer 1

correct option C

https://gateoverflow.in/34/gate2012-2

Answer 2

Option C is correct as every relation in BCNF is also in $3$NF as there would be zero redundancy and no partial and transitive dependencies would be present in such a relation.