Request a Quote
Tell Us About Your Requierment
And We will Get back To You Soon
Name *
Company Name *
Email *
Phone *
Details *
Sum the following: *
  

Database Testing

Database testing determines the quality of a customer's experience in terms of interacting with application.

We cover following test areas as part of database testing.

Database schema testing:
  • Verifying all table names, column names for each table, column types for each table (int,tinyint,char,varchar,text,datetime etc) , whether column allows NULL or not , default definitions ,whether a default is bound to correct tables , rule definitions , whether a rule is bound to correct table or not, Whether column allows NULL or not ,Check if access privileges are granted to correct groups.
  • Verify Primary key for each table, Foreign keys, Column data types between a foreign key column and a column in other table.
  • Indexes, clustered or non clustered, unique or not unique.

Stored procedure testing:
  • Individual procedure tests - Stored procedure name, Parameter names, Parameter types and the number of parameters.
  • Outputs – Number of records returned, when output is zero, what is expected from stored procedure, query tables directly to check if stored procedure returned expected output.
  • Parameters – Run procedure with valid data, Run procedure with boundary data, Try to run procedure without mandatory parameters.
  • Error messages – Check if stored procedure triggers any error messages, index errors, trigger errors and rule errors.
  • Integration tests of procedures – Run sequence based group of procedures and check the expected flow.

Trigger testing:
  • Updating triggers – Check if triggers are generated for all the possible invalid data updates that should be prevented, check if the transactions are rolled back when update fails, try to update a record when it is still referenced in other table.
  • Inserting triggers – Check if triggers are generated for all the possible invalid data inserts that should be prevented, check if the transactions are rolled back when insert fails.
  • Delete triggers - Check if triggers are generated for invalid deletions, check if the transactions are rolled back when delete fails , try to delete a record when it is still referenced in other table.

Recent works



Why New World Software?

There are generalists and there are specialists. It makes sense to choose a firm organized around specialists—smart people succeeding every day in the global markets. With New World Software, you gain access to an expanded team of technology and functional experts who specialize in Testing Services.

To discuss about our services, expertise and how we can help you, please contact us on chandra@newworldsoftware.com or call +91-9740169197 or fill the form on left.