1. Database testing includes performing data validity, data integrity testing, performance check related to database and testing of procedures, triggers and functions in the database. (Beaulieu, 2009)
Let's say an application that track daily transaction details of user and store the detail data in database. From database testing the following thing should be performed-
Transaction information should be store in database and it should provide exact and correct information to the user.
Information should not be lost when it storing data into database.
It should ignore the incomplete operation and should be stop by the apption and only completed transaction should be save in database
No unapproved or unauthorized access should be stopped and access only authorized to database to maintain.
Database testing is formed of three categories (Beaulieu, 2009):
Structural database testing
Functional testing
Nonfunctional testing
Structural database testing includes testing the columns and the tables, the views and the procedures. All thest done on components that even cannot be changed by the end users are also also includes in this this. From end user point of view the functional testing would be done. Mainly there are two types of testing that are involved: White box testing and Black box testing. Black box testing includes the testing of the functionality of the database and White box testing done about the structure of the database. Nonfunctional testing inclueds the testing of performing load, stress testing, checking theminimum system requirements to meet the specification of business, finding risk and optimization of the performance of database. The following tests will be performed on the above database:
Field size validation
Null values
Check constraints.
Referential integrity (Beaulieu, 2009)
Field size validation to check the length of data constraints for field size, in the departments table a record will be inserted with different values for dept_no attribute than the format used: