Higher DDD - Testing & Evaluation

• I can identify errors in a SQL statement and suggest corrections

• I can determine whether a SQL query is fit for purpose

• I can determine whether a SQL query produces accurate output

• I can determine whether the end-user and functional requirements have been met by a database solution

​Achievements

• We are learning how to debug SQL queries 

• We are learning how to identify and correct errors in SQL queries

• We are learning how SQL queries can be deemed fit for purpose and have accurate output

Aims

Open Ended

A swimming club uses a database to store details of swimmers and their times in a 50 meters swim. A sample of the data stored in the Swimmer table is shown below.

The head coach would like to produce a report displaying the slowest and fastest times from any of the squads with a ‘1’ in their name, as shown below.

The following SQL statement is executed.

SELECT squad, MIN(time) AS [Slowest Time], MAX(time) AS [Fastest Time] FROM Swimmer WHERE squad LIKE "1"

When tested, the actual output did not match the expected output. Identify the three errors in the above SQL statement. (3 marks)