Re: Network Example: Sibling of Opposite Gender

Cimode wrote:
[...]
> Also you should keep in mind that NO NULL value should be allowed in
> the first place. Any solution involving NULLS is not 1NF and therefore
> is a hack...

I did not have the time to discuss this earlier, but what you say is: as long as there are nulls in a schema it doesn't matter much (regarding normal forms), what we do in the schema, it is till not 1NF and hence, not in any other normal form as well. To me it seems to hash. Clearly (IMO) there are better and worse schema's where null is present, agreed? Without giving it to much thought there might - from a practical point of view - be a need to distinguish *pure* NF from NF *infected* with nulls. I hate to see the cleaning I have done in my current project a total waste of time because of a few lousy nulls :-)

/Lennart Received on Sat Dec 30 2006 - 18:48:12 CET