Re: Proposal: 6NF

From: Karen Hill <karen_hill22_at_yahoo.com>
Date: 3 Oct 2006 15:58:05 -0700
Message-ID: <1159916285.329982.303100@c28g2000cwb.googlegroups.com>

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 Tue Oct 03 2006 - 17:58:05 CDT