Database testing: validate the front end data with the database.
Let’s take an example of a e-commerce application,
user booked a mobile phone by entering phone model, shipping / billing address, and submits, Data stored into database.
Here we need to validate what the user enters data, should save exactly same to the database, then only correct device can be shipped to user.
In real time automation on database testing, user takes test data from external sources (excel or text file), enters detail on web application (then, data stores into database), then compares the external test data with the stored database data…..