Database Testing Testcases

can any one plz tell me how to write the test cases for database testing ?
how to write the database testcases and what are things that has to be covered in database testing.

hi friend..

Whenever you do database testing please note the following

1. check for data integrity
2. Check whether teh records are physically deleted, if it so then this is wrong and then ask the developer to change teh delete as logical delete
3.check for length for the specific field.. for ex: the length of the text box is 50 it should accept only 50 charcters if more than 50 charcters is entered by the user it should be truncated from the database
4. check out the relation ships

friends.. if some thing left by me please intimate me immediately

Thanks
Deepasree

Hi deep:
I think that your reply is irrelevant.

Please refer to: [url=http://www.geekinterview.com/question_details/14772]DataBase Testing - What is Database testing?[/url]

hi brinksoul,

Please note i have seeded few ideas how the database testing is conducted in real time.
refer the link what you have given in the forum once again with patience and check out my answer. Any issues let me know in the forum.

Thanks
Deepasree

i want to know for database testing purpose how much knowledge i need SQL

hi,

you need to get the data from sql. so you need to expert in small commend is enough.

Thanks and regards,
Bhaskar kumar

hai sai,

You need to know how to frame basic query
Key constraints,
stored procedure,
logical and physical deletion of records from database.

Thanks
Deepasree