Re: Arbitrary Constraints
Date: 26 Oct 2004 09:06:54 -0700
Message-ID: <1098806814.050294.83280_at_z14g2000cwz.googlegroups.com>
Kenneth Downs wrote:
> This may be a can of worms in asking for more constraint examples,
because I
> may have to fend off a lot of constraints that could be dealt with
with RI,
> but what I think I'm looking for are the very simple cases that are
not
> obviously structural, like simple credit limits, inventory >= 0 and
so
> forth.
A lot of constraints I come across in my working life concern dates. In previous discussions you were quite dismissive of date-related constraints, saying they reflect bad design: history tables should be maintained automatically etc. But consider a hotel reservations system, where a new room booking must not overlap another booking for the same room. That isn't history, that's the future! Received on Tue Oct 26 2004 - 18:06:54 CEST