recategorized by
1,068 views
4 votes
4 votes
Using Armstrong’s axioms of functional dependency derive the following rules:

$\{ x \rightarrow y, \: wy \rightarrow z \} \mid= xw \rightarrow z$

(Note: $x \rightarrow y$ denotes $y$ is functionally dependent on $x$, $z \subseteq y$ denotes $z$ is subset of $y$, and $\mid =$ means derives).
recategorized by

1 Answer

Best answer
6 votes
6 votes
$x \rightarrow y$ (Given)

$\implies xw \rightarrow yw$ ( using axiom of augmentation $A \rightarrow B$ $\implies AX \rightarrow BX$)

also $yw \rightarrow z$ (Given)

$\implies xw \rightarrow z$ (using Axiom of transitivity ($A \rightarrow B$ and $B \rightarrow C)$ $\implies A \rightarrow C$)
selected by

Related questions

5 votes
5 votes
1 answer
1
9 votes
9 votes
1 answer
2
go_editor asked Dec 19, 2016
1,797 views
What are the three axioms of functional dependency for the relational databases given by Armstrong.
8 votes
8 votes
1 answer
3
5 votes
5 votes
3 answers
4
go_editor asked Dec 20, 2016
1,353 views
Select SNAME from S Where SNOin (select SNO from SP where PNOin (select PNO from P Where COLOUR='BLUE'))What relations are being used in the above SQL query? Given at lea...