Database Testing for Quality Driven Products

What to test in Database Testing. Scope of database testing
Once you get the database design or knowledge of database design, and then start developing test cases. Test cases for the Database testing should cover:

1. Size of Data and Columns
a. Column size in tables and input/output size in UI, API should be same.
b. Size should be as per Design
c. Size of Output in UI, API should be same as calculated columns.

2. Type of Data and Columns
a. Column type in tables and inputs/output type at UI, API should be same/compatible
b. Types should be as per Design

3. Violation of Primary key/Foreign keys/ Constraints

a. Whether Null/duplicate values can be inserted directly/or if possible from UI.
b. Foreign key violations in Insert, Update, Delete; directly or through application.
c. Column Level Constraints such as Default value, ranges, domain etc.

4. Stored Procedures (SP)
a. Check if desired result is produce by SP for all scenarios.
b. Test for correct parameters (count, sequence, type)
c. Test for the Output parameter

5. Functions
a. Check if desired result is produce by Function for all scenarios.
b. Check if correct result returned.
c. Check if returned result correctly collected.

6. Triggers
a. Check for correct Trigger invoked on events such as insert/delete/update.
b. Check if desired result is produce by Triggers for all scenarios.

7. Transaction
a. Test for Failed Transactions
b. Test for Pass Transaction
c. Check all action in SP, Function, Trigger, are in Transaction.
d. Commit/Rollback is used appropriately.