Building a new database is a complex iterative process. Information requirements are gathered and are logically grouped into Entity Relationships within a Conceptual Data Model (CDM).

 A Physical Data Model (PDM) is generated from the CDM yielding Tables, Columns, Primary and Foreign Keys. Adding Indexes, Views, Referential Integrity, Stored Procedures and Triggers further refine the PDM.

 Lastly a Data Definition script is generated from the PDM and is then loaded into the database.

 SRCC has experience creating and reverse engineering databases using PowerDesigner, DataArchitect, AppModeler and Irwin software tools.