3 votes 3 votes R(A,B,C,D,E,F,G,H) A->BC B->CFH CH->G E->A A->EG what is the number of candidate key Databases databases database-normalization candidate-key + – iamHarin asked Jul 24, 2017 retagged Aug 4, 2017 by Arjun iamHarin 701 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 4 AD,BD,ED,FD set2018 answered Jul 25, 2017 set2018 comment Share Follow See all 2 Comments See all 2 2 Comments reply sumit goyal 1 commented Jul 25, 2017 i moved by sumit goyal 1 Feb 2, 2018 reply Follow Share https://gateoverflow.in/1558/gate2013-54 check this F-> EG is there you wriiten wrong question 0 votes 0 votes srai1928 commented Oct 15, 2019 reply Follow Share i think only 2 AD and ED bcoz D is not in Functional dependency so must included and if we find AD closure then we get all attributes , then we replace A with E (with the help of 4th FD) now if we see for candidate key of 2 attribute then we unable to find boz only A can determine E and only E can determine A..... so we check for 3 attribute dependency (here also d must be included ) by excluding E and A then we can't able to find A and E with the help of any combination :(( so only 2 possible 1 votes 1 votes Please log in or register to add a comment.