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

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

(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
12 votes
12 votes
$x \rightarrow z$  (Given)

$\implies xx \rightarrow zx$ (Axiom of augmentation)  $\qquad \to(I)$

Also $x \rightarrow y$ (Given)

$\implies xz \rightarrow yz$ (Axiom of augmentation) $\qquad \to (II)$

Using $(I)$ and $(II)$ we get

$xx \rightarrow yz$ (Axiom of transitivity)

$\implies x \rightarrow yz$
selected by

Related questions

5 votes
5 votes
1 answer
1
4 votes
4 votes
1 answer
2
9 votes
9 votes
1 answer
3
go_editor asked Dec 19, 2016
1,804 views
What are the three axioms of functional dependency for the relational databases given by Armstrong.