From single table to relational.

#11

SpreadTooThin wrote:

Quote:

PS. Are you sure Orders can't be shared by multiple Customers?

--
Erick

This is the hypothetical example I used.. so ya I'm sure.

In a real world, orders can be sold to one customer but delivered to a

customer's customer.

#12

The Natural Philosopher:

Quote:

SpreadTooThin wrote:
PS. Are you sure Orders can't be shared by multiple Customers?

This is the hypothetical example I used.. so ya I'm sure.

In a real world, orders can be sold to one customer but delivered to
a customer's customer.

Well, in a real world, things can get really complicated. Orders may be
partially cancelled, extended, transferred or replaced; bills may be
split among several addressees, etcera. And all that doesn't even
involve (non-)payment.

So, if SpreadTooThin was just painting a hypothetical situation (which
I can't even read anymore, since the original post has already been
removed from my local view), then he is free to limit the circumstances
to whatever he feels appropriate.
The relevance of the hypothetical situation may disappear, though.

--
Erick

#13

Erick T. Barkhuis wrote:

Quote:

The Natural Philosopher:

SpreadTooThin wrote:
PS. Are you sure Orders can't be shared by multiple Customers?
This is the hypothetical example I used.. so ya I'm sure.

In a real world, orders can be sold to one customer but delivered to
a customer's customer.

Well, in a real world, things can get really complicated. Orders may be
partially cancelled, extended, transferred or replaced; bills may be
split among several addressees, etcera. And all that doesn't even
involve (non-)payment.

Oh yes, and split deliveries, partial payments...cancellations..credit
notes..

Bills however are normally to a single entity, theone with whom one
enters onto a contract.

Multi pary contracts are a bitch..and generally covered by 'jointly and
severally' or some other phrase that means they can't give you the
run-around.

Quote:

So, if SpreadTooThin was just painting a hypothetical situation (which
I can't even read anymore, since the original post has already been
removed from my local view), then he is free to limit the circumstances
to whatever he feels appropriate.
The relevance of the hypothetical situation may disappear, though.

Oh yes. If its designing for reality, rather than hypothesis, one had
better establish one's possible relationships, early...
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

From single table to relational.

comp.databases.mysql comp.databases.mysql

Re: From single table to relational. - 12-14-2010 , 02:06 PM

Re: From single table to relational. - 12-14-2010 , 02:46 PM

Re: From single table to relational. - 12-14-2010 , 02:53 PM