Test scenarios for database testing

Can any one give me any two test scenarios for database testing of a web site and what are the possible testcases?

Thanks and regards

[QUOTE=bvmanikyalarao;12875]Can any one give me any two test scenarios for database testing of a web site and what are the possible testcases?

Thanks and regards[/QUOTE]

When we talk about database testing and database, It means we talk about database, and it's same for website and desktop application.
Test cases can't describe here until and unless you will not post the scenario and requirement.


How we can post the scenario without knowing your application use case documents and other related documents?:confused:

for eg when one does online shopping electronic invoice is provided with the ordernumber or the transaction number.
to really understand whether the data has been inserted or updated in the database one has to query the database with sql statements to validate the data.
if the response time for the page to get loaded takes too long than specified..then one of the reasons may be lack of indexing in the database....


again test scenarios for data base testing shd be based on specification /requiremnts.

Hi Rao,

Database testing of a Web-based application would basically deal with Integrity checks as well updation checks of the Database.

Like gettoknow pointed out - for instance we have an web-application dealing with Order booking, we might have different functionalities associated with the same like -
1) Registered User ID
2) Number of Items Ordered
3) The pricing of each Item
4) Total calcualtion etc.

For each of these operations different tables in the DB would be getting updated. DB testing would basically involve -

1) Taking a snapshot of the Database tables in terms of number of records
present before carrying out the transaction
2) Taking a snapshot after functionality is carried out using the UI. The
number of records count should have gone up
3) checking if Relational dependency of tables is properly getting executed.
In sense when Orders table is updated, the inventorty table of the item
should reflect a decrease in that specified item
4) checking if intermediate updations occur in the DB prior to completion of
the specified functionality. This should not happen

These are the generic test scenarios. Other scenrios would be based more on test specification / functional specifications....

Cheers...