Home

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

 Week Date  Contents  Reference  Download Assigned  DUE
 1 8/25
Introduction  
syllabus
   
  8/27E/R Model
Ch 2er1  
 2 9/1
LABOR DAY




  9/3E/R ModelCh 2er2

 3 9/8E/R ModelCh 2
prob1 solutionprob1
  9/10E/R Practice
er-jeopardy

 4 9/15Relational Model
Ch 5 and 6
rel1

  9/17MS SQL
MSDN Tutorial
vlab

 5 9/22Relational ModelCh 5 and 6
rel2prob2
prob2
  9/24Referential Integrity
Ch 7
ref-inthw1

 6 9/29NormalizationCh 7
norm
Team Formation
  10/1Project Discussion


proj1, team-conductprob3
 7 10/6Review
Ch 2, 5, 6, 7
2013 sample

  10/8Midterm
Ch 2, 5, 6, 7
midterm solution
hw1 (10/12)
solution
 8 10/13Project Discussion



  10/15SQL
Ch 4
basic1

 9 10/20SQL
Ch 4basic2prob4
prob4
  10/22Project Discussion


proj1 (10/26)
 10 10/27SQL
Ch 4join1


  10/29SQL
Ch 4join2


 11 11/3PHP




  11/5PHP


proj2
 12 11/10SQL

grouping
prob5
prob5
  11/12Project Discussion

hw2
 13 11/17SQL

subquery

  11/19SQL Practice
Northwind Schemasql-jeopardy
prob6
prob6
 14 11/24
THANKSGIVING



  11/26THANKSGIVING



 15 12/1Storage
Ch 8
storage

  12/3Index
Ch 8
index

 16 12/8Review

b+ tree exercise
proj2 (12/7)
(12/9) 11:55PM
  12/10Project Presentation


hw2 (12/10)
(12/12) 11:55PM
solution
 1712/17 4:40P-6:30P  FINAL
@ 011 AG SC IN
All materials
2013 sample