There are 35 (thirty-five) questions, and this is a unique opportunity for you
to check your understanding of SQL. Develop your own SQL queries, by applying your
knowledge of relational algebra. Then enter your SQL queries in Access, and test them
on the provided data, by running them to obtain results. Check your results, selectively
(or exhaustively, for complete certainty). Write down the SQL that you have designed.
Then look at the QBE equivalent, and/or develop the query again in QBE and take a
look at the generated SQL in the corresponding view. Use your book and any other
resources. You may find it useful to work in groups, talk and discuss with, or explain
your ideas to, others as you're working on this. You will note that the database provided
contains a large number of helper queries that should help you focus your work. A few might
be slightly wrong from the point of view of the questions you need to encode, so look at them
with care. Still, these queries are going to be of great help to you, I am sure. In addition
to what's already provided I will also develop a set of 5 (five) queries to give you a model
of what you need to turn in and in what format. Remember though that what we expect from you
is a set of clean code SQL queries and clear crisp prose to go with it (pithy, that is).
Turn your answers in clear handwriting or typed, on paper, in lab, to your instructor.
