From: "x" Newsgroups: comp.databases.theory 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> <40EB1C2F.7B5A@assist.org> <2l2cohF7alv2U1@uni-berlin.de> Subject: Re: A Normalization Question Date: Wed, 7 Jul 2004 18:28:08 +0300 Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 81.196.98.200 X-Original-NNTP-Posting-Host: 81.196.98.200 Message-ID: <40ec15dc@post.usenet.com> X-Trace: post.usenet.com 1089213916 81.196.98.200 (7 Jul 2004 10:25:16 -0500) Organization: Usenet.com http://www.usenet.com 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet! X-Comments: This message was posted through Usenet.com's, FREE publicly accessible Usenet Server - "post.usenet.com" X-Comments2: IMPORTANT: Usenet.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out2.nuthinbutnews.com!local!post.usenet.com!not-for-mail Xref: core-easynews comp.databases.theory:36668 X-Received-Date: Wed, 07 Jul 2004 08:24:27 MST (news.easynews.com) **** Post for FREE via your newsreader at post.usenet.com **** "Alan" wrote in message news:2l2cohF7alv2U1@uni-berlin.de... > Here's an idea. To achieve perfect normalization (zero redundancy), there > should be a database that contains one table for each possible attribute in > the universe- that way each value is stored only once. So, there would be a > table called COLOR with every possible color stored in it. Another table > called NUMBERS with Numbers stored in it (no sense storing a number more > than once), and so on. Then, all you need to do is create tables that run > your business with meaningless id codes in them so you can connect all of > your attributes into rows of business data. But wait, these codes are > numbers. No sense storing those again. Lets create an ID column for the ID > column. No, wait... Lather, rinse, repeat, lather, rinse, repeat, lather, > rinse.... He might do just that (with an SQL DBMS) for saving disk space. :-) -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=