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.
|
Tuesday |
Thursday |
|
January 19th C1
Introduction; relational algebra. §§ 2.{1,2,4}.
|
21st C2
DBMS overview; queries; simple SQL. §§ 1.*, 2.3, 2.5.
|
|
26th C3
relational model and queries. §§ Readings 1 & 2.
|
28th C4
⋆ Quiz 1, regular class time & place.
|
|
February 2nd C5
SQL in detail. §§ 6.*
|
4th C6
SQL details, transactions. §§ 6.*
|
|
9th C7
Extended relational algebra. §§ 5.*
|
11th C8
Extended relational algebra. §§ 5.*
|
|
16th C9
⋆ Midterm Exam 1, regular class time & place.
|
18th C10
|
|
23rd C11
|
25th C12
|
|
March 1st C13
|
3rd C14
⋆ Quiz 2, regular class time & place.
|
|
8th
×No class. Spring break Mar. 7th–20th.
|
10th
×No class. Spring break Mar. 7th–20th.
|
|
15th
×No class. Spring break Mar. 7th–20th.
|
17th
×No class. Spring break Mar. 7th–20th.
|
|
22nd C15
|
24th C16
|
|
29th C17
|
31st C18
⋆ Quiz 2, regular class time & place.
|
|
April 5th C19
|
7th C20
|
|
12th C21
|
14th C22
|
|
19th C23
⋆ Midterm Exam 2, regular class time & place.
|
21st C24
|
|
26th C25
Special topic.
|
28th C26
Term project submissions due. Special topic.
|
|
May 3rd C27
⋆ Term Projects Demonstrations.
|
5th C28
Synthesis and review.
|
|
10th
×No class. Finals week May 9th–13th.
|
12th
×No
class. Finals
week
May
9th–13th.
|
|
|
|
|
|
|
|
|