Here are the common things tested using database testing:

• Schema Validation

  • Verify the names of all tables in the database.
  • Validate column names for each table.
  • Verify column types for each table.
  • Check for null values.
  • Validate default values bound to the correct table columns.
  • Verify rule definitions for table names and access privileges.

• Data Integrity

  • Validate primary keys for each table.
  • Confirm foreign keys for each table.
  • Check data types between foreign key columns and columns in other tables.
  • Verify indices, whether clustered or non-clustered, unique or not.

• Security Testing

  • Validate user login (user id, password, hostname).
  • Check database access privilege.
  • Test table access privilege.

• Functional Testing

  • Identify relevant schema, triggers, and stored procedures for a specific function.
  • Group-related functions for testing.
  • Test data flow starting from the front-end.

• Non-Functional Testing

  • Write test scripts to exercise major functions.
  • Ensure comprehensive testing of all functions over a full cycle.
  • Verify log files for deadlocks, memory failures, data corruption, etc.
  • Test data modification scenarios:
  • Repeat test cases with invalid data to assess database response. ░