Re: foundations of relational theory?

From: Marshall Spight <mspight_at_dnai.com>
Date: Sat, 25 Oct 2003 17:59:17 GMT
Message-ID: <VRymb.26941$HS4.101098@attbi_s01>

"Bob Badour" <bbadour_at_golden.net> wrote in message news:3NydnUri4LY95geiU-KYuA_at_golden.net...
>
> > "Anthony W. Youngman" <thewolery_at_nospam.demon.co.uk> wrote in message
> news:Ko91hKAyFDj$EwOn_at_thewolery.demon.co.uk...
> > >
> > > My favourite example is always to quote an invoice. How many tables do
> > > you need in a relational database? One for the invoice itself, one for
> > > the addresses (two at least, billing and shipping), one for the line
> > > detail, a couple maybe for the relationships ...
>
> To answer Wol's question: One needs only one relation. Whether this is the
> best solution is another matter.

Nice point.

Marshall Received on Sat Oct 25 2003 - 12:59:17 CDT