4 votes 4 votes Databases databases ace-test-series database-normalization minimal-cover + – tusharforever asked Oct 29, 2018 edited Mar 3, 2019 by I_am_winner tusharforever 2.4k views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Shaik Masthan commented Oct 29, 2018 reply Follow Share as per my knowledge, in the FD CD -> E, D is not redundant.... why ? due to CD -> E only, C -> D happens via E ->A A -> B and B -> D. what is the solution they provided? 1 votes 1 votes tusharforever commented Oct 30, 2018 reply Follow Share Yes that's what I did wrong in this question.. I chose A as answer but answer is B 0 votes 0 votes vupadhayayx86 commented Nov 5, 2019 reply Follow Share @Shaik Masthan @tusharforever @srestha I have a doubt here. CD ---> E , D is extraneous attribute only if C closure can generate D on removal of D? I dont get this condition would you please elaborate? 0 votes 0 votes Shaik Masthan commented Nov 6, 2019 reply Follow Share i didn't get your doubt correctly 0 votes 0 votes vupadhayayx86 commented Nov 6, 2019 reply Follow Share @Shaik Masthan My doubt is why in the FD CD -> E, D is not redundant....? 0 votes 0 votes Shaik Masthan commented Nov 6, 2019 reply Follow Share Then no comments 0 votes 0 votes vupadhayayx86 commented Nov 6, 2019 reply Follow Share Thanks alot I appreciate your time.!! 1 votes 1 votes Varun Raj Akula commented Mar 12, 2022 reply Follow Share Given FD is already a canonical cover. 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes Answer is b because left side of each function dependencies is unique. Jony Bhatt answered Oct 31, 2018 Jony Bhatt comment Share Follow See all 2 Comments See all 2 2 Comments reply kumar.dilip commented Oct 31, 2018 reply Follow Share @Jony Bhatt What do you mean by left side of each function is unique?? 0 votes 0 votes Sarang commented Dec 5, 2019 reply Follow Share The condition for which you talking about "left side of each function dependencies is unique", may be necessary but not sufficient. 0 votes 0 votes Please log in or register to add a comment.