Re: Proposal: 6NF
From: paul c <toledobythesea_at_oohay.ac>
Date: Fri, 29 Sep 2006 23:27:50 GMT
Message-ID: <WZhTg.67226$5R2.18926_at_pd7urf3no>
>
> How so? Plenty of people have nulls in 3NF. How is no nulls necessary
> for 1NF?
>
Date: Fri, 29 Sep 2006 23:27:50 GMT
Message-ID: <WZhTg.67226$5R2.18926_at_pd7urf3no>
Karen Hill wrote:
> J M Davitt wrote:
>> Karen Hill wrote: >>> 6NF would be a database that uses no Nulls. >> Um, "no nulls" is necessary for 1NF. And I >> believe someone already has dibs on "6NF." >>
>
> How so? Plenty of people have nulls in 3NF. How is no nulls necessary
> for 1NF?
>
I think JM is saying nulls aren't possible in 1NF, ergo not either in
3NF. Just because somebody thinks they have 3NF with nulls, doesn't
mean they do, no matter what their SQL product documentation tells them.
p