CS 348: Introduction to Database Management


Textbook

The textbook for the course is:

Copies of the book are on reserve in the DC library (call number UWD 1688).

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. Week 1:
    Introduction to the Course, Introduction to Database Management; reading: chapter 1 from textbook.
  2. Week 2:
    The Relational Data Model; reading: chapter 2.1-4 and 6.3.
    an other Other Data Models
  3. Week 3:
    Introduction to SQL
  4. Week 4:
    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
  5. Week 5:
    SQL with duplicates and NULL values
    Application Development and SQL sample Embedded SQL programs (and Makefile)
  6. Week 6:
    Application Development and SQL (DB2 official documentation)
  7. Week 7:
    Introduction to ER Modeling
  8. Week 8:
    ER to Relational Mapping SQL Data Definition, Views, and Security
    Review for Midterm and MIDTERM
  9. Week 9:
    Dependencies and Normal Forms
  10. Week 10:
    Query/Update Execution
  11. Week 11:
    Database Tuning
  12. Week 12:
    Concurrent Access to Data and Transactions
  13. Week 13:
    Review for Final Exam