Setting up a database for testing
Creating A test database
in order to test a data base you will need to create a test database that will hold your test design information, inputs, outputs and expected results.
Create a tables to hold
requirements, features, engineering designs to be verified
tickets for tracking features and issues implementing features
test measurements to verify requirement being tested
list of your tables
list all the fields for each table
test data that will be used for test cases
expected results of each test which validate test