Timetable

Jan 23

Introduction. Ch. 1.

Jan 28

Entity-relationship model. Ch. 2.

Jan 30, Feb 4, 6

Relational model. Ch. 3.

Feb 11, 13

Relational algebra. Ch. 4.

Feb 18, 20, 25

SQL: Queries, Constraints, Triggers, APIs. Ch. 5.

Feb 27, Mar 3, 5

Storage methods, index structures. Ch. 8-11.

Mar 10

Overflow material, review.

Mar 12

Midterm exam date.

Mar 24, 26, 31, Apr 2

Query processing and optimization. Ch. 12, 14, 15.

Apr 7, 9, 14

Transactions, concurrency control, recovery. Ch. 16-18.

Apr 16, 21, 23

Relational database design. Ch. 19.

Apr 28

Security. Ch. 21.

Apr 30

Overflow material.

May 5

No class.

May 7

Revision.