"In order to validate the records, we have to pull the records from the database and validate it against the reports or the flat files generated"-Can you pls tell me how to write test cases when i need to validate records against a report?

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