The 3 types of Database Testing are
- Structural Testing
- Functional Testing
- Non-functional Testing
Structural database testing
The structural data testing involves the validation of all those elements inside the data repository that are used primarily for the storage of data and which are not allowed to be directly manipulated by the end users. The validation of the database servers is also a very important consideration in these types of testing. The successful completion of this phase by the testers involves mastery in SQL queries.
The chief aspect of schema testing is to ensure that the schema mapping between the front end and back end are similar. Thus, we may also refer to schema testing as mapping testing.
Database table, column testing
Let us look into various checks for database and column testing.
- Whether the mapping of the database fields and columns in the back end is compatible with those mappings in the front end.
- Validation of the length and naming convention of the database fields and columns as specified by the requirements.
- Validation of the presence of any unused/unmapped database tables/columns.