Database Development

Corporation for National and Community Service

STR designed and developed the eGrants system for the Corporation for National Service and Community Service. The design was produced following detailed reviews of the existing applications in use at CNS and interviews with CNS staff with different jobs, and involved the creation of process models, an entity-relationship diagram and data diagram, and form and report designs. A detailed design review refined the design and functionality of the system, which was completed in May of 2002. Grant applicants began using the system to enter their applications in June, and the first grants were awarded through the system in September.

Inter-American Foundation Grant Evaluation and Management System (GEMS)

The Grant Evaluation and Management System was designed and developed for the Inter-American Foundation to allow them to manage all aspects of their grants in a single system. Most of the reports were developed in English, French, Spanish, and Portuguese. STR developed the design specifications for the Grant Evaluation and Management System for the IAF, including process models, entity-relationship diagrams, data diagrams, module data diagrams, and sample forms and reports. Oracle’s Designer and Developer were used to develop the forms and reports. STR implemented the application, provided all user and programmer’s documentation, and is currently providing database administration and application support, including web-enabling the application for internal use, and developing new application forms in English, Spanish, and Portuguese for grant applicants to use.

United States Air Force

The Combat Effectiveness and Evaluation System (CEES) was developed for the United States Air Force to provide a desktop tool that allows real-time analysis of alternative military force capabilities in the context of the outcome of a number of representative theater-level campaign scenarios. The system consists of a large, complex Oracle database that stores scenario, force, and capability data. A graphical user interface allows a user to modify the baseline scenario data, which is passed to a series of C routines that calculate the variation in scenario outcomes resulting from the user-defined changes. Calculated outcome data is written back to the database so that it can be viewed on screen, and in fifteen different reports and ten different graphing options. The database interfaces with the off-the-shelf geographic information display system MapInfo, where scenario data can be examined in the context of geographic relationships.