Values for only some constraints in the database

From: Dawn M. Wolthuis <dwolt_at_tincat-group.com>
Date: Sat, 5 Jun 2004 10:32:34 -0500
Message-ID: <c9sp2n$ljn$1_at_news.netins.net>

Why do we have values for "code files" such as state codes, marital status codes, or classification codes in their own data tables while other values for constraints, such as a number having to be positive or within a given range, in constraints, outside of the database?

Why are any constraints (other than foreign keys) not stored within the database as with any other relevant data? Rules are a form of constraint that is stored in the database -- why have any such information in a proprietary database constraint rather than encoded with the data?

--dawn Received on Sat Jun 05 2004 - 17:32:34 CEST

This message: [ Message body ]
Next message: Dawn M. Wolthuis: "Re: Where to discuss relational modelling?"
Previous message: Alan: "Re: Entry Points to the Data"
Next in thread: Alan: "Re: Values for only some constraints in the database"
Reply: Alan: "Re: Values for only some constraints in the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message