Database Programming – INFT224
Spring 2009
Week 6
Assignment
Objectives:
-
To reinforce your knowledge gained from class
discussions and readings.
Deliverables:
Hand in your answers (typed, not handwritten)
to the following questions.
In the text “A Guide to SQL”, (page 100-101) write
the SQL for questions 1-21
(5 points each – with a bonus question – 105 point total.
The best way to do this would be to:
-
Design the query you believe would
answer the question.
-
Test your work - write the queries
with an SQL interpreter and check for reasonableness. Feel free to browse the data to verify the
correct answers as well.
You will want to
set up the data for the Premiere Products database from the student files:
http://www.fitsysweb.com/inft224/examples/
File: 21674-3d.exe