1 1 vote Databases ace-test-series databases database-normalization + – hacker16 1.4k views answer comment Share Follow Print See all 5 Comments 5 5 Comments reply Show 2 previous comments Anu007 commented Jan 12, 2018 reply Follow flag 1st is false b/c transitive dependency not allow in BcNF 0 0 replyShare hacker16 commented Jan 12, 2018 reply Follow flag Please explain it little bit more @ashwin sir @anu sir If Every non prime attributes are fully functionally dependent on every key then it will be in 2NF. or you can say in 3NF non prime attributes are fully functionally dependent on some key of R. 0 0 replyShare hacker16 commented Jan 12, 2018 reply Follow flag please, check this one also @anu sir @ ashwin sir https://gateoverflow.in/156664/ace-test-series-data 0 0 replyShare Please log in or register to add a comment.
3 3 votes 1) false .......> it is true for 3NF. 2)false 3)true............>Unique key constraints are used to ensure that data is not duplicated in two rows in the database. One row in the database is allowed to have null for the value of the unique key constraint. abhishekmehta4u answered Mar 24, 2018 • edited Mar 24, 2018 by abhishekmehta4u abhishekmehta4u comment Share Follow See 1 comment 1 1 comment reply sachin486 commented Dec 9, 2020 reply Follow flag didn’t understand your third point?? 0 0 replyShare Please log in or register to add a comment.
0 0 votes 2 statements are wrong..1 and 3.. A unique key may be candidate key as well that can not be null... Avik Chowdhury answered Mar 23, 2018 Avik Chowdhury comment Share Follow See 1 comment 1 1 comment reply anon commented Mar 24, 2018 reply Follow flag so the two statements that are false are statement 1 and statement 3? Please explain 0 0 replyShare Please log in or register to add a comment.
