Re: No foreign keys??? What the???

Sybrand Bakker has the better view on constraints. Yes, enforce many constraints consistantly across the system at the database level.

Most developers have only their single report or application in mind. DBAs must take a global view, many reports and programs hit a database, and to have all developers enforce a consistent set of constraints in the spaghetti they call code is only possible in a few highly organized groups.

Most corporations and government development is done in chaos, with few groups able to consistantly develop reasonable code. To help developers with constraints removes some of the chaos from the system.

Remember, NASA programmers recently crashed a polar lander on Mars because a couple developer groups enforced different constraints on the same system.

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.tc.umn.edu/~hause011


---------------------------------------------------------