CIS208 Assignments -- Fall 2011

Click to see extra credit opportunities.

See Oracle Client installation instructions here. 

Here is a copy of the Premiere Products database that we'll be using in class.

Note re emailed assignments:  Your SQL file must be named as specified below, and must include a comment with your name.
Files that are incorrectly named may not be graded.
Date Assigned
Date Due
Assignment
Wed. 9/28/11
Mon. 10/3
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.
Wed. 10/5
Mon. 10/10
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.
Wed. 10/12
Mon. 10/17
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 on Monday.
Mon. 10/17
Wed. 10/19
Add the following Chapter 4 Premiere Products exercises to your CH4.SQL file:
  • Exercises 10-18 on p. 132
Please add comments to your file showing each exercise number.  Do not email your file yet, but bring it to class on Wednesday.
Wed. 10/19
Mon. 10/24
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.
Wed. 10/26
Mon. 11/7
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 named CH5.SQL.

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.
Wed. 11/9
Mon. 11/14
Do all the Chapter 6 Premiere Products exercises #1-10 on pp. 191-2.  Email me a file named CH6.SQL.
Wed. 11/16
Mon. 11/21
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.
Mon. 11/21
Mon. 11/28
Do the following Chapter 8 Premiere Products exercises on p. 269:  #1-4.  Email me a file named CH8.SQL.
Mon. 11/21
Mon. 11/28
Study for the final exam.  We will discuss the study guide in class on Wed., 11/23.
Note re emailed assignments:  Your SQL file must be named as specified above, and must include a comment with your name.
Files that are incorrectly named may not be graded.