Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newshub.sdsu.edu!postnews2.google.com!not-for-mail
From: neo55592@hotmail.com (Neo)
Newsgroups: comp.databases.theory
Subject: Re: A Normalization Question
Date: 7 Jul 2004 11:08:28 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <4b45d3ad.0407071008.51298d73@posting.google.com>
References: <20040626120209.29625.00000578@mb-m16.aol.com> <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> <%0DGc.176627$5e4.8650851@phobos.telenet-ops.be> <4b45d3ad.0407061913.65713367@posting.google.com> <CuudnRxJ3pftGnbdRVn-gQ@comcast.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 1089223709 9872 127.0.0.1 (7 Jul 2004 18:08:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 7 Jul 2004 18:08:29 +0000 (UTC)
Xref: core-easynews comp.databases.theory:36671
X-Received-Date: Wed, 07 Jul 2004 11:07:37 MST (news.easynews.com)

> It appears to me the left vertical leg of the letter "r" in "brown" is 
> the same as the left vertical leg of the letter "n".  The curved part of 
> the "r" looks like the curved part of the "n".  Further, the circular 
> part of the "b" looks suspiciously similar to the rightmost 135 degrees 
> of the "o".  Cannot, then, this example be further "normalized"?

You are blurring two different issues.  

In the original example, because the string 'brown' (name of three
things) is stored multiple times in the db, it is a candidate for
normalization.

In the original example, because we did not store the graphical data
to render symbols on the screen, they were not a candidate for
normalization. This was left upto the the hardware/system (ie the
graphics card) which may in fact normalize some graphical parts (ie a
pixel, lines, arcs, circles, squares).

If graphical things were being stored in a db, and the db stored the
same two graphical things twice, the second one would be a candidate
for normalization.
