Testing - What are ways of writing test cases for database testing?

What are ways of writing test cases for database testing?

The following are the ways to write the test cases for database testing:

1. Understand the functional requirement of the application

2. Find out the tables used, joins used between tables, cursors used, triggers used, stored procedures used, input parameters used and output parameters used.

3. Write the test case with multiple input values for checking all paths.

Writing test cases for back end testing, one should use white box testing as opposed to functional testing.

What are ways of writing test cases for database testing?

1. The backend tables used for each requirement must be mentioned.
2. Behavior of each flag and their status updates must be written.
3. If any triggers, stored procedures are used, input and output parameters can be mentioned.
4. Default values should be checked.
Testing - Different stages involved in Database Testing
Testing - Different stages involved in Database Testing - The data that is being inserted in the database must be verified. Verify if the constraints are maintained.
Testing - How to test data loading in database testing
Testing - How to test data loading in database testing - The data from source tables to target tables in terms of data types and constraints must be verified.....
Testing - Explain how to test a SQL Query in Winrunner
Testing - Explain how to test a SQL Query in Winrunner - Using Output database checkpoints, SQL manual queries options must be selected......
Post your comment