Testing and evaluation

When testing queries, it is good practice to document expected results and actual results. A comparison can then be made, with testing passed if the expected result and actual result is the same.

In the example shown below, the design and implementation () are also shown to provide a clear context for the testing that follows.

The query being tested is designed to run on the data held in the following versions of the pupil and orchestra tables.

Pupil table

PupilID	First Name	Surname	Class	Pastoral Care Teacher	Merit Points
0001	Zainab	Singh	1T1	Mr Harley	74
0002	David	Boland	1I2	Mrs Aitken	12
0003	Amy	Jones	1M1	Mr Gilchrist	55
0004	James	McNamee	1T1	Mr Harley	88
0005	Pawel	McTavish	1I1	Mrs Aitken	19
0006	Antonia	Gallagher	1M2	Mr Gilchrist	21
0007	Amy	McNamee	1T1	Mr Harley	63
0008	Aysha	Matazinadze	1T1	Mr Harley	45
0009	Beatrice	Panner	1T2	Mr Harley	77
0010	Thomas	Glacney	1M1	Miss Armstrong	91
0011	Frankie	Al-Robeye	1M2	Mr Gilchrist	71

PupilID	0001
First Name	Zainab
Surname	Singh
Class	1T1
Pastoral Care Teacher	Mr Harley
Merit Points	74

PupilID	0002
First Name	David
Surname	Boland
Class	1I2
Pastoral Care Teacher	Mrs Aitken
Merit Points	12

PupilID	0003
First Name	Amy
Surname	Jones
Class	1M1
Pastoral Care Teacher	Mr Gilchrist
Merit Points	55

PupilID	0004
First Name	James
Surname	McNamee
Class	1T1
Pastoral Care Teacher	Mr Harley
Merit Points	88

PupilID	0005
First Name	Pawel
Surname	McTavish
Class	1I1
Pastoral Care Teacher	Mrs Aitken
Merit Points	19

PupilID	0006
First Name	Antonia
Surname	Gallagher
Class	1M2
Pastoral Care Teacher	Mr Gilchrist
Merit Points	21

PupilID	0007
First Name	Amy
Surname	McNamee
Class	1T1
Pastoral Care Teacher	Mr Harley
Merit Points	63

PupilID	0008
First Name	Aysha
Surname	Matazinadze
Class	1T1
Pastoral Care Teacher	Mr Harley
Merit Points	45

PupilID	0009
First Name	Beatrice
Surname	Panner
Class	1T2
Pastoral Care Teacher	Mr Harley
Merit Points	77

PupilID	0010
First Name	Thomas
Surname	Glacney
Class	1M1
Pastoral Care Teacher	Miss Armstrong
Merit Points	91

PupilID	0011
First Name	Frankie
Surname	Al-Robeye
Class	1M2
Pastoral Care Teacher	Mr Gilchrist
Merit Points	71

Orchestra table

OrchestraMemberID	PupilID	Group	Tuition
01	0004	Woodwind	Yes
02	0007	Strings	No
03	0008	Brass	Yes
04	0003	Brass	No
05	0009	Percussion	No

OrchestraMemberID	01
PupilID	0004
Group	Woodwind
Tuition	Yes

OrchestraMemberID	02
PupilID	0007
Group	Strings
Tuition	No

OrchestraMemberID	03
PupilID	0008
Group	Brass
Tuition	Yes

OrchestraMemberID	04
PupilID	0003
Group	Brass
Tuition	No

OrchestraMemberID	05
PupilID	0009
Group	Percussion
Tuition	No

Example

��ý

Testing and evaluationTesting and evaluation

Testing and evaluation

More guides on this topic

����ý

Testing and evaluation

More guides on this topic

��ý