Database Programming – INFT224

Spring 2009

Week 6 Assignment 



Due Wednesday, June 17




-          To reinforce your knowledge gained from class discussions and readings.





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:


File: 21674-3d.exe