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 lecture-01 activity-1
A1 M 1/29 SQL: Basics Ch 5.1-5.3 lecture-02 activity-2a + activity-2b (activity-2b-solutions)
download the world database from here
A1 W 1/31 SQL: Basics Ch 5.1-5.3
A1 M 2/5 Advanced SQL I Ch 5.4 lecture-03 activity-3a + activity-3b (solutions)
A1 W 2/7 Advanced SQL II Ch 5.5, 5.6 lecture-04 activity-4a (solutions) + activity-4b
A1 F 2/9 SQL: Discussion discussion-1
A2 M 2/12 ER Model Ch 2 lecture-05
A2 W 2/14 Functional Dependencies Ch 19.1-19.3 lecture-06 activity-6
A2 M 2/19 Functional Dependencies
A2 W 2/21 Decomposition & Normalization Ch 19.4-19.7 lecture-07 activity-7
A2 F 2/23 Decomposition & Normalization
A3 M 2/26 Relational Algebra Ch 4.1,4.2 lecture-08 activity-8
A3 W 2/28 Relational Alebra lecture-09
B1 M 3/5 Data Storage & Buffer Management Ch 9.1, 9.3, 9.4 lecture-10
B1 W 3/7 File Organization Ch 9.5 -9.7 lecture-11
F 3/9 Review
M 3/12 MIDTERM
B2 W 3/14 Indexing Ch 8 lecture-12
B2 F 3/16 Hashing Ch 11.1, 11.2 lecture-13
B2 M 3/19 B+ tree Ch 10 lecture-14
W 3/21 No class
B2 M 4/2 Bitmaps lecture-15
B3 W 4/4 External Sorting Ch 13 lecture-16
B3 F 4/6 Relational Operators I Ch 12.1-12.3, 14 lecture-17
B3 M 4/9 Relational Operators I & II Ch 12.1-12.3, 14 lecture-18
B3 W 4/11 Relational Operators II Ch 12.1-12.3, 14
B3 F 4/13 Query Optimization Ch 12.4 - 12.6, 15.2, 15.3 lecture-19
B3 W 4/18 Query Optimization Ch 12.4 - 12.6, 15.2, 15.3
B4 M 4/23 Transaction Management I Ch 16 lecture-20
B4 W 4/25 Transaction Management II Ch 16 lecture-21
M 4/30 Advanced Topics
W 5/2 Review
S 5/6 FINAL EXAM