Re: Base Normal Form

Gene Wirchenko wrote:
> On Fri, 08 Jul 2005 22:42:27 GMT, Jan Hidders
> <jan.hidders_at_REMOVETHIS.pandora.be> wrote:
>
> [snip]
>
>

>>Note by the way that the link between functional dependencies and 
>>interpreting relations as functions is very close. If the relation 
>>R(A,B,C,D,E) has the dependencies AB->C and BD->E and ABD->C the I 
>>wouldn't say it represents a function, I would say it represents three 
>>functions. 


> 

>      I struggle to follow these arguments.  In the above, I think that

Yes, well observed, the FD ABC->C is redundant.

> but what is the point?

A relation can sometimes represent several functions, not just one.

• Jan Hidders