Re: candidate keys in abstract parent relations

"Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in message news:dr2bc2$9gs$1$8300dec7_at_news.demon.co.uk...
> I totally agree with your post there, cool! But it leads me to a question
> that I'd like to throw out in the airways...
>
> We can (and do) build logic in to protect ourselves to an extent, for
> example make sure a date of birth is realistic; somebody isn't claiming a
> pension where they are only 16 etc...
>
> That leads me to the question though, those type of data validation are
more
> business logic aren't they or perhaps not? To what extent do we defend the
> validity of the data in the database [snip].

I suppose I'd take the view that it doesn't matter how you classify them as long as it really is a rule of the business. If it's easy to do, do it. Otherwise don't. (I leave it to the implementer to define "easy". :-)

Roy Received on Mon Jan 23 2006 - 12:03:44 CET