Re: foundations of relational theory?

"andrewst" <member14183_at_dbforums.com> wrote in message news:3522587.1067088194_at_dbforums.com...
>
> 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? Received on Sat Oct 25 2003 - 16:33:38 CEST