Re: "We don't do triggers"

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 26 Nov 2003 13:50:25 -0800
Message-ID: <1069883453.698145@yasure>

Niall Litchfield wrote:

> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1069865589.637816_at_yasure...
>

>>Mike Sherrill wrote:
>>
>>
>>>On Tue, 25 Nov 2003 08:35:23 -0500, "mcstock"
>>><mcstockspamplug_at_spamdamenquery.com> wrote:
>>>
>>>
>>>
>>>>if you're referring to declarative constraints, that's a given
>>>
>>>
>>>I'm pretty sure that most of the people posting to this thread don't
>>>regard it as a given.
>>>
>>>Looks like it's time to clarify who means what when they're talking
>>>about "business logic" and "integrity constraints".  To me, it looks
>>>like some people regard them as identical, and some people regard them
>>>as different.
>>>
>>
>>By any definition you will ever learn while earning a computer science
>>degree they are different.
>>
>>The business logic is that every invoice must have an invoice number.
>>The integrity constraint is a primary key.
>>
>>The business logic is that all persons must have a gender
>>The integrity constraints are a NOT NULL and a check constraint
>>constraining entries to 'F' or 'M').

>
>
> Interestingly the business logic may well specify a set of allowable values
> for Gender well beyond 2. Possibly especially in california.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
>

My original write on this included a comment about London and I bit my tongue and removed the text. Now I regret having not taken the first shot. ;-)

Not that I don't agree with you; of course!

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Nov 26 2003 - 15:50:25 CST