Home

NOTE:
  • ID/PWD to access course materials will be distributed in the first class.
  • NE: New Edition, OE: Old Edition
  • Old course materials: https://wikispaces.psu.edu/display/IST210Sec1/

 Week Date  Contents  Reference  Download Assigned  DUE
 1 8/26
Programming  
    
  8/28Programming


  
 2 9/2
LABOR DAY
(NO CLASS)




  9/4Programming



 3 9/9E/R ModelCh 2 (NE) / Ch 3 (OE)er1


  9/11E/R Model
er2

 4 9/16E/R Model


prob #2

  9/18
ER practice
er-jeopardy
prob #2
 5 9/23Relational Model
Ch 5 (NE/OE)rel1

  9/25Relational ModelCh 6 (NE/OE)vlabs
prob #3

prob #3
 6 9/30Relational ModelCh 7 (NE/OE)rel2

  10/2Referential Integrity
Ch 6 (NE/OE)ref-int
Team Formation
 7 10/7
Project Discussion

proj #1
prob #4
prob #4
  10/9Review

online


 8 10/14MIDTERM
solution (2013)sample midterm
(2012)


  10/16
Project Discussion


 9 10/21SQL
Ch 4 (NE) / CH 9 (OE)
basic 1


  10/23SQL

basic 2prob #5
prob #5
 10 10/28SQL

join 1,
northwind

proj #1 (10/27)
  10/30SQL
join 2HW #1

 11 11/4
Project Discussion


  11/6SQL

grouping
proj #2
 12 11/11SQL

subquery

  11/13
Project Discussion


 13 11/18
SQL practicesql-jeopardy
(solution)
prob #6
prob #6
  11/20Storage
CH 8 (NE) / CH 2 (OE)storage

 14 11/25
THANKSGIVINGNO CLASS


  11/27 THANKSGIVING NO CLASS

HW #1 (extended due: 12/1)
 15 12/2Index
CH 8 (NE) / CH 2 (OE)index

  12/4Course Review

B+ Tree
proj #2 (12/8)
 16 12/9Proj Presentation




  12/11Proj Presentation




 17
 FINAL WEEK
 sample final
(2012)