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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Normalisation 4NF

Re: Normalisation 4NF

From: Al <question2004_at_btinternet.com>
Date: Mon, 1 Nov 2004 01:49:19 +0000 (UTC)
Message-ID: <cm44mu$igd$1@sparta.btinternet.com>


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

Original text of this message

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