Database Query Error Counting Sheet

Name

Information Request Number

Attempts

 

 

 

 

Micro Errors

Keyboards

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

1

 

 

 

 

 

2

 

Symbols

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

1

 

2

 

1

 

 

 

Logical Operators

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

 

 

 

 

 

 

 

 

Relational Operators

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

 

 

 

 

 

 

 

 

Tables

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

 

 

 

 

 

 

 

 

Attributes

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

 

 

2

 

1

 

1

 

Values

View

Select

From

Where Join

Where Cond

Group by

Having

Order by

 

 

 

 

 

 

 

 

 

Set Operators

Where

Union

Intersect

Minus

 

 

 

 

 

 

Macro Errors

Columns

Rows

Aggregation

1

1

 

 

Source: Borthick, A. F., Bowen, P. L., Jones, D. R., Tse, M. H.K. 2001. The effects of information request ambiguity and construct incongruence on query development. Decision Support Systems 32: 3-25.