Lecture #
|
Topic
|
Reading
|
Assignments
|
1
|
Welcome and Introduction
|
Ch. 1
|
|
Discussion
|
Java Tutorial
|
|
|
2
|
ER Model
|
Ch. 2
|
|
3
|
Relational Model
|
Ch. 3
|
Homework 1 Out.
Project 1 Out.
|
Discussion
|
Project 1 Intro
|
|
|
4
|
ER to Relational
|
Ch. 3
|
|
5
|
Relational Algebra
|
Ch. 4
|
Homework 1 due at 11:55PM
|
Discussion
|
HW 1 Soln; Project 1 issues
|
|
|
6
|
Relational Algebra(contd.) + Relational Calculus
|
Ch. 4
|
Homework 2 Out
|
7
|
SQL
|
Ch. 5
|
Project 1 due at 11:55PM
|
Discussion
|
JDBC and Project 2 discussion
|
|
Project 2 Assigned
|
8
|
SQL (contd.) and Triggers
|
Ch. 5
|
|
9
|
Database Application Pogramming
|
Ch. 6, except 6.4 and 6.5
|
Homework 2 due at 11:55PM
|
Discussion
|
HW 2 solutions, Open topics
|
Read SQL Handout
|
|
10
|
Normalization
|
Ch. 19 except 19.8, and Ch. 20.7-20.9
|
|
11
|
Wrap up for First Half
|
|
Project 2 due at 11:55PM
|
Discussion
|
Exam Review
|
|
|
12
|
Disks and Files
|
Ch. 9, except 9.2
|
|
First Exam (7-9pm, location TBA)
|
|
|
|
Discussion
|
Postgres Overview
|
|
|
13
|
Storage & Indexing
|
Ch. 8
|
|
14
|
Storage & Indexing (contd)
|
|
|
Discussion
|
Exam solutions
|
|
|
No Class
|
|
|
|
No Class
|
|
|
|
No Class
|
|
|
Homework 3 Out (on March 9)
|
15
|
Tree-structured Indexing
|
Ch. 10 except 10.8.1
|
|
16
|
Hash-based Indexing
|
Ch. 11
|
|
Discussion
|
Problems on indexing
|
|
Project 3 assigned
|
17
|
Query Evaluation
|
Ch. 12 and 14
|
|
18
|
Sorting
|
Ch. 13
|
Homework 3 due on March 19 at 11:55PM
|
Discussion
|
Homework 3 solutions
|
|
|
19
|
Query evaluation
|
Ch. 12 Ch. 14
|
Homework 4 assigned
|
20
|
Query Evaluation
|
Ch. 12 Ch. 14
|
|
Discussion
|
Query evaluation review
|
|
|
21
|
Query Optimization
|
Ch. 15
|
Project 3 due on March 30th at 11:55pm. Project 4 out on March 31.
|
22
|
Transactions
|
Ch. 16, except 16.6; Ch. 17, up to and including 17.4
|
Homework 4 due on April 2 at 11:55pm.
|
Discussion
|
Project 4 intro and page counting, Homework 4 solutions
|
|
|
23
|
Transactions (contd.)
|
Ch. 18, except 18.6 and 18.8
|
Homework 5 assigned
|
24
|
Transactions (contd.)
|
|
|
Discussion
|
Open Topics
|
|
|
25
|
Open Topics
|
|
Homework 5 due at 11:55pm
|
26
|
Review
|
|
|
Discussion
|
Homework 5 solutions, Review
|
|
Project 4 due at 11:55pm
|
TBA
|
|
|
|
Second Exam (10:30am-12:30pm, locatoin TBA)
|
|
|
|