CS 339: Introduction to Databases, Fall 2003

Instructor:Peter A. Dinda (Office Hours: Thursdays 2-4)
Teaching Assistants:Ananth Sundararaj (Office Hours: Mondays 10:15-12:15 and Wednesdays 11:15-12:15)
Bin Lin (Office Hours: Tuesdays, 10-12, Wednesdays 3:30-4:30)
Undergraduate Assistants:Looking now, contact me if interested.
Time:Winter 2003, MWF 9-9:50am
Location:CS Classroom, 1890 Maple
Course number:CS 339
Enrollment Limit:45

Communication

  • Discussion group: A discussion group for the course is available on CMS. We will use CMS only for discussion. Newsgroups (cs.cs339.discussion and cs.cs339.announce) are also available from the server that we emailed about recently. If you didn't receive that email, please send us mail to gain access to the news server.
  • Mailing List: The course is associated with your netid and you can spam the course using SNAP. Please don't unless absolutely necessary.
  • Grade Reports: I will periodically email students with individualized grade reports showing current standing.

    • General Handouts

  • Syllabus (In Progress)
  • Using Oracle in the Undergraduate Lab
  • Perl in a Nutshell
  • TLAB: The Teaching Lab

    • Projects

  • Dry-run project: Extending Microblog (out: 9/24, in: 10/20)
    Project Web Pages
    Common Problems
  • Self-defined Project (out: 10/20, in: 12/5 - weekly handins )
    Project Web Pages

    • Homeworks

  • HW 1: Entity-Relationship data model (pdf) (out: 10/8, in: 10/17)
  • HW 2: Relational data model (pdf) (out: 10/20, in: 10/29)
  • HW 3: Relational Algebra (pdf) (out: 11/3, in: 11/14)
  • HW 4: Implementation of Databases (pdf) (out: 11/17, in: 12/3)

    • Exams

  • Midterm (Thursday, 10/30, 6-7:30pm, CS Classroom)
  • Final (Wednesday, 12/10, 9am-11am, CS Classroom)

    • Helpful Things

  • Comer's Ubiquitous B-Tree Paper
  • E.F. Codd's seminal paper on the relational data model
  • Brian Dennis's Blog for CS 395 Scripting Languages, which has a lot of information about programming in Perl.
  • Phillip Greenspun's SQL For Web Nerds Book, which we will make use of early in the class.
  • A Gentle Introduction to SQL, which has tutorials and examples of the slight differences in SQL from RDBMS to RDBMS.
  • Fabian Bustamante's List of C and Unix Resources, which may help you if you are unfamiliar with getting around on Unix.
  • Johan Vromans's Perl Reference Guide
  • O'Reilly's Free Sample Chapters from their Perl Books

    • Less Helpful, Yet Cool Things

    Peter Dinda
    Last modified: Mon Jul 17 14:07:54 CDT 2006