CS 348: Introduction to Database Management


Textbook

The textbook for the course is:

Copies of the book are on reserve in the DC library.

The course notes in the following table are complementary to the lectures; they are not meant to replace the lectures. The textbook provides additional material to the course notes.

Schedule and Course Notes (by week of classes)

The following represents the intended lecture schedule. It may change as the term progresses.

It would help if you read the relevant material before the lecture; it is highly likely that I will not be covering everything in the book and lectures may go beyond the book.

  1. 09/05:
    Introduction to the Course, Introduction to Database Management; reading: chapter 1 from textbook.
  2. 09/10-12:
    The Relational Data Model; reading: chapter 2.1-4 and 6.3.
  3. 09/17-19:
    Introduction to SQL; reading: Chapter 3 (Introduction to SQL)
    how to use IBM DB2 at Waterloo, sample database for examples in the lecture notes
    and sample queries used in class sample (result), sample (result), sample, sample, sample
  4. 09/24-26:
    SQL with duplicates and NULL values; reading Chapter 4 (Intermediate SQL).
  5. 10/01-03:
    Application Development and Static SQL; reading: Chapters 5.1, 5.2, 5.3. Application Development and Dynamic SQL (DB2 official documentation)
    Application Development: ODBC (DB2 official documentation)
    and sample Embedded SQL programs (and Makefile) used in class
  6. 10/08-10:
    Introduction to ER Modeling; reading: chapter 7.1-7.5, 7.7, 7.8, 7.9.1.
    ER to Relational Mapping SQL Data Definition, Views, and Security; reading: chapter 7.6.
  7. 10/15-17:
    reading week
  8. 10/22-24:
    Dependencies and Normal Forms; reading: chapter 8.1-8.6.
  9. 10/29-31:
    More on Normal Forms Review for Midterm
  10. 11/05-07:
    Query/Update Execution,
  11. 11/12-14:
    Database Tuning
  12. 11/19-21:
    Concurrent Access to Data and Transactions
  13. 11/26-28:
    Extra Lecture: Query Optimization and Compilation
  14. 12/03:
    Review for Final Exam