2 Comments

nasir
March 22, 2015 at 5:08 pm
Validate the table, column naming conventions
To check if the correct datatype is selected for a column
To check the consistency in datatypes for columns common across tables
To ensure the usage of correct field width and consistency in field width for columns common across tables
Existence of primary key, foreign key
Validity of constraints
Check for presence/existence of indexes on a column
Note the time of execution, compilation of queries
Normalize/denormalize the tables
Log in to Reply

sivi ramesh
March 28, 2015 at 10:57 pm
We check for data validity – checking for the correctness of the data.
data integrity- enforcing the business rules into database tables.
We test database schema, stored procedures, triggers.
Log in to Reply