2 votes 2 votes Databases database-normalization test-series + – ben10 asked Aug 29, 2018 retagged Aug 29, 2018 by Sayan Bose ben10 617 views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply Show 6 previous comments Shaik Masthan commented Aug 29, 2018 reply Follow Share @ben10 what is the problem you are facing with D? 0 votes 0 votes Shaik Masthan commented Aug 29, 2018 i edited by Shaik Masthan Aug 29, 2018 reply Follow Share What is wrong with option B if we take AB as key? if we take AB as key, Option B is in 2NF ? no it can't be in 2NF due to B->E is lead to PFD moreover it is loss-less decomposition but not dependency preserving ( D->E is not preserving ) Question is not standard... we can skip this question.... nothing is useful on discussing this question. 0 votes 0 votes Shaik Masthan commented Aug 29, 2018 reply Follow Share @Minipanda, i edited my comments, please read it 0 votes 0 votes Please log in or register to add a comment.
–1 votes –1 votes I think option A is correct, since AB, BC, F are the candidate keys possible, B-->D and D-->E are in 1NF and 2NF respectivley. if we decompose correctly we get the relations which are in option A donnie answered Sep 15, 2018 donnie comment Share Follow See all 0 reply Please log in or register to add a comment.