Home

NOTE: ID/PWD to access course materials will be distributed in the first class.

 Week Date  Contents  Reference  Download Assigned  DUE
 1 8/23
  Course Intro.
 
 syllabus   
  8/25 Storage Ch 2 file/disk  
 2 8/30
 Index (Linear)
 Ch 2
  index  
  9/1 Index (Hashing)
 
 prob #1
prob #1
 3 9/6 Index (B+ Tree)

   
  9/8 E/R Model
Ch 3
 binary relationship
  
 4 9/13 E/R Model  unary/ternary relationship 
  9/15E/R Model   prob #2

prob #2
(solution)
 5 9/20E/R Jeopardy
 jeopardy

 Proj. Team Formation 
  9/22Proj #1 Discussion
  proj #1
hw #1
 
 6 9/27Relational Model 
 Ch 5  rel-model  
  9/29VLabs

  psu-vlabs  
 7 10/4Relational Model
     prob #3hw #1
(solution)
  10/6  Midterm Review    
 8 10/11 MIDTERMCh 2, 3, 5
2010 sample
  
  10/13 Proj #1 Discussion  2011 Midterm
  proj #1
(10/16)
 9 10/18 Relational Model
 Ch 6
  rel-model 2
  
  10/20     
 10 10/25 Relational Model
 Ch 6
  integrity
 prob #4 prob #4
  10/27 SQL Ch 9
 basic 1
 proj #2 
 11 11/1   basic 2
 hw #2
 prob #5
 prob #5
  11/3 Proj #2 Discussion 
  
 12 11/8 SQL Ch 9
 join 1
  
  11/10 
  join 2
prob #6 prob #6
 13 11/15 SQL extra group-by
  
  11/17 extra
 subquery/update
  
 14 
 NO CLASS--THANKSGIVING
    
 15 11/29 Proj #2 Discussion   prob #7 hw #2
  12/1Class Review
 review 
 16 12/6 Proj Presentation
  presentation materials
  proj #2
(12/5 MONDAY 11:55PM)
  12/8 Proj Presentation    
 17  FINAL WEEK
(TUE 12:20P-2:10P 104 CHAM)
  2010 sample