3 votes 3 votes Which of the following is TRUE? Every relation in $3$NF 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 $3$NF. Databases nielit2017dec-scientistb database-normalization bcnf + – admin asked Mar 30, 2020 retagged Aug 1, 2020 by Lakshman Bhaiya admin 1.1k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Anu007 commented Dec 18, 2017 reply Follow Share https://gateoverflow.in/34/gate2012-2 0 votes 0 votes Deepak Poonia commented Nov 11, 2023 reply Follow Share Detailed Video Solution: https://youtu.be/H00icXp3Bvc Option B is the definition of 2NF, Not of 3NF. Complete Normalization Playlist: Normalization Complete Playlist 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes correct option C https://gateoverflow.in/34/gate2012-2 mohitbawankar answered Dec 18, 2017 mohitbawankar comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 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. haralk10 answered Mar 29, 2020 haralk10 comment Share Follow See all 0 reply Please log in or register to add a comment.