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

$\{ x \rightarrow y, \: z \subset y \} \mid= x \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
7 votes
7 votes
$\because z\subset y$, Trivially $y\rightarrow z $ . Now by transitivity, $x \rightarrow y, y \rightarrow z \implies x \rightarrow z$
selected by

Related questions

4 votes
4 votes
1 answer
1
9 votes
9 votes
1 answer
2
go_editor asked Dec 19, 2016
1,792 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,351 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...