Re: foundations of relational theory?

Originally posted by Bob Badour

> "andrewst" <member14183_at_dbforums.com> wrote in message

> news:3522587.1067088194_at_dbforums.com"]news:3522587.1067088194_at_d-
> bforums.com[/url]...

> > Originally posted by Mike Preece

> > > > > Pick file layout description:

> > > > > File: INVOICES

> > > > > ID: Invoice Number

> > > > > 001: Product codes (multivalued)

> > > > > 002: Quantity ordered (multivalued)

> > > > > 003: Requested Ship-by Dates (multivalued)

> > > > > 004: Quantity despatched - for each partial shipment

> > > (subvalued)

> > > > > 005: Despatched Date for each partial shipment

> > > (subvalued)

> > > > >

> > >

> > > <big snip>

> > >

> > > In the Pick database as described, there is one file. No
> pointers to

> > > related data. All of the related data is in a single
> item.

> > >

> > In that case, where do the Product Codes come from? Does the
> clerk just

> > invent them as s/he types in the order?

>

> Perhaps even more illuminating: Where do the invoice numbers come
> from? And

> where are we shipping things? Who is paying?

Before anyone asks, the secretary *is* wearing knickers.

--
Posted via http://dbforums.com