DDD - Testing and Evaluation

Question 1

How to test SQL queries

Answer 1

producing a table of expected results. Run the queries and check that the actual results match the expected results

Question 2

when is a database fit for purpose

Answer 2

if it meets the end-user requirements and the functional requirements set out at the analysis stage

Question 3

when is a database output accurate

Answer 3

when the actual results match the expected results