software testing genius

When should we test a Database

Welcome to “Software Testing Genius”. Subscribe to my RSS feed for latest content on Software Testing.

When should we test a Database

Testing of databases involves initial testing of database and database refactoring. This strategy can be applied concurrently to both the application code and the database schema. Testing of databases is done not only during the release but also during the development.

New software developers follow Test-First Approach wherein a test case is first written and then code is written which will fulfill this test.

A) Step by step approach is as under:

Step - 1: A test is added for just enough code to fail.

Step - 2: Tests are then run to make sure

that the new tests does in fact fail.

Step - 3: Functional code is then updated so that it passes the new tests.

Step - 4: Tests are run again.

Step - 5: If tests fail, update functional code again and retest.

Step - 6: Once the tests pass, next step is start again.

B) Test First Approach: TFA is also known as initial testing of database.

Test Driven Development: TDD is a progressive approach. It comprises TFA and refactoring (Regression testing).

This can be expressed in form of a equation:

TDD = TFA + Refactoring

When should we test a Database

The process of refactoring here means a small change to a database schema, which improves its design without changing its semantics. It is an evolutionary improvement of our database schema, which will further support following three things:

1) New needs of our customers.

2) Evolutionary software development.

3) Fix legacy database design problem.

Many More Articles & Tutorials on Databse Testing

Largest Database of Sample Papers - 1000+ Unique Questions for ISTQB Foundation Exam

ISTQB Foundation Exam - Full Crash Course for Download

ISTQB Advanced CTAL Test Analysts Exam - Full Crash Course for Download

ISTQB Advanced CTAL Test Manager Exam - Full Crash Course for Download

What Successful Testers say about the Quality of this website

If you want to keep track of further articles on Software Testing,
I suggest you to subscribe my
RSS feed

You can also Subscribe by E-mail
and get All New articles delivered directly to your Inbox.

Get your Absolutely Free Copy of Several MS PowerPoint Presentations & E-Books related to ISTQB, HP Load Runner, IBM RFT, HP QTP & QC Certification Exams, prepared by Popular Writers & Trainers, by writing to:

Full Study Material for Popular Certification Exams:

Study Material - HP QTP & QC Certification Exam

Study Material - IBM RFT Certification Exam

Study Material - HP LoadRunner Certification Exams for All Modules

Study Material - ISTQB Certification Exam

Most Popular Topics in Demand:

Practical Roadmap to QTP Certification

Practical Roadmap to CSTE Certification

Consolidated Study Material - Testing & QA

Rehearsal of QTP in 1 Hr. -  Interview Questions


Comments :


Leave Your Comments: (*) Marked Fields are Mandatory

You can apply basic formatting to the text

Name *
Email Address *
Speak your mind
sex hikayeleri