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. ░