| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A Normalization Question
"Neo" <neo55592_at_hotmail.com> wrote in message
news:4b45d3ad.0407171430.7babae3_at_posting.google.com...
> > Why brown is redundant?
> >
> > Person Name
> > 1 brown
> > 2 brown
> > 3 brown
> A person is a thing.
If you say so ...
>A string is a thing.
If you say so ...
>3 persons are represented.
> Each person is named by a string. Because the three strings represent
> the same thing, the string 'brown', having three of them in one db is
> redundant.
If you say so ...
>Apparently, this is difficult to see in RM due to its
> definitions. In TM, it is easier to see that a thing (string 'brown')
> can name 0 to many other things as shown at
> www.xdb2.com/Example/ThingsNamedBrown.asp
What's wrong with this:
Person Name
1 4 2 4 3 4 Name Tongue String 4 En Brown 4 Fr Brun 4 De Braun 4 It Brunno 4 It Marrone 4 Es Marron 4 Es Castano
Oh, I forgot that It and Es are redundant also... Not to mention that RM does not distinguish between 1,2,3,4 as references and Brown, En, Fr, etc. as things.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
![]() |
![]() |