2 votes 2 votes Consider a relation R(ABCD) with functional dependency F:{ AD → B, AB → C }. Is AB → C partial or total dependency? Databases databases + – OneZero asked Dec 19, 2018 OneZero 608 views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply Shivam Kasat commented Dec 19, 2018 reply Follow Share it is a transitive dependency Since here candidate keys AD. AD->C , Here C is a non-prime attribute determined by combination of prime attribute and Non-prime attribute and here it is a transitive dependecny. 1 votes 1 votes Lakshman Bhaiya commented Dec 20, 2018 i edited by Lakshman Bhaiya Dec 20, 2018 reply Follow Share Yes, it is a transitive dependency. 0 votes 0 votes minal commented Dec 20, 2018 reply Follow Share https://gateoverflow.in/492/gate2008-69 its transitive dependency 0 votes 0 votes Soumya29 commented Dec 20, 2018 reply Follow Share This will help- https://gateoverflow.in/72529/confusion 1 votes 1 votes srestha commented Dec 20, 2018 reply Follow Share No partial dependency, no transitive dependency will be in 3NF 0 votes 0 votes Lakshman Bhaiya commented Dec 20, 2018 reply Follow Share ma'am see my comment,it is right? 0 votes 0 votes Shivam Kasat commented Dec 20, 2018 reply Follow Share @Lakshman Patel RJIT Bro check out the link posted by @Soumya29 0 votes 0 votes srestha commented Dec 20, 2018 reply Follow Share Navathe says from key itself remove an attribute and still if there dependency exists then it will be partial dependency Here that is not the case So, no partial dependency Now A->B->C here if B is not key or not part of key and then onlytransitive dependency exists But here AB->C B is part of key So, can we not say no transitive dependency too? 0 votes 0 votes OneZero commented Dec 20, 2018 reply Follow Share @srestha ma'am According to a similar question in ACE material, AB is considered to be a part of key. 0 votes 0 votes Please log in or register to add a comment.