CS 348: Introduction to Database Management
Textbook
The textbook for the course is:
-
Database System Concepts,
Avi Silberschatz, Henry F. Korth, and S. Sudarshan (7th edition, required) [table of content]
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.
- Week 1:
Introduction to the Course,
Introduction to Database Management; reading: chapter 1 from textbook;
The Relational Data Model; reading: chapter 2 (except 2.3, 2.6).
- Week 2:
The Relational Data Model (cont.); reading: chapter 2 (except 2.3, 2.6)
- Week 3:
Introduction to SQL; reading: Chapter 3 (except 3.6)
how to use IBM DB2 at Waterloo,
sample database and
sample DML/queries for examples in the lecture notes.
- Week 4:
SQL with duplicates and NULL values; reading Chapter 4 (Intermediate SQL).
- Week 5:
Application Development and Static SQL; reading: Chapters 5.1, 5.2, 5.3.
(DB2 official documentation)
and sample Embedded SQL programs (and Makefile) used in class
Application Development and Dynamic SQL and ODBC
- Week 6:
Introduction to ER Modeling; reading: chapter 7.1-7.5, 7.7, 7.8, 7.9.1.
- Week 7:
no class (presenting a paper at a conference)
- Week 8:
ER to Relational Mapping
SQL Data Definition, Views, and Security; reading: chapter 7.6.
- Week 9:
Dependencies and Normal Forms; reading: chapter 8.1-8.6.
- Week 10:
Query/Update Execution; reading: chapter 2.6, 15.1-3, 15.5.1-4, 16.1
- Week 11:
Concurrent Access to Data and Transactions; reading: chapter 17.1-9
- Week 12:
Database Tuning
Extra Lecture: Query Optimization and Compilation(optional lecture)
- Week 13:
Review for Final Exam