| The focus of the Business Information System Specification is the generation of a set of validated and complete work products that, when transformed to a working Business Information System meets business requirements in an acceptable manner. Critical to the to this effort is the prototyped generation of working versions of the Business Information Systems. The overall outline for accomplishing this effort is described here. During the specification of Business Information Systems, the process of IV&V is necessary to ensure that the Business Information System, upon actual implementation meets a thoroughly validated set of requirements. The fundamental steps involved in the Business Information System Specification include for example: 
                                    Logical Database
                                        SQL Schema specificationTable specificationColumn specificationRelationship specificationIntegrity constraints, triggers and stored procedure specificationSQL Views specification Physical Database
                                        Data loading subsystem specificationUpdate subsystem specification Interrogation including
                                        Specification of ad hoc reporting subsystem specificationSpecification of standard reporting subsystem specification System Control including
                                        Audit trails development specificationMulti-database processing specificationBackup and recovery specificationConcurrent operations specification Testing
                                        Unit Test specificationSystem Test specificationUser Acceptance Test specification Metabase Metadata loading including 
                                        System SpecificationsEnd-user help and on-line training assistance specification Thorough prototyping of all specifications and recycling until all specifications are reviewed, revised and acceptable to subject matter experts and end users. |