Database SQL Beginner Questions

This unit was written to provide homework, class assessments or additional tasks to complement your own database teaching.  The theme of the two table database provided is Scottish golf club members and their competition results.

There are five task sheets included as MS Word files:

• Task 1 – Analysis & Design – students must identify the information to be stored and then construct an entity relationship diagram and a data dictionary.
• Task 2 – SQL - 8 questions of varying difficulty based on SELECT, FROM, WHERE and AND
• Task 3 – SQL - a further 8 questions continuing from task 2 but adding ORDER BY
• Task 4 – SQL - 10 more SQL questions that require INSERT, DELETE and UPDATE
• Task 5 – Evaluation - compare the Scottish Golfers database against a set of requirements

All marking instructions are provided.

The above tasks were initially written as homework/assessment style questions (I spent 20 years writing questions for the Scottish exam system) but I have since created database files should you wish your students to code the SQL.

The database files are provided in three formats for different environments:

• An Access file (two versions, a student version and one with the completed task 2 and 3 queries)
• CSV files that you can use to import the table data and build the database
• Text files that contain SQL CREATE and INSERT statements which you could use to create the database on a database server