1 votes 1 votes According to answer only one statement is correct which is 4. but i got 3 correct statement that is 1,2,3 pls suggest Databases database-normalization + – set2018 asked Sep 17, 2017 set2018 334 views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply srestha commented Sep 17, 2017 reply Follow Share 2,3 definitely wrong Doubt about 1 1 votes 1 votes set2018 commented Sep 17, 2017 reply Follow Share srestha ohh sorry ,see this pls yes u r right 2 is wrong bcnf need not be dependency preserving 3 is wrong prime attribute of relational schema appears in some candidate key reason for 4 :it is wrong because it is nothing saying for non prime----> non prime (transitive dependency)(not in 3nf) relation will be in 3nf if lhs must be superkey or rhs must be prime attribute but question says some candidate key tht means prime--->non prime ,it may be chance that prime attribute will not form superkey According to answer key 4th point is correct and all (1,2,3) are wrong 0 votes 0 votes set2018 commented Sep 17, 2017 reply Follow Share see this pls https://gateoverflow.in/34/gate2012-2 only change in this option "some " but it is also wrong not much know about first point pls check this 0 votes 0 votes Please log in or register to add a comment.
