Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews2.google.com!not-for-mail From: neo55592@hotmail.com (Neo) Newsgroups: comp.databases.theory Subject: Re: A Normalization Question Date: 7 Jul 2004 10:29:23 -0700 Organization: http://groups.google.com Lines: 33 Message-ID: <4b45d3ad.0407070929.6ad1563@posting.google.com> References: <20040626120209.29625.00000578@mb-m16.aol.com> <4b45d3ad.0406300959.36b2b9d2@posting.google.com> <2kggoeF24agdU1@uni-berlin.de> <4b45d3ad.0407011053.37b54dec@posting.google.com> <4b45d3ad.0407060953.4e111054@posting.google.com> <%0DGc.176627$5e4.8650851@phobos.telenet-ops.be> <4b45d3ad.0407061913.65713367@posting.google.com> NNTP-Posting-Host: 67.98.160.223 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1089221363 7822 127.0.0.1 (7 Jul 2004 17:29:23 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 7 Jul 2004 17:29:23 +0000 (UTC) Xref: core-easynews comp.databases.theory:36670 X-Received-Date: Wed, 07 Jul 2004 10:28:31 MST (news.easynews.com) > You have to show that in the tuple ("brown", "brown", "brown") the > string "brown" each time represents the same fact. A clearification. While the 1st, 2nd and 3rd "brown" in the above tuple do represent different things (ie fact), the name of each of those things is the same (ie string "brown") and it is the name of those things that can be normalized. Below is approximately how XDb1 normalizes the above tuple. Thing Person Color Street 1 ->2 ->3 ->4 Person Name 2 ->5 Color Name 3 ->5 Street Name 4 ->5 Name Sym1 Sym2 Sym3 Sym4 Sym5 .... 5 ->6, ->7, ->8, ->9, ->10 Symbol 6 b 7 r 8 o 9 w 10 n For more info, see www.xdb1.com/GUI/Labels.asp