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 13Conceptual database design: ER modeling Ch. 2 18Conceptual database design: ER modeling Ch. 2 20Relational model Ch. 3 (3.1 - 3.2) 25Relational model, Relational algebra Ch. 3 (3.3 - 3.4) and Ch. 4 (4.1 - 4.2) 27Relational algebra Ch. 4 (4.1 - 4.2) Oct. 2Relational calculus Ch. 4 (4.3) 4Logical modeling: ER-to-relational mapping Ch. 3 (3.5) 9Introduction to SQL Ch. 5 11Introduction to SQL Ch. 5 16Introduction to SQL Ch. 5 18Introduction to SQL Ch. 5 23Advanced SQL: Writing applications Ch. 6 24Midterm 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
25Advanced SQL: Writing applications Ch. 6 30Transaction support in SQL Ch. 16 (16.1, 16.2, 16.6) Nov. 1Transaction support in SQL Ch. 16 (16.1, 16.2, 16.6) 6Views and view management Ch. 3 (3.6) 8Constraints and normalization Ch. 19 (19.1 - 19.2, 19.8) 13Constraints and normalization Ch. 19 (19.4 - 19.5) 15Physical design and tuning Ch. 20 20Physical design and tuning Ch. 20 22Database security and privacy Ch. 21 (21.1 - 21.4) 27Parallel and distributed DBMSs Ch. 22 29Data warehousing Ch. 25 Dec 19Final Exam (7:30 -10:00PM, PAC 5,6)