Re: Data Constraints Vs Application Constraints

If possible, setup a copy of the db somewhere (might not be possible due to size and platform), and try to add as many f.k and check constraints that time admits. If the database have been around for a while, you are very likely to find violations in the data. That should indicate why dataintegrity rules should be enforced in the database.

Main argument for your position is of course that data is better protected that way (as indicated above). Other arguments that come to mind are, it is much easier to maintain and understand.

Just my 2 skr thoughts Received on Sun Mar 13 2005 - 00:49:38 CST