As individual units are developed, they are tested by the developers, reviewed by peers and certified. All units must comply with established project coding style and conventions. The code is inspected to be certain that it satisfies the requirements allotted to it in the design and in the current build. This facilitates requirement traceability.
Database development should be incremental, in builds, in the same manner as application software development. Typically, database development is treated as a secondary task or afterthought to the mainstream software development process. Changes to database structure and code should be treated the same as application source code. There are several tenets of database development that should be recognized and account for in the overall software development process:
- Database design should begin during the requirements definition phase and progress throughout the life-cycle.
- Database design and development activities affect all aspects of application software development and it is because of this fact that the database effort must be approached in a managed, coordinated manner.
- Database design is iterative and changes during the course of the system development effort to reflect changes in the design and requirements of the system.
- The database changes, structure and content, and its associated resources must be configured and managed in the same way as software is configured and managed.
- Data conversion is typically a part of every system development effort and must be carefully planned and managed to minimize the risk of populating the new database with flawed data.
- There is often a fine line between the functionality of application software and the functionality that is expected of the database. Often stored procedures or triggers can be coded in the application software, but this effort must be managed to avoid duplicate coding by application developers.
- A Database Administrator (DBA) is an essential member of any project. The administrator role, responsibilities and procedures must be clearly defined and the administrator should handle all changes to functionality, security, access, content, integrity and any other aspect of the database. In effect, the DBA is a software project manager within a project.
To view and download templates which will help you prepare for this phase click on the links below
Below is a sample data model, an essential tool used in database devlopment.
Sample Data Model.er1
Sample Data Model.pdf