Re: Alternative method to normilize tabels ...

>>Orig table:
>>
>>ORIG ( pk X, pk Y, Z, data, ...) attribute 'data' depends on X AND Z
>>
>>After split ...
>>
>>ORIG (fpkX, pkY)
>>NEW (pkX,pkZ, data)
>>
>>Does it make sence?
>
>Almost; you should also leave the column Z in the original relation. The
>general rule is that if you split off a dependency X1,..Xn -> Y1,..,Ym then
>1. in the original table you remove Y1,..,Ym
>2. you create a new table with columns X1,..,Xn,Y1,..Ym
>

Aah ... yes, ofcourse ... otherwise I lose my reference to the originating tabel ...

thanks,
Jos Received on Wed Oct 23 2002 - 11:46:06 CDT