Re: Examples of SQL anomalies?

From: paul c <toledobysea_at_ac.ooyah>
Date: Wed, 02 Jul 2008 15:56:11 GMT
Message-ID: <vyNak.51215$Jx.46854_at_pd7urf1no>

-CELKO- wrote:

>>> Once again you are introducing confusion, in this case muddying the waters with unstated design questions, confusing a system that is designed to anticipate suppliers and bills with one that isn't. <<

> Do you really find that a credit balance is not a common business
> practice? What I am pointing out is that a zero is a value on a scale
> and a NULL or other missing value indicators is not. Would you like
> to go into Codd's A and I markers?
> Instead of rudely ranting about illiteracy (while misspelling
> "tomorrow"), show us how to indicate when a $0.00 payment is a credit
> balance on an actual billing or a lack of a payment on a non-existent
> billing. The only thing that comes to mind is a flag of some kind
> which splits the single scalar value over two or more columns in
> violation of 1NF and leads to user-defined behaviors rather than
> guaranteed consistent behaviors.

Your inability to parse what I wrote, imagining possibilities that aren't there, demonstrates the very illiteracy I mentioned.

You are promoting an extremely faux technocracy, in effect suggesting that the average business user needs to master various philosophical gobbledygook. Instead of varying the case at hand ad nauseum, what YOU should do is present the scheme and predicates you want to talk about so that the real experts here can examine it for whatever it is. Received on Wed Jul 02 2008 - 17:56:11 CEST

Original text of this message