1,750 views

2 Answers

Best answer
6 votes
6 votes

No, None of $AC \rightarrow D$ and $BD \rightarrow E $  is a Partial dependency.

Partial Dependency :
If a non-prime attribute of the relation is getting derived by only a part of the composite candidate key then such dependency is defined as partial dependency.

Since, $AB$ is the Candidate key here, So, To have Partial dependency in this Relation $A$ only Or $B$ only should have derived any of $C,D,E$. Which is Not the case here.


The Given FD's are Transitive Dependencies :

Transitive Dependency

In Simple words, If a non-prime attribute of the relation is getting derived Transitively by Candidate key(s). So, A Partial Dependency is Also a Transitive dependency. In some sense a partial dependency is a special case of a transitive dependency.

If a non-prime attribute of the relation is getting derived by either another non-prime attribute or by the combination of part of the candidate key along with a non-prime attribute or by a Part of Candidate key then such dependency would be defined as transitive dependency.

Here, in the given relation, the combination of part of the candidate key along with a non-prime attribute is deriving Non-key attribute.

$AC \rightarrow D$ ...Where $A$ is Part of Candidate key and $C,D$ are Non-key attributes.

and $BD \rightarrow E $... Where $B$ is Part of Candidate key and $D,E$ are Non-key attributes.

NOTE that In some sense a partial dependency is a special case of a transitive dependency. On the other hand there are transitive dependencies that are not caused by partial dependencies. 

edited by
0 votes
0 votes

prime attributes:-

     which attributes are part of atleast one candidate key.

non-prime attributes :-

       which attributes are not part of atleast one candidate key.

prime attribute + non-prime attribute = non-key.

key+prime attribute = key

key+non-prime attribute = key

non-prime attribute + non-prime attribute = non-key

prime attribute + prime attribute = may form the key or part of any candidate key or not pat of any key


According to your question, AB is Primary Key ===> A and B are prime Attributes and C and D are non-prime attributes

∴ AC ==> prime attribute + non-prime attribute = non-key

AC -> D ===> non-key -> non-key ===> Transitive Dependency

∴ BD ==> prime attribute + non-prime attribute = non-key

BD -> E ===> non-key -> non-key ===> Transitive Dependency

edited by

Related questions

0 votes
0 votes
1 answer
1
Mk Utkarsh asked Nov 24, 2017
549 views
Please explain with example how lossless decomposition into BCNF is possible but dependency preservating BCNF decomposition may not be possible for all relations?
1 votes
1 votes
2 answers
2
aditi19 asked Apr 14, 2019
1,844 views
Decompose into BCNFR(A, B, C, D, E)FD: AB->C, C->D, D>B, D->E
3 votes
3 votes
1 answer
3
aditi19 asked Nov 29, 2018
1,095 views
R(A, B, C, D)FD: B->C, D->Ais the following decomposition in BCNF?R1(B, C), R2(A, D), R3(C, D)
2 votes
2 votes
1 answer
4
Na462 asked Jul 14, 2018
1,856 views