0 0 votes Q. For relation R(W, X, Y, Z):WX → YW → ZCandidate key = WXWhich dependencies violate 2NF?A) WX → Y onlyB) W → Z onlyC) Both FDsD) None of the above Databases rdbms gate-preparation databases + – Sarthak_Joshi 380 views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
1 1 vote W->Z is violating 2NF it is producing the condition that subset of some candidate key determines some non prime attribute Ashish_poonia answered Jul 1, 2025 Ashish_poonia comment Share Follow See all 2 Comments 2 2 Comments reply Sarthak_Joshi commented Jul 1, 2025 reply Follow flag Could you please explain why option C is wrong. As, WX is a candidate key and Y is a non-prime attributes which also violates 2NF. 0 0 replyShare Ashish_poonia commented Jul 2, 2025 reply Follow flag NO it does not violate 2NF,WX is determining non prime attribute we have no problem with this in 2NF problem would have been that if WX determined non prime Y partially,which is not the case here. 1 1 replyShare Please log in or register to add a comment.
