Homeworks and Handouts

CS 328 - Web Apps Using Databases
Section 10 - CRN 22226 - MW 3:00-4:20pm
Spring 2026

Last modified: Saturday, March 14, 2026

Important Announcements:

• (...may appear here as/if needed!)

• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • 328hw07-1-start.html - syntax-colored display version
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 8 Lab Exercise
  • Week 8 Lab Exercise (in tagged PDF)
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • Some string- and date- and time-related SQL functions (in tagged PDF)
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 7 Lab Exercise
  • Week 7 Lab Exercise (in tagged PDF)
  
  
• Week 6 Lab Exercise
  • Week 6 Lab Exercise (in tagged PDF)
    
    
  • lab6-start.html - syntax-colored display version
    
    
  • 328lect06-1.html - which is styled by:
  • 328lect06-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect06-1/328lect06-1.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Exam 1 Review Suggestions (in tagged PDF)
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF)
    
    
  • 328lect05-1.sql - includes PL/SQL stored procedure job_overview and PL/SQL stored function job_count
  • 328lect05-2.sql - includes PL/SQL stored procedure loopy
  • Some string- and date- and time-related SQL functions - because these can be called in PL/SQL statements as well!
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 5 Lab Exercise
  • Week 5 Lab Exercise (in tagged PDF)
    
    
  • set-up-ex-tbls.sql - for reference
  • 328lect05-1.sql - includes PL/SQL stored procedure job_overview and PL/SQL stored functionjob_count
  • 328lect05-2.sql - includes PL/SQL stored procedure loopy
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 4 Lab Exercise
  • Week 4 Lab Exercise (in tagged PDF)
    
    
  • Some Additional Form Widgets - (in tagged PDF)
  • html-template.html - required class HTML template page, including required validation link at the bottom
    
    
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
  • set-up-ex-tbls.sql - for reference
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • prob5-out.pdf - an example results file for Problem 5, for comparison purposes
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 3 Lab Exercise
  • Week 3 Lab Exercise (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • html-style-play-before.html - for Problem 2
  
  
• Week 2 Lab Exercise
  • Week 2 Lab Exercise (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  
  
• 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
    
    
  • bks-play-out.pdf - an example results file for Problem 4, for comparison purposes
    
    
  • Useful details: ssh and sftp - (in tagged PDF)
  • Useful details: ~st10/328submit - (in tagged PDF)
  
  
• Week 1 Lab Exercise
  • Week 1 Lab Exercise (in tagged PDF)
    
    
  • Connecting to nrs-projects and sqlplus - (in tagged PDF)
  • Useful details: ssh and sftp - (in tagged PDF)
  • Useful Linux commands - (in tagged PDF)
  • Useful details: ~st10/328submit - (in tagged PDF)
  • Setting up your nrs-projects web directory - (in tagged PDF)
  
  
• CS 328 Course Syllabus (in tagged PDF)

Back to course home page