We need to test the following aspects of database first :
Data Mapping: In the software systems, data often travels back and forth from the UI (user interface) to the backend DB and vice versa
ACID properties validation: atomicity, consistency, isolation and durability. Every transaction a DB performs has to adhere to these four properties.
Data integrity:This means that following any of the CRUD operations, the updated and most recent values/Status of shared data should appear on all the forms and screens.
Business rule conformity: More complex databases means more complicated components like relational constraints, triggers, stored procedures, etc. So testers will have to come up with appropriate SQL queries in order to validate these complex objects.
1) Prepare the environment
2) Run a test
3) Check test result
4) Validate according to the expected results
5) Report the findings to the respective stakeholders
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!