For writing test cases in Database first one should define the project name, then module,Bug number,objective,steps/action undertaken,expected result,actual result, then status, priority and severity.
RE: What is way of writing testcases for database test...
For writing test cases in Database first one should define the project name then module Bug number objective steps/action undertaken expected result actual result then status priority and severity.
RE: What is way of writing testcases for database test...
For writing test cases in Database first one should define the project name then module Bug number objective steps/action undertaken expected result actual result then status priority and severity.
RE: What is way of writing testcases for database test...
Normallyl how do we write the test cases for different applications as same as Database testing also (inputs and Outputs and expected results) .Am i right please correct me
RE: What is way of writing testcases for database test...
You have to do the following for writing the database testcases.
1. First of all you have to understand the functional requirement of the application throughly.
2. Then you have to find out the back end tables used joined used between the tables cursors used (if any) tiggers used(if any) stored procedures used (if any) input parmeter used and output parameters used for developing that requirement.
3. After knowing all these things you have to write the testcase with different input values for checking all the paths of SP.
One thing writing testcases for backend testing not like functinal testing. You have to use white box testing techniques.
RE: What is way of writing testcases for database test...
To write testcase for database its just like functional testing.1.Objective:Write the objective that you would like to test. eg: To check the shipment that i load thru xml is getting inserted for perticular customer.2.Write the method of input or action that you do. eg:Load an xml with all data which can be added to a customer.3.Expected :Input should be viewd in database. eg: The shipment should be loaded sucessfully for that customer also it should be seen in application.4.You can write ssuch type of testcases for any functionality like update delete etc.
RE: What is way of writing testcases for database test...
Hi all
At first we need to go through the documents provided. Need to know what tables stored procedures are mentioned in the doc. Then test the functionality of the application. Simultaneously start writing the DB testcases.. with the queries you have used at the backend while testing the tables and stored procedures you have used in order to get the desired results. Trigers that were fired. Based on the stored procedure we can know the functionality for a specific peice of the application. So that we can write queries related to that. From that we make DB testcases also.
RE: What is way of writing testcases for database test...
In order to create database test cases you can have two different aproaches performing both of them is advisable if time permits.1) Testing each and every Trigger Cursor SP used in the application.2) Testing the application w.r.t functionality of the application like for example:Let's say there are two web sites type 'ABC' records should be displayed only in ABC websiteand type 'XYZ' records should be displayed only in XYZ website. You can insert a new type 'ABC' record and see if it is displayed only on ABC website and not on XYZ website.Both the websites are controlled by the same company it just wants type I customers to have acces to type I website and Type II customers have access to type II website. This is a completely imaginary example there can be any type of application or service functionality which can be broken down in to test cases in turn.Hope this from now on for anyone will be of good help.ThanksPranav CHyderabad.
1 
2