Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.glorb.com!postnews2.google.com!not-for-mail
From: neo55592@hotmail.com (Neo)
Newsgroups: comp.databases.theory
Subject: Re: A Normalization Question
Date: 6 Jul 2004 20:32:12 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <4b45d3ad.0407061932.34d640cb@posting.google.com>
References: <20040626120209.29625.00000578@mb-m16.aol.com> <swUDc.10129$Av3.4182@nwrdny01.gnilink.net> <4b45d3ad.0406300959.36b2b9d2@posting.google.com> <2kggoeF24agdU1@uni-berlin.de> <x56dnYk38c99in7dRVn-hQ@comcast.com> <4b45d3ad.0407011053.37b54dec@posting.google.com> <gu_Ec.171583$073.8609844@phobos.telenet-ops.be> <4b45d3ad.0407060953.4e111054@posting.google.com> <40EB1C2F.7B5A@assist.org>
NNTP-Posting-Host: 67.98.160.223
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1089171133 443 127.0.0.1 (7 Jul 2004 03:32:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Jul 2004 03:32:13 +0000 (UTC)
Xref: core-easynews comp.databases.theory:36657
X-Received-Date: Tue, 06 Jul 2004 20:31:22 MST (news.easynews.com)

> > "Having several copies" (ie 'brown', 'brown', 'brown') is redundant.
>
> a tuple that contained ('brown', 'brown', 'brown')
> would be representing three independent, distinct facts,
> therefore it would not be redundant.

Although each cell of the tuple represents a different thing (ie
fact), they are all named by the same thing (ie string 'brown'). The
string 'brown' is redundant. Because RM is a limited data model, it is
hard to see this fact. It is more obvious in XDb1/TDM.