Re: relational reasoning -- why two tables and not one?

From: Roy Hann <specially_at_processed.almost.meat>
Date: Mon, 19 Oct 2009 06:13:53 -0500
Message-ID: <lcmdnTk0Ebps1EHXnZ2dnUVZ8uGdnZ2d_at_pipex.net>


Philipp Post wrote:

> Lawpoop,
>
>> A couple folks ( myself included ) thought that there should be at least two tables -- 'donors' and 'donations' . But the poster argued that no, there would never be a holiday fund drive appeal sent out to all donors, or a year-end statement, or anything of that sort. So a single table would suffice. <
>
> From your description it seems to me that the poster would like to use
> something quite simple, such as a wizard-generated bulk mailing which
> for example is available in MS Word. Usually such data source is a
> single table in MS Word, MS Excel or any database query on MS Access
> or superior systems.
>
> I agree that the single table solution will not scale up well,

How do you figure that?

> is not
> properly normalized,

And how do you figure that?

> I would therefore vote for that beeing a misunderstanding of some kind.

If we get to vote on this, I vote that you're leaping to entirely random conclusions.

-- 
Roy
Received on Mon Oct 19 2009 - 13:13:53 CEST

Original text of this message