Re: Alternative method to normilize tabels ...

From: joske_at_home <>
Date: Wed, 23 Oct 2002 16:46:06 GMT
Message-ID: <inAt9.175200$>

>>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 ...

Jos Received on Wed Oct 23 2002 - 18:46:06 CEST

Original text of this message