Database Design and Development (Testing and Evaluation)

Question 1

In the Testing phase of Database Design and Development, what are the two thing we can test?

Answer 1

Fitness for Purpose

Query Design and SQL versus result

Question 2

Why is it important to make an “expected result” when testing a databases’ Query Design and SQL versus result?

Answer 2

To compare the results to try and achieve the same result, if not there may be problems with the query design and/or implementation

Question 3

What phase of the Database Design and Development would be revisited if the Testing didn’t match with the expected result?

Answer 3

The Design Phase followed by the Implementation Phase

Question 4

What be the definition of a database which meets the end-user and functional requirements?

Answer 4

Fit for Purpose