1 1 vote For the above que which one is correct ??? C/D?? Databases + – Hira Thakur 861 views answer comment Share Follow Print See all 2 Comments 2 2 Comments reply sachin! commented Sep 5, 2017 reply Follow flag option c 0 0 replyShare Ashwani Kumar 2 commented Sep 5, 2017 reply Follow flag BC->D is satisfying in the given relation which is independent of a. So there is no such value of 'a' which can voilate BC->D. Hence option d) 0 0 replyShare Please log in or register to add a comment.
0 0 votes D........bcz this FD relation is not violated bcz of A it is violated bcz of B and C. Ravi prakash pandey answered Sep 5, 2017 Ravi prakash pandey comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes Option D is correct Because Functional dependency BC -> D is independent of A Ashin P Chandran answered Sep 6, 2017 Ashin P Chandran comment Share Follow 0 reply Please log in or register to add a comment.
0 0 votes as we can see in the FD: BC->D, there attributes doesn't depend on attribute A at all. In addition to that if we observe carefully then BC->D already failed in the given table. So whatever be the value of A the given FD will not hold at all. Pratap Chandra answered Nov 25, 2017 Pratap Chandra comment Share Follow 0 reply Please log in or register to add a comment.