Re: Lost Schema

> >Suppose you have at some point in time lots of relations and you had to
> >build a universal relation (or in general you may have a big big
relation).
> >The point is to analyze its data and induce a new schema/description of
> >this.
>
> Yes, it's called database normalization; you find out the (functional,
> multi-valued, join) dependencies in your big table and then split it into
> smaller tables. If you do this well you will find what the original tables
> were or should have been :-).

I understand that... but norm/tion starts when you know the fd's. Is there any easy way to find fd's in a huge relation ?

Any pointers or software would be helpful.

Thanks.

P Received on Mon May 20 2002 - 06:31:50 CEST