Homeworks and Handouts

CS 328 - Web Apps Using Databases
Spring 2016

Last modified: Tuesday, May 10, 2016

Important Announcements:

• For versions of handouts that were also given out on-paper, the on-line formatting will likely vary from the actual paper handouts, but the content should be the same.

• Final Exam Review Suggestions (in tagged PDF)
  
  
• Homework 12
  • Homework 12 handout (in tagged PDF)
  
  
• Homework 11
  • Homework 11 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Homework 10
  • Homework 10 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  • order_maint_test.sql - made less-annoying 2016-04-14, removing pop-bks.sql call that might generate annoying initial errors if run while your order_maint trigger exists...
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF) - see IMPORTANT NOTE about PROBLEM 7 under "Important announcements" at public course web site's opening page!!
    
    
  • 328hw7-out.txt - an example results file for Problem 2, for comparison purposes
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF) - last updated before 11:00 pm on 2016-02-29
    
    
  • create-bks.sql
  • pop-bks.sql
  • sell_book_test.sql - last updated before 11:00 pm on 2016-02-29
    
    
  • 328hw05-before.html , adapted from http://srv13.fountainheadcollege.com/mustafa.eminoglu/ws201/registration.html - "plain" HTML5 page to have external CSS formatting added; here is a runnable version on nrs-labs:
    http://users.humboldt.edu/smtuttle/s16cs328/328hw05/328hw05-before.html
  • html5-template.html - required class HTML5 template page, including required validation links at the bottom
  
  
• Exam 1 Review Suggestions (in tagged PDF)
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  • insert_order_needed_test.sql
  • pending_order_needed_test.sql
    
    
  • html5-template.html - required class HTML5 template page, including required validation links at the bottom
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF) - corrected second bullet in Problem 4 on 2016-02-11
    
    
  • create-bks.sql
  • pop-bks.sql
  • next_ord_needed_id_test.sql
  • is_on_order_test.sql
    
    
  • html5-template.html - required class HTML5 template page, including required validation links at the bottom
  • hw3-warmup-before.html
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
    
    
  • create-bks.sql
  • pop-bks.sql
  • set-up-ex-tbls.sql - dept, empl, customer example tables
    
    
  • silly_shout_test.sql
  • title_total_cost_test.sql
  • total_on_hand_test.sql
  • which_titles_test.sql
  • get_manager_test.sql
  
  
• Homework 1
  • Homework 1 handout (in tagged PDF)
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
    
    
  • sql-play-out.txt - an example results file for Problem 2, for comparison purposes
    
    
  • inventory-orders-setup.sql - setting up tables inventory and orders for trigger inventory_update;
    ALSO includes examples of NAMING primary key and foreign key constraints
  • init-inventory.sql - resetting inventory rows to an initial set of 4 inventory items
  
  
• CS 328 Course Syllabus (in tagged PDF) - revised to now have CORRECT Exam 2 date of Wednesday, April 6th

Back to course home page

Please send questions to: sharon.tuttle@humboldt.edu