Re: Can these constraint be implemented in an RDBMS ?

"ben brugman" <ben_at_niethier.nl> wrote in message news:c2094f$q3$1_at_reader08.wxs.nl...
> Hello readers,
>
> In another thread I was asked to produce an example which
> can not be implemented with RDBMS constraints.
> I have given this some thought.
> This is a long mail, so if you do not want to 'waste' your time,
> you should not read on or attempt a solution. The length
> was because I wanted to be precise.
> (I tried to be precise, I do not know if I have succeeded in that).
>
> Thanks for any participation,
> Ben Brugman
>
> So I have tried to come up with an example according to this
> request. I came up with an example, which I think is difficult
> to implement. (But I do not know if I have succeeded).
>
> Below I have written an example for an imaginairy customer
> who runs a special kind of financial institution. The request
> and requirements are written down in terms the imaginairy
> customer understands. This should be implemented, the customer
> has specifically stated that no extra constraints are to be
> implemented without his consent. So his customers do not get
> any extra limitations not given by the requirements of him.
> Because it is an accounting problem the amounts
> have to be kept exact to the currency the customer is using.
> (cents or pennies). The total amount of money does not
> exceed 100 miljoen of the currency. (There is only one currency
> to be accounted for).
>
> The implementation has to be done in Oracle or SQL-server.

This has nothing to with difficulty, but with a poor choice of dbms. Received on Tue Mar 02 2004 - 05:29:59 CET