Version_No Description updated By Date
TC # Story ID Title
TC Description/Objective TC Steps
To check, whether the database serverconfigurations are as specified by
the business requirements or not.
Check that database server is able to cater the needs of maximum allowed
number of user transactions as specified by the business requirements
specifications.
To check, whwther the mapping of the database fields and columns in the
back end is compatible with those mappings in the front-end.
To verify the database name, verifying the data service, dump device and
log device.
To verify, whether enough space is allocated or not for each database and
verifying database option settings.
To verify the data flowand check where you can verify the data beginning
from the front-end.
To verify the log files to verify any deadlock, failure, data corruption, out of
memory etc
Write queries from the front-endand perform the searches. Pick an
existing record, modify the values ofsome fieldsand save the record(it
includes UPDATE statement or UPDATE stored procedures, UPDATE
triggers)
Insert a new menu item in a front-end window. Fill the information and
savethe record. (It involves INSERT statements or insertion stored
procedures, deletion triggers)
Pick an existing record, click on DELETE or REMOVE button and perform
the deletion. (It involves the DELETE statement, deletion of stored
procedures, deletion of triggers)
To verify, if correct data is getting saved in database upon successful page
submit.
To verify values for columns which are not accepting NULL values
Check for data integrity. Data should be stored in single or multiple tables
based on design.
Tables should have Primary Key column.
For every database add/update operation log should be added.
To verify that, data is committed to database only, when the operation is
completed successfully.
Data should be Rolled back in case of failed transactions.
To verify that if data is not truncated while saving. Field length shown to
user on the page and in database should be same.
Check numeric fields with minimum, maximum and float values.
Check numeric fields with negative values (i.e. for both acceptance and
non-acceptance)
Check if radio button and drop-down list options are saved correctly in the
database.
Check if the database fields are designed with correct data type and data
length.
Check if all the table constraints like a Primary-Key, Foreign-Key etc are
implemented correctly.
Test stored procedures and triggers with sample input data.
NULL values should not be allowed for the Primary-Key column.
Time in retrieving or updating the data or records.
To verify the database performance in terms of time taken, for the
execution of lesser number of queries for small set of records.
To verify, whether database performance in terms of time taken, for the
execution of queries pertaining to comparatively large set of records.
To ensure that correct and standard coding convention is adopted and
followed for the stored procedures.
Verifying and validating the attributes and parameters associated with
each procedure.
Evaluating the working or execution of all stored procedures in the
presence of blank or empty database.
Actual Result
Expected Result
Actual Result Status
Tested By Execution Date QA-Comments
Comments
Status Pass
