Week

Session

Date

Topic

Teaching Method

Reading

Projects

Prob. Solving Assignments

1

1

10 Jan

Administrivia and Introduction

Lecture

Syllabus, R&G C1

 

 

 

2

12 Jan

The Entity-Relationship Model

Lecture

R&G C2

 

Start PS1

 

3

14 Jan

Case Study on Entity Relationship Diagram

Recitation

Notes from TA

 

 

2

4

17 Jan

The Relational Model Part I

Lecture

R&G C3

 

 

 

5

19 Jan

The Relational Model Part II

Lecture

R&G C3

 

 

 

6

21 Jan

Case Study on Relational Model

Recitation

Notes from TA

 

End PS1

3

7

24 Jan

Relational Algebra

Lecture

R&G C4.2

 

 

 

8

26 Jan

Relational Calculus

Lecture

R&G C4.3

 

Start PS2

 

9

28 Jan

Relational Algebra & Calculus Case Studies

Recitation

Notes from TA

 

 

4

10

31 Jan

The SQL Query Language (Part I)

Lecture

R&G C5

 

 

 

11

02 Feb

The SQL Query Language (Part II)

Lecture

R&G C5

Start P1

 

 

12

04 Feb

Hands-on PostgreSQL

Recitation

Notes from TA

 

 

5

13

07 Feb

The SQL Query Language (Part III)

Lecture

R&G C5

 

End PS2

 

 

09 Feb

Qatar National Sports Day

No Class

 

 

 

 

14

11 Feb

Quiz I

Quiz

N/A

 

 

6

15

14 Feb

JDBC

Lecture

 

 

 

 

16

16 Feb

Storing Data - Disks, Buffers,
and Files Part I

Lecture

R&G C8

End P1

 

 

17

18 Feb

Practicing JDBC

Recitation

Notes from TA

Start P2

 

7

18

21 Feb

Storing Data - Disks, Buffers,
and Files Part II

Lecture

R&G C9

 

 

 

19

23 Feb

Midterm

Exam 1

 

 

 

 

20

25 Feb

Project II

Recitation

Notes from TA

 

 

8

28 Feb – 03 Mar: Spring Break; No Classes

9

21

06 Mar

Tree-Based Indexing Part I

Lecture

R&G C10

 

 

 

22

08 Mar

Tree-Based Indexing Part II

Lecture

R&G C10

 

Start PS3

 

23

10 Mar

Project 2 Overview w/ JSPs

Recitation

Notes from TA

 

 

10

24

13 Mar

Hash-Based Indexing Part I

Lecture

R&G C11

 

 

 

25

15 Mar

Hash-Based Indexing Part II

Lecture

R&G C11

End P2

 

 

26

17 Mar

Project 3 Overview

Recitation

Notes from TA

Start P3

 

11

27

20 Mar

P2 Student Presentations

N/A

N/A

 

 

 

28

22 Mar

External Sorting

Lecture

R&G C12 & C13

 

 

 

29

24 Mar

Project 3 B+ Tree Implementation

Recitation

Notes from TA

 

End PS3

12

30

27 Mar

Algorithms for Relational Operators Part I

Lecture

R&G C12 & C14

 

 

 

31

29 Mar

Algorithms for Relational Operators Part II

Lecture

R&G C12 & C14

 

Start PS4

 

31

31 Mar

Query Optimization Part I

Lecture

R&G C15

 

 

13

32

03 Apr

Query Optimization Part II

Lecture

R&G C15

End P3

 

 

32

05 Apr

Transaction Management Part I

Lecture

R&G C16

 

 

 

33

07 Apr

Quiz II

N/A

N/A

 

 

14

34

10 Apr

Transaction Management Part II

Lecture

R&G C16

 

End PS4

 

35

12 Apr

Transaction Management Part III

Lecture

R&G C16

 

Start PS5

 

36

14 Apr

Logging and Recovery (Part I)

Lecture

R&G C18

 

 

15

37

17 Apr

Logging and Recovery (Part II)

Lecture

R&G C18

 

 

 

38

19 Apr

NoSQL Databases

Lecture

Notes from Professor

 

 

 

39

21 Apr

Exam II Review

Lecture

N/A

 

End PS5

16

40

27 Apr

Final

Exam 2