Gr 12 – SQL Term Test

May 16, 2020 | Grade 12, Grade 12 - SQL

Here is a SQL Term Test based on the Ms Access database “BP Challenge” (Slightly modified. I do not know who the original author of this database is.). The database can be opened and SQL queries written in SQLBrowser (so you don’t need to have a copy of Ms Access)

Here is the SQL question paper in pdf

Here is the question paper in Ms Word (download)

Here is the BP Challenge database (download)

Here is the memo.

You can download SQLBrowser here.(download)

How to use SQLBrowser is here.(download)

SQL Browser. Open database. Text Based query. Code. Process button. ** You may find that the columns are super huge and you may have to drag each of them smaller. If you dont do this you may only see one column**