Database Testing

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.

You have to cover some basic points like; availability and connectability to the db,
available db access credentials, permisions and privilages required, connection timeout etc and some advanced/project related areas like; updation of db after changes on UI, db constraints functioning, fourceful breach of db constraints, trying to access UI after manual abortion of db connectivity etc. :eek

__________________
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.

-sutnarcha-

What are the scenarios for sending invitation to a friend or adding a friend in our buddy list?

Database Testing is test the data integrity, that means how data is in u'r database. for an example dev team using a database, if it is differ from testing team,than there is mismatch ,so integrity/constant through our u'r project cycle, a common data is used by all of u,, it may be some privliges, grant.. DBA gui eill decide.

To write testcases for backend testing provide the following things:
in details: objective, Preconditions( required tools, uid,pwd to connect schema)
In Teststeps: you can write your sql queries in description, sample output in expected results.

As part of backend testing we will verify data constraints, calculations, business rules.

Hi thanq sai, could u explain this in detail like with an example could u write the test cases for the database testing

In Database testing you need to know your databases. It's not enough to connect to the right database but the information has to be stored in the same way. You can use SQL + Desktop Intelligence ( which is part of BO.). You must test for data types and data lengths.