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: one table? five tables?

Re: one table? five tables?

From: Jeffrey Flaker <jeffreyf_at_nac.net>
Date: Tue, 15 Aug 2000 16:54:40 -0400
Message-ID: <3999AE10.BD4BFA3D@nac.net>

Daniel,
Your original question was as to whether you have too many tables or not enough. To answer that question we must go back to normalization rules and analyze your data and the efficiency of the tables. There are several explanations or normalization, none are straight forward. So to get it right, I would analyze the data in a single table, then start normalizing until there are no more separation to another table or elimination of columns in a table.

I have read several normalization theories and have had the same problem......understanding it fully. Sorry this is the best that I can explain without writing a book.......

JEFF Daniel Dudley wrote:

> I'm sorry, but I can't see how the normalisation rules relate to your
> original complaint. I guess you need to spell it out for me!
>
> Daniel
>
> "Jeffrey Flaker" <jeffreyf_at_nac.net> wrote in message
> news:399865FF.96AF9510_at_nac.net...
> > also look at: http://www.datamodel.org/NormalizationRules.html
> >
> >
> > Daniel Dudley wrote:
> >
> > > And your (constructive) suggestion is...?
> > >
> > > Daniel
> > >
> > > "Jeffrey Flaker" <jeffreyf_at_nac.net> wrote in message
> > > news:39974307.17F2AFC6_at_nac.net...
> > > > Design is primarily up to the designer. Remember one thing:
 Your
 design
> > > > should allow you to modify or delete some information without
 losing
 other
> > > > valuable information. If you want to keep an archive of
 workprocess
 but
> > > > want to delete other items completely, with your suggestion ALL
 would be
> > > > lost.
> > > >
> > > > Daniel Dudley wrote:
> > > >
> > > > > "ªL¨Ž§»" <s8423022_at_cc.ncu.edu.tw> wrote in message
> > > > > news:8n515u$5ge$1_at_news.ncu.edu.tw...
> > > > > >
> > > > > > A `product' is made by it's `component' and a `component' is
 made by
> > > > > > ........SNIP........
Received on Tue Aug 15 2000 - 15:54:40 CDT

Original text of this message

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