Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Normalisation 4NF
You mean you don't know the answer!! Senior DBA?
"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:s5qao0t1rvvkrejr2ck5dlti48ho9pp45p_at_4ax.com...
> On Sun, 31 Oct 2004 19:10:29 +0000 (UTC), "Al"
> <question2004_at_btinternet.com> wrote:
>
>>Hi
>>Can any one help me understand the difference between 4NF and 1NF. These
>>both refer to a field that has more than one value - so what is the
>>difference?
>>
>>All books I have looked at only consider the 4NF on its own and
>>none of them shows an example starting from 1NF and going through all
>>stages
>>right to 4NF.
>>So it is difficult for me to see why the multi-valued field has not been
>>taken out
>>when examining the repeating groups at the stage of 1NF.
>>
>>I appreciate a clear explanation or full example showing 1NF to 4NF..
>>
>>Al
>>
>
>
> How much are you willing to pay? This is really an 'assignment'
> (probably also your homework) of several hours, so beyond the scope of
> a *volunteer* newsgroup.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sun Oct 31 2004 - 19:49:19 CST