N5CS: Database Testing and Evaluation

Evaluate your solution in terms of fitness for purpose and accuracy of output

Understand the history of computer science

Learn the basics of web design and development

Master the principles of graphic design

To make them run faster

To ensure they are fit for purpose and accurate

To make them easier to write

To reduce the size of the database

It selects all players who scored in the first 70 minutes of a game

It selects all players from the goalscorer table

It selects all players who scored after the 70th minute of a game

It updates the goalscorer table to only show goals after the 70th minute

Robert Lewandowski and Dimitris Salpingidis

Alan Dzagoev and Roman Pavlyuchenko

Václav Pilar and Theofanis Gekas

Petr Jiráček and Václav Pilar

Complexity and efficiency

Fitness for purpose and accuracy of output

Speed and reliability

Length and clarity

The solution must be the most efficient one available

The solution must be complex and comprehensive

The solution must be good enough to do the task required

The solution must include additional data not asked for

Not fit for purpose

Fit for purpose but not accurate

Fit for purpose

Inaccurate and not fit for purpose

Is everything included in the WHERE clause that is required?

Are columns sorted correctly in ascending or descending order?

Have linked tables been linked using the correct primary and foreign keys?

Has the data been formatted in a specific font and size?

The 'matchid' column was not required.

The 'gtime' values were incorrect.

The 'player' names were listed in the wrong order.

The 'teamid' was missing from the output.

SELECT teamid, player, gtime FROM goalscorer WHERE gtime > 70;

SELECT matchid, teamid, player, gtime FROM goalscorer WHERE gtime > 70;

SELECT teamid, player FROM goalscorer WHERE gtime > 70;

SELECT * FROM goalscorer WHERE gtime > 70;