I need some information regarding how to go with testing a database.I am not looking for tools or automated tests.I just need some basic tips or links that would provide information about how to go about testing a database that has stored procedures,tables etc.
Database testing not only involves the testing of the connectivity, testing of the inputs and retriving the data. It also involves checking the consistency of the data, handling exceptional cases of the data, checking the stored procedures, referential integrity, indexes, redundancy of the data and log files.
It would be better if you make a checklist of the things needed for the testing of the database. That would make your work easier.