Re: Proposal: 6NF

David Cressey wrote:

>
> My phrase "a systematic way of dealing with missing data" is from Codd's
> twelve rules. I think Codd got this one right. Not because the RDM is any
> more dependent on dealing with missing data than any other data model might
> be, but because, in the real world, you are going to be faced with the
> reality that data that "ought to be there" isn't there.

Here is an example:

Creating an order in a table for a non-existant customer?

> You either have a systematic way of dealing with missing data, or you deal
> with missing data in an unsystematic way, when the eventuality happens.
> Which is worse?
>

I would rather have a system that would refuse to create an order for a non existant customer. Received on Wed Oct 04 2006 - 00:58:05 CEST