The Gateway to Computer Science Excellence
+1 vote
113 views
Consider a relation R(ABCD) with functional dependency F:{ AD → B, AB → C }. Is AB → C partial or total dependency?
in Databases by Active (2.1k points) | 113 views
+1
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.
0
Yes, it is a transitive dependency.
0

https://gateoverflow.in/492/gate2008-69

its transitive dependency

+1
0
No partial dependency, no transitive dependency

will be in 3NF
0
ma'am see my comment,it is right?
0

@Lakshman Patel RJIT Bro check out the link posted by @Soumya29

0
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

@srestha ma'am

According to a similar question in ACE material, AB is considered to be a part of key.

Please log in or register to answer this question.

Related questions

0 votes
0 answers
2
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,394 answers
198,594 comments
105,445 users