Homeworks and Handouts

CS 325 - Database Design
Fall 2016

Last modified: Friday, December 9, 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 10
  • Homework 10 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql - including deletes of previous contents...!
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw10-2-out.txt - an example results file, for comparison purposes
  • cleanup.sql - SQL script to restore various SQL*Plus settings that a script creating an ASCII report might muck with (as suggested by T. Koyuncu)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql - including deletes of previous contents...!
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw9-3-out.txt - an example results file, for comparison purposes
  • cleanup.sql - SQL script to restore various SQL*Plus settings that a script creating an ASCII report might muck with (as suggested by T. Koyuncu)
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql - NOW including deletes of previous contents! Oy! 2016-11-18
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw8-3-out.txt - an example results file, for comparison purposes
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw7-2-out.txt - an example results file, for comparison purposes
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw6-2-out.txt - an example results file for Problem 2, for comparison purposes
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw5-out.txt - an example results file for Problems 2-11, for comparison purposes
  
  
• Exam 1 Review Suggestions (in tagged PDF)
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • hw4-create.sql
  • hw4-pop.sql
  • hw4-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • hw4-out.txt - an example results file for Problem 1, for comparison purposes
  
  
• Project model sub-milestone 1 review form (in tagged PDF)
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
    
    
• Course Project
  • CS 325 Project Handout (in tagged PDF)
  • Current scenario descriptions (in tagged PDF) - last modified 2016-09-22
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
  
  
• Homework 1
  • Homework 1 handout (in tagged PDF)
    
    
• Useful UNIX Commands for CS 325 (in tagged PDF)
  
  
• CS 325 Course Syllabus (in tagged PDF)

Back to course home page

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