5 votes 5 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 asked Jul 2, 2019 edited Jul 23, 2019 by Lakshman Bhaiya Arjun 3.1k views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Satbir commented Jul 2, 2019 reply Follow Share Option 4. 0 votes 0 votes SuvasishDutta commented Jul 2, 2019 i edited by SuvasishDutta Jul 2, 2019 reply Follow Share Option 4 is correct 0 votes 0 votes Laxman2600 commented Nov 28, 2019 reply Follow Share Option D is correct. 0 votes 0 votes Please log in or register to add a comment.
Best answer 8 votes 8 votes $\therefore$ Option $4.$ is correct. Satbir answered Jul 19, 2019 edited Nov 28, 2019 by Satbir Satbir comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes 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 See all 0 reply Please log in or register to add a comment.
0 votes 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 See all 0 reply Please log in or register to add a comment.
0 votes 0 votes It also in 2nf and 3 nf Anup dogrial answered Jan 20, 2020 Anup dogrial comment Share Follow See all 0 reply Please log in or register to add a comment.