Welcome to the Introduction to Database Systems course, COSC-3421, section M, for winter term 2005. Materials, instructions, and notices for the course will accumulate here over the semester.

• Final exam is soon. Preparation guide.

  • time: 19:00-22:00
  • date: Wednesday 6 April
  • place: CSE A

• Some local JDBC information (for DB2 on PRISM) posted.

• Project #4, the Apt APP for placing orders on the York River Booksellers Database, is posted. Due by 10:30pm Monday 4 April 2005. (This is the absolute deadline. No "late" deadline for this.)

• It looks like class evaluations will now be on Wednesday 23 March at the end of class. Come for your chance to grade me.

• Project #3, SQL Jeopardy querying the York River Booksellers Database, is posted. Due by 10:30pm Wednesday 23 March.

• Syllabus
• Class news group: york.cs.course.3421
• Lecture Notes
  • Introduction
    PS (1 per), PS (4 per), PDF (1 per), PDF (4 per)
  • Design
    • ER Modeling
      • Chapter 2 Textbook Slides:
        PS (1 per), PDF (1 per)
      • ER Guideline & Example Slides:
        PS (1 per), PS (4 per), PDF (1 per), PDF (4 per)
    • The Relational Model
      • Chapter 3 Textbook Slides:
        PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
    • The Relational Algebra & Calculus
      • Chapter 4 Textbook Slides
        • Part A (Relational Algebra):
          PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
        • Part B (Relational Calculus):
          PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
    • Normalization
      • Chapter 19 Textbook Slides:
        PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
  • Queries
    • SQL
      • Chapter 5 Textbook Slides:
        PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
      • SQL Example Slides (v2):
        PS (1 per), PS (6 per), PDF (1 per), PDF (6 per)
    • Application Programs (w/ SQL)
      • Chapter 6 Textbook Slides (modified):
        PS (1 per), PS (2 per), PS (6 per), PDF (1 per), PDF (2 per), PDF (6 per)
      • JDBC, a practical guide:
        PS (1 per), PS (2 per), PDF (1 per), PDF (2 per)
      • SQL/PL, a brief example:
        PS (1 per), PS (2 per), PDF (1 per), PDF (2 per)
  • Transactions & the System
    • System Overview:
      PS (1 per), PS (4 per), PDF (1 per), PDF (4 per)
    • ACID & Transaction Management (for Chapter 16):
      PS (1 per), PS (4 per), PDF (1 per), PDF (4 per)

• Projects
  1. Scheming a Schema
     Due by 10:30pm Wednesday 2 February.
  2. The Seats Database
     Due by 10:30pm Wednesday 2 March.
  3. SQL Jeopardy querying the York River Booksellers Database.
     Due by 10:30pm Wednesday 23 March.
  4. The Apt APP for placing orders on the York River Booksellers Database.
     Due by 10:30pm Monday 4 April 2005.
     (This is the absolute deadline. No "late" deadline for this.)
• Tests
  • midterm
    • preparation guide
    • the test (with the errata mentioned in class fixed):
      PS, PDF
    • the test with answers:
      PS, PDF
  • final exam
    • preparation guide
    • logistics
      • time: 19:00-22:00
      • date: Wednesday 6 April
      • place: CSE A
      The exam is join across the sections (M & N).
• Exercises
  1. Covering the relational model, ER design, relational design, relational algebra & calculus, and normalization:
     • exercises: PS, PDF
     • w/ answers: PS, PDF

• The textbook:
  • On-line support materials by Raghu Ramakrishnan and Johannes Gehrke.
    Includes:
    • Lecture Notes at Wisconsin
    • Answers to the odd-numbered exercises in the book.
• PRISM Accounts:
  You need a Prism computer account to do the projects (#2 and on). If you do not have one, get one set up.
  • PRISM
    • account information
• DB2 and SQL:
  • DB2 on PRISM (local)
    • Local DB2 information (PRISM)
    • Local JDBC information (for DB2 on PRISM)
  • From IBM:
    • SQL, Getting Started (old, v6, but useful)
    • SQL Reference (old, v6, but useful)
    • DB2 Application Development Guide (v7, PDF)
    • DB2 Version 7 Information Center