Understand your Applications
Every application requires a comprehensive entity-relationship diagram to fully understand how the data files inter-relate. Sapphire Analysis automatically builds a repository of all the foreign key relationships for the complete application by determining the origin of every keyed or joined access in every program. This is then viewed through our truly interactive entity-relationship diagrammer.
The benefits of DB-centric programming are you do it once in the DB and you no longer have to do it in the programs.
In a perfect world, you would have an I/O server handling the add update and informational data requests with trigger programs enforcing the business rules.
This is exactly the information you will need to add constraints to your DB which will negate the need to do so in your programs.
We can help get you there.