Functional Dependencies
•
Definition:
A
1
, ..., A
m
à
B
1
, ..., B
n
holds in R if:
•
•
"
t, t
’
Î
R, (t.A
1
=t’.A
1
Ù
...
Ù
t.A
m
=t’.A
m
Þ
t.B
1
=t’.B
1
Ù
...
Ù
t.B
m
=t’.B
m
)
•
Bm
...
B1
Am
...
A1
if t, t’ agree here
then t, t’ agree here
t
t’
R