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: Daniel Dudley <dudley_at_online.no>
Date: Thu, 17 Aug 2000 22:44:46 +0200
Message-ID: <iaYm5.5194$By6.87432@news1.online.no>

"Jeffrey Flaker" <jeffreyf_at_nac.net> wrote in message news:3999AE10.BD4BFA3D_at_nac.net...
> Daniel,
> Your original question was as to whether you have too many tables
> or not enough.

No, that wasn't MY original question; do try to get your facts right, Jeff.

> 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.

Presumeably, basic advice directed at the student (thread origin).

> 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.......

I guess we can safely conclude that your criticism of my message was both unfounded and misdirected, 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 Thu Aug 17 2000 - 15:44:46 CDT

Original text of this message

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