Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Alternative method to normilize tabels ...

Re: Alternative method to normilize tabels ...

From: <joske_at_home>
Date: Wed, 23 Oct 2002 16:46:06 GMT
Message-ID: <inAt9.175200$8o4.28175@afrodite.telenet-ops.be>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US