Homeworks and Handouts

CIS 315
Database Design and Implementation
Fall 2010

Last modified: Wednesday, December 8, 2010

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 Study Suggestions (in tagged PDF)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
  • hw3-setup.sql
  • hw9-results.txt - an example results file for Homework 9, for comparison purposes
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
  • hw3-setup.sql
  • hw8-results.txt - an example results file for Homework 8, for comparison purposes
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
  • hw3-setup.sql
  • hw7-results.txt - an example results file for Homework 7, for comparison purposes
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
  • hw3-setup.sql
  • hw6-results.txt - an example results file for Homework 6, for comparison purposes
  
  
• Example supertype-subtype conversion problems (in tagged PDF)
  
  
• Exam 2 Study Suggestions (in tagged PDF)
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF)
  • hw3-setup.sql
  • hw5-results.txt - an example results file for Problem 2, for comparison purposes
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
  • hw3-setup.sql
  • hw4-results.txt - an example results file for Problem 3, for comparison purposes
  
  
• Exam 1 Study Suggestions (in tagged PDF)
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
  • Saving a file in PDF format - (in tagged PDF)
  • hw3-setup.sql
  • hw3-results.txt - an example results file for Problem 2, for comparison purposes
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
  • "Writing Relational Operations using SQL" Reading Packet covering much (although not all) of what we discussed in the Week 4 Lab.
  
  
• Homework 1
  • Homework 1 handout (in tagged PDF)
  • "Intro to SQL" Reading Packet covering much of what we discussed in the Week 2 Lab.
  
  
• Week 1 Lab - Basic UNIX review, and accessing Oracle
  • Useful UNIX Commands for CIS 315 (in tagged PDF)
    
    
• CIS 315 Course Syllabus (in PDF)

Back to course home page