Schedule

A rigid schedule is not conducive to eﬀective learning, since it would limit our ﬂexibility 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 deﬁnite 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.


Tuesday	Thursday


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.

12th ×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.	25th ×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.

14th ×No class. Finals week Dec. 13–17. ⋆ Check Univ. schedule for ﬁnal exams.	16th ×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.