6 6 votes In relational databases, if relation R is in BCNF, then which of the following is true about relation R? R is in 4NF R is not in 1NF R is in 2NF and not in 3NF R is in 2NF and 3NF Databases ugcnetcse-june2019-paper2 database-normalization + – Arjun 4.9k views answer comment Share Follow Print See all 4 Comments 4 4 Comments reply Satbir commented Jul 2, 2019 reply Follow flag Option 4. 0 0 replyShare SuvasishDutta commented Jul 2, 2019 i edited by SuvasishDutta Jul 2, 2019 reply Follow flag Option 4 is correct 0 0 replyShare Laxman2600 commented Nov 28, 2019 reply Follow flag Option D is correct. 0 0 replyShare Deepak Poonia commented Jul 16, 2024 reply Follow flag Detailed Video Solution: https://youtu.be/Ai-zpaUbXzs?t=4638&feature=shared 0 0 replyShare Please log in or register to add a comment.
Best answer 8 8 votes $\therefore$ Option $4.$ is correct. Satbir answered Jul 19, 2019 • edited Nov 28, 2019 by Satbir Satbir comment Share Follow 0 reply Please log in or register to add a comment.
1 1 vote 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. Abhisek Tiwari 4 answered Jul 3, 2019 • edited Jul 3, 2019 by Abhisek Tiwari 4 Abhisek Tiwari 4 comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes Option D. If Relation is in BCNF then it must be 1NF,2NF,3NF. mayurmsb7 answered Dec 28, 2019 mayurmsb7 comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes It also in 2nf and 3 nf Anup dogrial answered Jan 20, 2020 Anup dogrial comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes option D as the BCNF is stricter than 1NF,2NF,3NF. Hence a relation in BCNF,then it is also in 1NF,2NF,3NF. DIBAKAR MAJEE answered Apr 29, 2020 DIBAKAR MAJEE comment Share Follow 0 reply Please log in or register to add a comment.
