(EE)CS 339: Introduction to Databases, Fall 2005

Instructor:Peter A. Dinda (Office Hours: Thursdays 2-4)
Teaching Assistant:Ananth Sundararaj (Office Hours: Wednesdays and Fridays, 11-12)
Undergraduate Assistants:Looking now, contact me if interested.
Time:Fall 2005, MWF 10-10:50am
Location:Tech M152
Recitation Section:Mondays, 6-, Tech A110
Course number:CS 339
Enrollment Limit:30

Communication

Note that we will not use CMS/Blackboard for anything.
  • 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

  • Syllabus
  • Using Oracle in the Undergraduate Lab
  • Perl in a Nutshell
  • TLAB: The Teaching Lab
    Note that due to the reorganization, the teaching lab situation will be in flux
    You will, however, always be able to rely on tlab-login.
  • Useful Videos/Slides

  • Introduction to Unix (Peter Dinda) (video, part 1, video, part 2)
  • PHP for Active Content (David Choffnes) (slides, video, (code (intro.php and serveImage))
  • Java Servlets and Server Pages (Andrew Simpson) (slides, video)
  • Introduction to CVS (Peter Dinda) (slides, Real)
  • Peer-to-Peer Databases Lecture (Ashish Gupta, David Huber, Jay Bruins) (slides-1, slides-2, Real)
  • Projects

  • Dry-run project: Extending Microblog (3 weeks) (pdf)
    common problems
    links to blogs
  • Self-defined Project: Your Own Web Application (4 weeks) (pdf)
    Proposal Due 10/19
    Spec/ER/Relational Due 10/26
    DDL/DML/Queries/Logic Due 11/4
    App Due 11/9
  • Implementation Project: Btrees (3 weeks) (pdf)
  • Homeworks

  • HW 1: Entity-Relationship data model (pdf, out: 10/11, in: 10/19)
  • HW 2: Relational data model (pdf, out: 10/19, in: 10/26)
  • HW 3: Relational Algebra (pdf, out: 10/31, in: 11/16)
  • HW 4: Implementation of Databases
  • Exams

  • Midterm (Thursday, 10/27, 6-7:30pm, Room Tech LG66)
  • Final (Tuesday, 12/6, 9am-11am, Tech M152)
  • 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:09:03 CDT 2006