CS4431 C-term 2001


Lee A. Becker, lab@cs.wpi.edu, (508)831-5408
TA: Yan Huang, hy@cs.wpi.edu
TA: Bin Liu, binliu@cs.wpi.edu

Office Hours C2001: M 9-10, Tu 8:30-9:30, Th 1:30-2:30, Fuller Labs 132
 TA Yan Huang Office Hours: M 1:30-2:30, W 2-4, Th 2-3 Fuller Labs A20
 TA Bin Liu Office Hours: Tu 2:30-3:30, Th 3-4, F 1-3, Fuller Labs A20

DATE TOPICS READINGS DUE
1/11 Introduction 1, 2.1  
1/12 Basic Concepts, DB Modeling: ODL 2.1, 2.2, 2.3  
1/15 DB Modeling ODL and ER 2.2 - 2.5  
1/16 Design Principles, Subclasses, Weak Entity Sets 2.4 - 2.7  
1/18 Relational Model 3.1, 3.2 HW #1
1/19 ODL / ER to Relational 3.2 - 3.4  
1/22 Functional Dependencies 3.5, 3.6 GDA #1
1/23 Functional Dependencies 3.5, 3.6  
1/25 Normalization 3.6, 3.7 HW #2
1/26 Normalization 3.7, 3.8  
1/29 Relational Algebra 4.1 GDA #2
1/30 Relational Algebra, Bags 4.5 - 4.7  
2/1 Introduction to SQL 5.1, 5.2 HW #3
2/2 SQL Basics, Subqueries 5.2 - 5.4  
2/5 Mid-term EXAM covers material through Normalization GDA #3
2/6 Subqueries, Aggregation, DB Modifications 5.4 - 5.8  
2/8 Schemas, Views, Nulls 5.6 - 5.9  
2/9 Keys and Constraints in SQL 6.1 - 6.6  
2/12 Embedded SQL 7.1 GDA #4
2/13 Embedded SQL with Java: JDBC Notes  
2/16 Transactions in SQL 7.2 HW #4
2/19 XML and Relational DBs Notes  
2/20 Datalog 4.2 - 4.3 GDA #5
2/22 Recursion in SQL3 and Datalog 4.4, 5.10  
2/23 Data Mining Notes HW #5
2/26 Review for Final    
2/27 Final EXAM cumulative, stresses material from 1/29 on  
3/1 Final Exam Key Available   GDA #6

Grading: Group Database Application 26%, Homework 20%, Mid-term Exam 27%, Final Exam 27%