1. Solve the Premiere Products Exercise on pages 105-106 of your textbook. Write down the SQL expressions that you are using to obtain the results indicated by each question in the exercise. Turn them on paper, to your instructor, in lab.

   Please note: there are 16 (sixteen) 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.

2. Solve the Henry Books Case on pages 106-107. Everything that was mentioned above (for problem 1) applies here, as well.

Turn your answers in clear handwriting or typed, on paper, in lab, to your instructor.

The lab notes this week might provide additional hints, or help, with the homework.