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.