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

> > I agree that the single table solution will not scale up well,
>
> How do you figure that?

If the requirements for this solution will be extended, you will have to go splitting up that single table into two or more, depending on the attributes on hand.

> > is not
> > properly normalized,
>
> And how do you figure that?

From what we have to guess from the description of the OP. E. g. {donation_nbr, donator_name, donator_address, donation_amt, donation_date}

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

As random as possible based on what we were told about this case.

brgds

Philipp Post Received on Mon Oct 19 2009 - 17:17:08 CEST