CS 348: Introduction to Database Management

Fall 2012

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

Please make sure 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.

Date	Topic	Readings from book
Sept. 11	Introduction to the course, Introduction to DBMSs	Ch. 1
13	Conceptual database design: ER modeling	Ch. 2
18	Conceptual database design: ER modeling	Ch. 2
20	Relational model	Ch. 3 (3.1 - 3.2)
25	Relational model, Relational algebra	Ch. 3 (3.3 - 3.4) and Ch. 4 (4.1 - 4.2)
27	Relational algebra	Ch. 4 (4.1 - 4.2)
Oct. 2	Relational calculus	Ch. 4 (4.3)
4	Logical modeling: ER-to-relational mapping	Ch. 3 (3.5)
9	Introduction to SQL	Ch. 5
11	Introduction to SQL	Ch. 5
16	Introduction to SQL	Ch. 5
18	Introduction to SQL	Ch. 5
23	Advanced SQL: Writing applications	Ch. 6
24	Midterm Exam (5:10-7:10PM, MC 2034/2066/4045) Makeup Midterm Exam(only if you cannot make it at the above time): 2:40-4:40PM in MC 4062
25	Advanced SQL: Writing applications	Ch. 6
30	Transaction support in SQL	Ch. 16 (16.1, 16.2, 16.6)
Nov. 1	Transaction support in SQL	Ch. 16 (16.1, 16.2, 16.6)
6	Views and view management	Ch. 3 (3.6)
8	Constraints and normalization	Ch. 19 (19.1 - 19.2, 19.8)
13	Constraints and normalization	Ch. 19 (19.4 - 19.5)
15	Physical design and tuning	Ch. 20
20	Physical design and tuning	Ch. 20
22	Database security and privacy	Ch. 21 (21.1 - 21.4)
27	Parallel and distributed DBMSs	Ch. 22
29	Data warehousing	Ch. 25
Dec 19	Final Exam (7:30 -10:00PM, PAC 5,6)