||Do Chapter 1 Premiere Products
exercises 1-10 on p. 20. Turn in typed (or emailed)
answers. No computer work is necessary for these exercises.
For extra practice (and extra credit!), also do the Alexamara Marina Group exercises 1-13 on p. 21.
||Do Chapter 3 Premiere Products
exercises 1-6 on pp. 90-91. Email me a file named CH3.SQL.
Please remember to name your file correctly.
Here is a copy of the Premiere.sql script file you will need for Step 4. You can copy and paste this script into the SQLPLUS interface. In your CH3.SQL file, include a comment something like:
/* For Step 4, I copied and pasted the premiere.sql file */
NOTE that although there are no day classes on Monday, your assignment is still due on Monday.
||Do Chapter 4 Premiere Products
exercises 1-9 on pp. 132-133. Save your queries in a file named
CH4.SQL, but do not email it to me yet. Bring your file to class
||Add the following Chapter 4
Premiere Products exercises to your CH4.SQL file:
||Do all the Chapter 4 Premiere
Products exercises 1-21 on pp. 132-133. Include comments that
show each exercise number. Email me your file named CH4.SQL.
||Do the Chapter 5
Premiere Products exercises #1-4, 6-11, and 13-17 on p. 167; for extra
credit, you may also do #18, 19, or 20. Email me a file
Please run the Premiere.sql script (the link is above on the 10/5 assigned date line) before testing your queries. This is the version of the database that I will test your queries against.
Note that we may have some class time to work on this assignment on Wed. 11/2, but we may also be beginning new material.
||Do all the Chapter 6 Premiere
Products exercises #1-10 on pp. 191-2. Email me a file named
||Do the following Chapter 7
Premiere Products exercises on pp. 228-9: # 1, 2, 3, 6, 7, 9,
10. Email me a file named CH7.SQL.
For extra credit, you may also include # 4, 5, 8. You will not be able to run the commands for #4 or 5, so just include them in a comment. You can run the commands for #8.
||Do the following Chapter 8
Premiere Products exercises on p. 269: #1-4. Email me a
file named CH8.SQL.
||Study for the final exam.
We will discuss the study guide in class
on Wed., 11/23.