• Class syllabus (general course information)
• Class Announcements: The primary reference for class information outside of lectures is the cs.course460 news group on the CS dept. news server (news.cs.arizona.edu). See these instructions on how to configure your email client to access the server.
• Some thoughts about exams:
  • Characteristics of Good Exam Answers (suggestions on how to reply to short-answer exam questions)
  • Suggestions for Studying For and Taking Exams (what to do before and during an exam)
• Program Documentation and Development:
  • Programming Style Requirements (summary)
  • Toward Developing Good Programming Style (many documents here)
• A brief tutorial on using the turnin utility.

• Class syllabus
• Programming Style Requirements (summary)
• SPJ Schema (from 20090917)
• Relational Algebra Queries (20091006)
• Embedded and Dynamic SQL APIs in Postgres (20091022)
• Postgres' libpq API (20091022)
• I also handed out a printout of the JDBC demo that accompanies Program #3. You can find that program file here.

• Current Grades (Updated: 2009/11/23 4:40pm)

• Homeworks:
  • Homework #1 Due: 10/01 Solutions (in the password-protected media area)
  • Homework #2 Due: 10/15 (No posting of solutions planned, as we expect that most students will have little trouble with most, if not all, of the questions.)
  • Homework #3 Due: 10/22
    • Oracle 10g on-line documentation
    • Oracle software downloads
    • The SQL-1992 Standard (if you're really bored!)
  • Homework #4 Due: 11/12 Solutions (in the password-protected media area)

• Programs:
  • Program #1: Interpolation Searching a Binary File Due: 09/10
    • BinaryIO.java, an example of how to read and write binary data in Java
    • spmcat.dat, available on lectura as /home/cs460/fall09/spmcat.dat
    • spmcat.readme, available on lectura as /home/cs460/fall09/spmcat.readme
    • The spmcat files are also available directly from the source: The SPM (Southern Proper Motion) Catalog page at the U. of Maryland.
  • Program #2: Extendible Hashing Due: 09/24
  • Program #3: JDBC Due: 11/05
    • http://www.ade.state.az.us/researchpolicy/AIMSResults/, the Arizona Dept. of Education AIMS results page
    • http://www.ade.state.az.us/profile/publicview/AIMS_Codebook_TabDelimited.pdf, the AIMS codebook (meanings of abbreviations)
    • JDBC.java, the sample JDBC program discussed in Topic 9.
  • Program #4: A Three-Tiered Application Due: 12/08
    • http://java.sun.com/products/jsp/overview.html, Sun's JSP overview
    • http://tomcat.apache.org/, Apache Tomcat

• The text for this semester is Database Systems, 5th ed., by Thomas Connolly and Carolyn Begg.
  • Please be aware that the book is available in two different electronic forms from CourseSmart for substantially less that the bookstore's paper edition price, but with an 180-day access restriction. I don't care which version you get (paper, on-line, or downloadable), but you'll want at least one of them!
  • Normally, I'd provide an errata list for the text here, but as the book is nearly new, there isn't one yet.
• We'll be doing at least two assignments that will involve interaction with the Oracle DBMS. Our text has decent coverage of Oracle, but if you want additional info, you might consider buying Oracle 10g Programming: A Primer, by Rajshekhar Sunderraman.
• I've created a resource page for LaTeX for those of you who would like to use it for formatting your answers to homework assignments.
• Curious about what does and does not count as 'academic dishonesty'? My Academic Dishonesty Quiz should be an eye-opener!

• CC2001's List of Recommended Topics for a Database Course. The complete CC2001 document is available as a PDF file here.
• Collection of Common CS Service Links (Account application, compute CSID, etc.)
• The Ubiquitous B-tree (D. Comer, ACM Computing Surveys, 11, 2, June 1979) - A good reference on B-trees, and the source of the B-tree definition I use. (Visit this link from a campus network to ensure that the paper is accessible.)
• division.sql - Four ways to perform relational division in SQL.

More information about how to access these media files can be found on the class newsgroup, cs.course460. See above for a link on how to read department newsgroups.

• Slides:
  • Completed Slides: The 'filled-in' slides from lecture are available here.
  • Guided Slides: If you'd like PDF versions (2-up) of the incomplete slides, suitable for in-class note-taking, you can find them here.
• Audio:
  • Lecture Audio: I record my lectures at MP3 files and post them here, mostly as a backup to the videos.
• Video:
  • Lecture Video: Thanks to funding from a grant, we are able to record the lectures using a high-def camcorder and make the recordings available to all students. This page has direct links to the videos from each class.