CS 440 Introduction to Databases

Lecture Notes


Lecture Topic PDF/PPT Next Lecture Reading
Tue, Jan. 4
Course introduction
Review of data models and data independence
PDF
Ch.1-3 of EN
Thur, Jan. 6

Review of ER modeling

PDF
Ch. 8 of EN
Tue, Jan. 11
Review ER-Relational Mapping
Review of SQL language
PDF

Ch. 6 of EN

Thur, Jan. 13

Review of Relational algebra

PDF
Ch. 7 of EN
Tue, Jan. 18
No Class!
 
Ch. 15 of EN
Thur, Jan. 20
Normal forms
PDF
Ch. 15 of EN
Tue, Jan. 25
Normal forms - continued
Ch. 16 of EN
Thur, Jan. 27
Normal forms - continued
Ch. 16 of EN
Tue, Feb. 1
Normal forms - continued
Ch. 16 of EN
Thur, Feb. 3

Normal forms - continued

Tue, Feb. 8
Database design life cycle
Thur, Feb. 10
Midterm review
Tue, Feb. 15
Midterm
Ch. 17 of EN
Thur, Feb. 17
Primary file organization
Ch. 18 of EN
Tue, Feb. 22
File indexing
Ch. 19 of EN
Thur, Feb. 24
Query processing
Ch. 19 of EN
Tue, Mar. 1
Query optimization
Thur, Mar. 3
New types of databases
Tue, Mar. 8
Final project - presentation

 

Thur, Mar. 10
No Class!