Homeworks and Handouts

CS 325 - Database Design
Section 10 - CRN 41088 - M 9:00am-10:20am
Fall 2021

Last modified: Tuesday, December 7, 2021

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)
  
  
• Week 14 Lab Exercise
  • Week 14 Lab Exercise (in tagged PDF)
  • 325lab14-out.txt - an example results file for the Week 14 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 10
  • Homework 10 handout (in tagged PDF)
  • 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)
    
    
  • Note/Reminder on Joining More than 2 Tables (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw10-out.txt - an example results file for Problem 5, for comparison purposes
  
  
• Week 13 Lab Exercise
  • Week 13 Lab Exercise (in tagged PDF)
  • 325lab13-out.txt - an example results file for the Week 13 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw9-out.txt - an example results file for Problem 3, for comparison purposes
  
  
• Week 11 Lab Exercise
  • Week 11 Lab Exercise (in tagged PDF)
  • 325lab11-out.txt - an example results file for the Week 11 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw8-out.txt - an example results file for Problem 3, for comparison purposes
  
  
• Week 10 Lab Exercise
  • Week 10 Lab Exercise (in tagged PDF)
  • 325lab10-out.txt - an example results file for the Week 10 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • Evolving set of CS 325 SQL coding style standards - (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw7-out.txt - an example results file for Problem 4, for comparison purposes
  
  
• Week 9 Lab Exercise
  • Week 9 Lab Exercise (in tagged PDF)
  • 325lab9-out.txt - an example results file for the Week 9 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw6-out.txt - an example results file for Problem 2, for comparison purposes
  
  
• Week 8 Lab Exercise
  • Week 8 Lab Exercise (in tagged PDF)
  • 325lab8-out.txt - an example results file for the Week 8 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Exam 1 Review Suggestions (in tagged PDF)
  
  
• Course Project
  • CS 325 Project Handout (in tagged PDF)
  • Example project scenario descriptions (in tagged PDF)
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
    
    
  • 325hw5-out.txt - an example results file for Problem 2, for comparison purposes
  
  
• Week 6 Lab Exercise
  • Week 6 Lab Exercise (in tagged PDF)
  • 325lab6-out.txt - an example results file for the Week 6 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • movies-create.sql
  • movies-pop.sql
  • movies-create's tables in relation-structure form (in tagged PDF), for hopefully-convenient reference
  • 325hw4-out.txt - an example results file for Problem 3, for comparison purposes
  
  
• Week 5 Lab Exercise
  • Week 5 Lab Exercise (in tagged PDF)
  • 325lab5-out.txt - an example results file for the Week 5 Lab Exercise, for comparison purposes (and hopefully to encourage debugging if you see significant differences)
    
    
  • set-up-ex-tbls.sql - script setting up the example tables used in today's SQL examples
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
  • set-up-ex-tbls.sql - creates and initially populates example tables empl, dept, and customer
  
  
• Week 4 Lab Exercise
  • Week 4 Lab Exercise (in tagged PDF)
  • set-up-ex-tbls.sql - creates and initially populates example tables empl, dept, and customer
  
  
• Week 3 Lab Exercise
  • Week 3 Lab Exercise (in tagged PDF)
  • 325lect02-2.sql - SQL script built during Week 2 asynchronous material (and called as part of Week 3 Lab Exercise)
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
  
  
• Week 2 Lab Exercise
  • Week 2 Lab Exercise (in tagged PDF)
  
  
• Homework 1
  • Homework 1 handout (in tagged PDF)
  
  
• Week 1 Lab Exercise
  • Week 1 Lab Exercise (in tagged PDF)
    
    
  • Useful Linux Commands for CS 325 (in tagged PDF)
  • useful details - ssh, ~st10/325submit, and sftp (in tagged PDF)
    
    
  • SQL Reading packet 1 - Intro to Oracle SQL at HSU (in tagged PDF)
  
  
• Course syllabus (in tagged PDF)

Back to course home page