Updated: Dec 2, 2020
When a user performs operations on the browser (Client-Side) the requests are sent to the back-end server that stores the application records in a dedicated database (SQL, Oracle, etc.). When testing a Web-Application, we will need to validate the synchronization between the two access points (Client (Browser) <-> Server Side (Database).
Validate that the data, which is displayed in the site is the one that stored in the back-end server.
Validate that each column has a MAX input limit (Any value that exceeds this length will be rejected).
Validate that the DB tables can handle the boundary values that are retrieved from the client.
Verify the functionality of the DB stored procedures (Name, Parameters, output, syntax, etc.).
Validate that every user's operation will update the database values (Add, Delete, and Edit).
Validate that the user will not be affected when there is a DB error (Back-end side).
Validate that the user cannot access the DB without proper authentication.
Validate that the DB queries are executed without any failures.
Validate that each table has the correct foreign/Primary keys.
Validate that the DB server can handle negative numbers.
Validate that the response time of the DB server.
All DB tables should include a short description.
Validate that the database structure contains the preliminary specifications (Tables, Columns, Stored-Procedures, Indexes, data types, flags, etc.).
Validate that the user data is committed only when the process is done (in any failure along the way this data should be ignored).
Validate that the client interacts with the relevant database (in most cases the back-end site will host multiple databases).
Validate that the client cannot update the DB with the ‘Null’ value (in any tables that have a column that prohibits this value).
Validate that there are no synchronization issues when the client/servers are located in a different Time zone.