What should be tested in a database? Explain
Data mapping in a database: It should be ensured that regardless of the visual (front-end) part of the application, all CRUD operations ...
- Data mapping in a database: It should be ensured that regardless of the visual (front-end) part of the application, all CRUD operations must work correctly.
- ACID properties in a database: The ACID properties of a database refer to "atomicity", "consistency", "isolation" and "durability". Proper testing of these four properties in a database should be performed during the testing activity.
- Ensure the integrity of the data: Note that the different modules of an application (ie screens or forms) use the same data from different "views" and perform all CRUD operations on the data they obtain. In that case, make sure that the last state of the data is reflected everywhere. The system must display the most recent and updated values or the status of the shared data on all forms and views. This is called data integrity.
- Ensure the accuracy of the implemented trade rules: Today, databases are not meant to store records only. In fact, databases have become very powerful tools that provide broad support to developers in order to implement business logic at the database level. Some simple examples of powerful database features are 'referential integrity', relational constraints, triggers, and stored procedures. Therefore, using these and many other features offered by databases, developers implement business logic at the database level. The test must ensure that the running business logic is correct and works accurately.