Course Schedule
This course schedule is tentative and might change as the semester progresses.
The textbook refers to the “cow book” (see the syllabus).
Lecture slides and notes will be uploaded here before each class. The slides are
designed to act only as an aid to the lectures, and not a replacement.
Furthermore, the lectures themselves
might often deviate significantly from the textbook in the order, presentation,
and actual content. Thus, attending all lectures, including the discussion
section lectures, is mandatory.
Module  Date  Topic  References  Slides  Activities 
 W 1/24  Introduction  Ch 1  lecture01  activity1 
A1  M 1/29  SQL: Basics  Ch 5.15.3  lecture02  activity2a + activity2b (activity2bsolutions) download the world database from here 
A1  W 1/31  SQL: Basics  Ch 5.15.3   
A1  M 2/5  Advanced SQL I  Ch 5.4  lecture03  activity3a + activity3b (solutions) 
A1  W 2/7  Advanced SQL II  Ch 5.5, 5.6  lecture04  activity4a (solutions) + activity4b 
A1  F 2/9  SQL: Discussion    discussion1 
A2  M 2/12  ER Model  Ch 2  lecture05  
A2  W 2/14  Functional Dependencies  Ch 19.119.3  lecture06  activity6 
A2  M 2/19  Functional Dependencies    
A2  W 2/21  Decomposition & Normalization  Ch 19.419.7  lecture07  activity7 
A2  F 2/23  Decomposition & Normalization    
A3  M 2/26  Relational Algebra  Ch 4.1,4.2  lecture08  activity8 
A3  W 2/28  Relational Alebra   lecture09  
B1  M 3/5  Data Storage & Buffer Management  Ch 9.1, 9.3, 9.4  lecture10  
B1  W 3/7  File Organization  Ch 9.5 9.7  lecture11  
 F 3/9  Review    
 M 3/12  MIDTERM    
B2  W 3/14  Indexing  Ch 8  lecture12  
B2  F 3/16  Hashing  Ch 11.1, 11.2  lecture13  
B2  M 3/19  B+ tree  Ch 10  lecture14  
 W 3/21  No class    
B2  M 4/2  Bitmaps   lecture15  
B3  W 4/4  External Sorting  Ch 13  lecture16  
B3  F 4/6  Relational Operators I  Ch 12.112.3, 14  lecture17  
B3  M 4/9  Relational Operators I & II  Ch 12.112.3, 14  lecture18  
B3  W 4/11  Relational Operators II  Ch 12.112.3, 14   
B3  F 4/13  Query Optimization  Ch 12.4  12.6, 15.2, 15.3  lecture19  
B3  W 4/18  Query Optimization  Ch 12.4  12.6, 15.2, 15.3   
B4  M 4/23  Transaction Management I  Ch 16  lecture20  
B4  W 4/25  Transaction Management II  Ch 16  lecture21  
 M 4/30  Advanced Topics    
 W 5/2  Review    
 S 5/6  FINAL EXAM   

