writing test cases for database testing

Structure of a Database Test Case

• Test case ID and title: a unique identifier and short description.
• Preconditions: the state of the data before the test runs.
• Steps: the exact actions or queries to execute.
• Expected result: the exact data outcome expected (e.g., row count, specific field values).
• Actual result and status: what actually happened, and pass/fail.

Example Scenario

For a "delete user" feature: precondition — a user with ID 101 exists; step — trigger the delete action; expected result — a query for that user ID returns zero rows, and any related records are handled according to the defined cascade or restrict rule.