This question is about database testing, can not find a forum specific for this therefore i'm posting here, please move to the appropriate forum if necessary.
Generally, what do you test when testing a database? I know the common answer would to test the function of a database and verify that it works as expected but i'm looking for what exactly (details) do you look for in database function testing?
Additionally, how do you do the testing? what methods/techniques you use?
is it just a case of inputting data, getting data back and check that its what you're expected? Or is there a more methodical/logical approach to database testing just like the database design.