CS 348: Introduction to Database Management


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. 05/02:
    Introduction to the Course, Introduction to Database Management; reading: chapter 1 from textbook.
  2. 05/07-09:
    The Relational Data Model; reading: chapter 2.1-4 and 6.3.
  3. 05/14-16:
    Introduction to SQL; reading: Chapter 3 (Introduction to SQL).
  4. 05/21-23:
    Victoria day (Monday schedule on Tue 05/22!);
    SQL with duplicates and NULL values; reading Chapter 4 (Intermediate SQL).
  5. 05/28-30:
    More on 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
    Application Development and SQL; reading: Chapters 5.1, 5.2, 5.3. sample Embedded SQL programs (and Makefile)
    Application Development and SQL (DB2 official documentation)
  6. 06/04-06:
    Application Development: ODBC (DB2 official documentation)
    Introduction to ER Modeling; reading: chapter 7.1-7.5, 7.7, 7.8, 7.9.1.
  7. 06/11-13:
    ER to Relational Mapping SQL Data Definition, Views, and Security; reading: chapter 7.6.
  8. 06/18-20:
    Dependencies and Normal Forms; reading: chapter 8.1-8.6.
    Review for Midterm
  9. 06/25-27:
    More on Normal Forms
  10. 07/02-04:
    Canada day; Query/Update Execution,
  11. 07/09-11:
    Database Tuning
  12. 07/16-18:
    Concurrent Access to Data and Transactions
  13. 07/23-25:
    Extra Lecture: Query Optimization and Compilation
    Review for Final Exam