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.
|
Monday |
Wednesday |
Friday |
|
September 2nd
×No class. Labor Day.
|
4th C1
Relational algebra basics. §§ 2.4.
|
6th C2
Introduction; Database systems. §§ 1.*.
|
|
9th C3
Relational model. §§ 2.0–2.4.
|
11th C4
Relational model, contd. §§ 2.5-2.7.
|
13th C5
Catch-up and review.
|
|
16th
⋆ Quiz 1
|
18th C6
SQL. §§ 6.0–6.3.
|
20th C7
Relational design theory. §§ 3.1–3.3.
|
|
23rd C8
Decomposition, normal forms. §§ 3.4-3.5.
|
25th C9
Catch-up and review.
|
27th
⋆ Midterm Exam 1
|
|
30th C10
Multivalued dependencies. §§ 3.6-3.9.
|
October 2nd C11
ER modeling. §§ 4.0-4.4.
|
4th C12
Mapping ER models. §§ 4.5-4.6.
|
|
7th C13
Extended relational algebra. §§ 5.0-5.2.
|
9th C14
Logic for queries; Datalog. §§ 5.3-5.4.
|
11th
⋆ Quiz 2
|
|
14th
×No class. Fall break Oct. 14th–15th.
|
16th C15
Catch-up and review.
|
18th C16
More SQL, transactions. §§ 6.4–6.8.
|
|
21st C17
Constraints. §§ 7.0–7.4.
|
23rd C18
Catch-up and review.
|
25th
⋆ Midterm Exam 2
|
|
28th C19
Triggers. §§ 7.5–7.7.
|
30th C20
Views and indexes. §§ 8.*.
|
November 1st C21
Recursion in SQL. §§ 10.2.
|
|
4th C22
Recursion in SQL. §§ 10.2.
|
6th C23
Catch-up and review.
|
8th
⋆ Quiz 3
|
|
11th
×No class. Veterans Day.
|
13th C24
Object-relational model. §§ 10.3–10.5.
|
15th C25
OLAP and Data Cubes. §§ 13.6–13.9.
|
|
18th C26
XPath. §§ 12.0–12.1.
|
20th C27
Catch-up and review.
|
22nd
⋆ Midterm Exam 3
|
|
25th C28
XQuery. §§ 12.2.
|
27th
×No class. Thanksgiving break Nov. 27th–Dec. 1st.
|
29th
×No class. Thanksgiving break Nov. 27th–Dec. 1st.
|
|
December 2nd C29
XSLT §§ 12.3-12.5.
|
4th C30
Special topic.
|
6th C31
Special topic.
|
|
9th C32
Special topic.
|
11th C33
Synthesis and review.
|
13th C34
Synthesis and review.
|
|
16th
×No class. ⋆ Final exam: Dec. 16th 12:15–2:15 p.m.
|
18th
×No class. ⋆ Finals week Dec. 16th–20th.
|
20th
×No class. ⋆ Check Univ. schedule for final exams.
|
|
|
||
|
|
||
|
|