Re: NULLs

On Sat, 29 Dec 2007 10:34:06 -0800 (PST), Marshall wrote:

>On Dec 28, 2:59 pm, Hugo Kornelis
><h..._at_perFact.REMOVETHIS.info.INVALID> wrote:
>>
>> 3VL is not a result of using NULL to represent missing information, but
>> a result of allowing missing information. IMO, there are only two
>> options: either you deal with missing information, and with the 3VL that
>> results from it -- or you somehow alter reality so that information is
>> never missing again, for any reason.
>
>Full normalization is a third option.

Hi Marshall,

As in "one table per elementary fact type"? Full agreement here, see my message to Jim.

I think I addressed the rest of your message in my reply to David. Let me know if you think I failed to address any of your points.

Best, Hugo Received on Thu Jan 03 2008 - 17:14:38 CST