NEW YORK UNIVERSITY

COMPUTER SCIENCES DEPARTMENT

Spring 1992

G22.2433-001

Database Systems (Graduate Level Course)

Instructor: Viswanath Poosala, Bell Labs, Lucent Technologies.



 
 

COURSE OUTLINE


The dates in this table are highly tentative but the topics are not expected to change (by much). Please refer back to this page to get the latest homework/project deadlines.
 
 

[BOLD = Finalized]
 
 
 
Date
Topic
Readings in Textbook
Project/Homework Deliverables
Jan 20
Introduction, E-R Model
1,2.1-2.6
 
Jan 27
E-R Model, Relational Model, Conversion from E-R to Relational
2.8,2.9, 3.1
C/CGI project handout
Feb 3
Relational Languages
3.2,3.3
 
Feb 10
SQL
4.1-4.6
C Project due
SQL HW handout
Feb 17
SQL updates
Integrity constraints
4.7-4.12, 6
 
Feb 24
Rel. Database Design
6.5,7.1-7.3
SQL HW due; Project description handout
Mar 2
Review, Storage
10.1,10.2
Project groups due
Mar 9
MIDSEM
 
 
Mar 16
SPRING BREAK
 
 
Mar 23
Storage, Indexing - ISAM
10.6,10.7,11.1,11.2
 
Mar 30
B+trees, Hashing
11.3,11.5
Project Design Due
Apr 6
Query processing, sorting
12.1,12.5,12.6.1-12.6.4
 
Apr 13
Cost formulas
lecture notes
 
Apr 20
Transactions
13.1-13.5.1; 13.9.1
 
Apr 27
Review / 
Exciting things in db
Lecture notes
Project due
May 4 FINAL  entire course material


Back to course page
 
 

Please email the instructor at poosala@cs.nyu.edu if you have any questions.