01:198:336 Principles of Database Management Systems
Sections 01, 02, 03
Spring 2002 - Course Syllabus

(Subject to ongoing revision)

Date Topic
Text (S&K&S 4th Ed.)
Jan 24 Introduction to Database Systems Architecture
Physical Storage and File Organization
Chapter 1
Chapter 11



Jan 31
 The Entity-Relationship  Model and  Diagrams 
Chapter 2

DATABASE DESIGN PROJECT: Handed Out
IMPLEMENTATION ASSIGNMENT 1: HANDED OUT



Feb  7 The Relational  Model, Relational Algebra and the Relational Calculus
Chapter 3



Feb 14 SQL
Chapter 4



Feb 21 Advanced SQL
Object-Oriented and Object-Relational DBMS
Chapter 4
Chapters 8-9

IMPLEMENTATION ASSIGNMENT 2: HANDED OUT

IMPLEMENTATION ASSIGNMENT 1: DUE


 
Feb 28 File Indexing and Hashing
 Chapter 12



Mar  7  MIDTERM EXAM  



Mar  14 B+ Tree Indexing
Chapter 11



Mar  21
 Spring Break



Mar  28
 Functional Dependencies, Normal Forms and Normalization
Chapter 7



Apr  4 Concurrency and Serializability
Chapters 15-16

DATABASE DESIGN PROJECT: E-R and Relational Design Due



Apr 11 Transactions and Recovery
Chapters 15-16
Chapter 17

IMPLEMENTATION ASSIGNMENT 2: DUE



Apr  18 Locking and Timestamp Protocols
Chapter 16



Apr 25 Database mining and Knowledge Discovery
Chapter 22


 
May 2 PROJECT DEMOS 6:00-10:00PM HILL 427
DATABASE DESIGN PROJECT: Implementation Package Due



May 9 FINAL EXAM 8:00-11:00PM