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: A Normalization Question

Re: A Normalization Question

From: x <x-false_at_yahoo.com>
Date: Mon, 19 Jul 2004 20:07:44 +0300
Message-ID: <40fbffe9@post.usenet.com>

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Mon Jul 19 2004 - 12:07:44 CDT

Original text of this message

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