CMSC424: Database Design

Prof. Amol Deshpande;    CSIC 1121;    Tue-Thur 12:30pm-1:45pm


[Home] [Schedule] [Project/Assignments/Homeworks]

Tentative Schedule (Subject to Change)

Note 1: The schedule below was copied from Fall 2008 schedule, and may undergo some changes within next week.

Note 2: The chapter numbers refer to the 5th Edition. In class we may jump around the sections, so the chapter numbers written below may not precisely match what was covered that day.

Date     Day   Topic Book Chapters Notes
Sep 1 Tue Introduction to the class 1 [intro-pptx] [intro-HTML]
Sep 3 Thu Entity-relationship Model 6 (except 6.11) [ER-Relational-pptx] [ER-Relational-pdf]
Sep 8 Tue ER Model; Relational Model 6 (except 6.11), 2  
Sep 10 Thu Converting ER to Relational 6 (except 6.11), 2  
Sep 15 Tue SQL 2, 3 (except 3.11), 4.2, 8.6 [SQL-RA-pptx]   [SQL-RA-pdf] Movies DB Queries  
Sep 17 Thu Relational Algebra; SQL (continued)  
Sep 22 Tue SQL (continued)  
Sep 24 Thu SQL (continued)  
Sep 29 Tue SQL Chapter 7  
Oct 1 Thu Integrity Constraints; Normalization Chapter 7 [Normalization-pptx] [Normalization-pdf]
Oct 6 Tue Normalization Chapter 7  
Oct 8 Thu Midterm 1    
Oct 13 Tue Normalization Chapter 7  
Oct 15 Thu Normalization; Storage: Files Chapter 4, 8  
Oct 20 Tue Storage: Files Chapter 11 [Storage-pptx]   [Storage-pdf]  
Oct 22 Thu Storage: Indexing/Hashing Chapter 12, except 12.4, 12.9.  
Oct 27 Tue Storage: Indexing/Hashing    
Oct 29 Thu Storage; Query Processing; Chapter 13. [Query-Proc.-pptx]   [Query-Proc.-pdf]  
Nov 3 Tue Query processing; Join algorithms; Sorting    
Nov 5 Thu Query processing    
Nov 10 Tue Midterm 2    
Nov 12 Thu Query optimization Chapter 14, except 14.5 [Query-Opt-pptx] [Query-Opt-pdf]  
Nov 17 Tue Query optimization    
Nov 19 Thu Query optimization    
Nov 24 Tue Query optimization    
Nov 26 Thu Thanksgiving    
Dec 1 Tue Transactions; Concurrency Chapter 15; Chapter 17, except 17.8, 17.9. [ACID-pptx] [ACID-pdf]  
Dec 3 Thu Recovery    
Dec 8 Tue Recovery;    
Dec 10 Thu Miscellaneous Topics; Wrapup    
Dec 18 Friday FINAL (Mon 1:30pm - 3:30pm)