CS 339: Introduction to Databases, Fall 2004

Instructor:Peter A. Dinda (Office Hours: Fridays 10-12
Teaching Assistant:Ananth Sundararaj (Office Hours: Wednesdays 10-12)
Undergraduate Assistants:Looking now, contact me if interested.
Time:Winter 2004, MWF 9-9:50am
Location:CS Large Classroom, 1890 Maple
Recitation Section:Mondays, 6-7pm, Small Classroom
Course number:CS 339
Enrollment Limit:30

Communication

Note that we will not use CMS/Blackboard for anything.
  • Instant Messaging: Logged and searchable IM is available via Windows Messenger. We will tell you more in class.
  • Newsgroups: cs.339.discuss and cs.339.announce are available from the CS news server. If you have trouble accessing the newsgroups, please contact systems support.
  • 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

  • David's PHP slides and his code (intro.php and serveImage)
  • Andrew's Java slides
  • Peter's Slides on Version Control and CVS
  • Bin's Slides on Functional Dependencies
  • Syllabus NOTE: UPDATED 10/11
  • Using Oracle in the Undergraduate Lab
  • Perl in a Nutshell
  • TLAB: The Teaching Lab

    • Projects

  • Dry-run project: Extending Microblog (3 weeks NOTE: NOW DUE ON 10/15)
    Project Web Pages See how your classmates are doing!
    Common Problems
  • Self-defined Project: Your Own Web Application (4 weeks)
    Project Web Pages See what your classmates are making!
  • Implementation Project: Btrees (3 weeks)
    Common Problems (Will be available once project is in)

    • Homeworks

  • HW 1: Entity-Relationship data model (pdf) (out: 10/11, in: 10/20)
    solutions
  • HW 2: Relational data model (pdf) (out: 10/22, in: 10/27 (5pm))
    Note: No late handins. Solutions will be available on 10/27.
    solutions
  • HW 3: Relational Algebra (pdf) (out: 11/1, in: 11/17)
    solutions
  • CANCELLED: HW 4: Implementation of Databases

    • Exams

  • Midterm (Thursday, 10/30, 6-7:30pm, L150 TECH )
  • Final (Thursday, 12/9, 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
  • GraphViz graph visualization framework
  • SQL Fairy SQL Schema Translator and Visualizer
    • Peter Dinda
    Last modified: Mon Jul 17 14:08:37 CDT 2006