Databases Testing

Databases play an important role in web application technology, housing the content that the web application manages, running queries and fulfilling user requests for data storage.

The most commonly used type of database in web applications is the relational database and it’s managed by SQL to write, retrieve and editing of information.In general, there are two types of errors that may occur, data integrity errors and output errors.

Data integrity errors refer to missing or wrong data in tables and output errors are errors in writing, editing or reading operations in the tables. The issue is to test the functionality of the database, not the content and focus here is therefore on output errors. Verify that queries, writing, retrieving or editing in the database is performed in a correct way.

Issues to test are:

1. Creation of tables
2. Indexing of data
3. Writing and editing in tables (for example valid numbers or characters, input longer than field etc.)
4. Reading from tables.