Home

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

 Week Date  Contents  Reference  Download Assigned  DUE
 1 8/27
  Course Intro.
 
 syllabus   
  8/29E/R Model
Ch 2 (NE) / Ch 3 (OE)
binary
  
 2 9/3
LABOR DAY
(NO CLASS)




  9/5E/R Model
ternary


 3 9/10E/R Model

Q #1
Q #1
  9/12E/R Model
ER jeopardy


 4 9/17Relational Model
Ch 5 (NE/OE)
rel-model
vlabs-tutorial


  9/19Relational ModelCh 6 (NE/OE)
Q #2
HW #1
Q #2
 5 9/24Relational Model
Ch 7 (NE/OE)


  9/26


Q #3
Q #3
HW #1 (9/30)
 6 10/1Relational Model
rel-model 2


  10/3Referential Integrity
Ch 6 (NE/OE)ref-int
HW #1 Solution
Team Formation
 7 10/8Project Discussion

Proj #1

  10/10Review




 8 10/15MIDTERM

sample midterms
(2010, 2011)


  10/17Project Discussion
midterm 2012

 9 10/22SQL
Ch 4 (NE) / CH 9 (OE)
basic 1
Q #4
Q #4
  10/24

basic 2

Proj #1 (10/28)
 10 10/29UP CLOSED



  10/31

Northwind Schema
join 1
Q #5
Q #5
 11 11/5

join 2HW #2
Proj #2

  11/7

grouping

 12 11/12Project Discussion



  11/14

subquery/update

 13 11/19THANKSGIVING




  11/21(NO CLASS)




 14 11/26


SQL Jeopardy
(solution)


  11/28 Storage CH 8 (NE) / CH 2 (OE)
storage
  HW #2 (12/2)
 15 12/3Index
CH 8 (NE) / CH 2 (OE)index


  12/5Course Review



Proj #2 (12/9)
 16 12/10Proj Presentation


HW2 Solution

  12/12Proj Presentation
12/12 WED
7pm-8:30pm @ 110
Q&A session




 1712/19 WED 6:50--8:40PM @ 113 IST
 FINAL WEEK
 sample finals
(2010, 2011)