Guideline for Database Testing

You have to do the following for writing the database testcases.

1. First of all you have to understand the functional requirement of the application throughly.

2. Then you have to find out the back end tables used, joined used between the tables, cursors used (if any), tiggers used(if any), stored procedures used (if any), input parmeter used and output parameters used for developing that requirement.

3. After knowing all these things you have to write the testcase with different input values for checking all the paths of SP.

One thing writing testcases for backend testing not like functinal testing. You have to use white box testing techniques.

Steps to writing test cases for database testing
***********************************************
1) Learn the functional requirement of the application (SRS) completely

2) Find out the back end tables used, joined used between the tables, cursors used (if any),
triggers used(if any), stored procedures used (if any), input parameter used and output
parameters used for developing that requirement.

3) By knowing all these things write the test case with different input values for checking and
comparing the actual results with the expected results for the application.

Note : For writing test cases for back end operations, the tester must know the white box testing.