Databases are integral part of any application. There are applications which directly operate on databases. There are other applications that send requests to the aforementioned applications. The document provides the guidelines on how to go on with the testing of applications that directly operate on Databases.
The system test of these applications mainly concentrates on testing the changes or amendment incorporated in the application. The amendments in the application can be broadly classified as
* Amendments in processing logic
* Amendments in database structure
Testing for Amendments in processing logic:
The amendment in processing logic includes the following;
* Logic to persist data onto the tables
* Logic to retrieve data from tables
* Logic to automatically update fields in tables
* Logic to run appropriate procedures, etc.
The following are the guidelines that are prescribed for such scenarios
