A rigid schedule is not conducive to effective learning, since it would limit our flexibility in exploring ideas as they arise in class. The actual schedule (both the timing and the selection of topics) will be determined by in-class interactions. Nevertheless, a partial and approximate schedule, to serve as a baseline, appears in Figure 1; it will be updated as we progress. Please use it only as a rough guide to plan your studies. Do not use it to schedule travel or other events. If you need a definite answer on when something will or will not occur, you should check with me.

At the beginning and end of each class, I typically announce the topics and textbook sections covered in that class and those due at the next class. It is important that students read the material before the class in which it is discussed and, in general, keep up with readings and studies.



August 31st     C1

Introduction; databases; queries.

September 2nd     C2

Quick introduction to query languages: SQL, algebra.

7th     C3

Overview of Database Management Systems (DBMS); query languages contd. §§ 1.*.

9th     C4

Relational model basics. §§ 2.0–2.2.

14th     C5

Relational model and algebra. §§ 2.3–2.4.

16th     C6

Relational model, constraints. §§ 2.*.

21st     C7

 Quiz 1, regular class time & place.

23rd     C8

Relational design theory. §§ 3.1–3.3.

28th     C9

Decomposition, normal forms. §§ 3.4-3.5.

30th     C10

Multivalued dependencies. §§ 3.6-3.9.

October 5th     C11

ER modeling. §§ 4.0-4.4.

7th     C12

 Midterm Exam 1, regular class time & place.


 ×No class. Fall break Oct. 11–12.

14th     C13

Mapping ER models. §§ 4.5-4.6.

19th     C14

Extended relational algebra. §§ 5.0-5.2.

21st     C15

Logic for queries; Datalog. §§ 5.3-5.4.

26th     C16

SQL. §§ 6.0–6.3.

28th     C17

More SQL, transactions. §§ 6.4–6.8.

November 2nd     C18

 Quiz 2, regular class time & place.

4th     C19

Constraints. §§ 7.0–7.4.

9th     C20

Triggers. §§ 7.5–7.7.

11th     C21

Views and indexes. §§ 8.*.

16th     C22

Recursion in SQL. §§ 10.2.

18th     C23

 Midterm Exam 2, regular class time & place.

23rd     C24

Object-relational model. §§ 10.3–10.5.


 ×No class. Thanksgiving break Nov. 24–28.

30th     C25

OLAP and Data Cubes. §§ 13.6–13.9.

December 2nd     C26

XPath. §§ 12.0–12.1.

7th     C27

XQuery. §§ 12.2.

9th     C28

XSLT §§ 12.3-12.5.


 ×No class. Finals week Dec. 13–17.
 Check Univ. schedule for final exams.


 ×No class. Finals week May 7th–11th.
 Final exam: Dec. 16 09:30–11:30.

Figure 1: Approximate schedule, likely to change. Textbook items are in §§ chapter.section format.