Home

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

 Week Date  Contents  Reference  Download  Assigned  DUE
 1  1/9
Introduction  
syllabus
   
   1/11 E/R Model
Ch 2 er1    
 2 1/16
MLK Holiday




  1/18
E/R Model
Ch 2
er2

 3 1/23
E/R Model
Ch 2

prob1
prob1-sol
  1/25
E/R Practice

er-jeopardy


 4 1/30
Relational Model
Ch 5
rel1


  2/1
MS SQL
MSDN Tutorial vlab


 5 2/6
Relational Model
Ch 6
rel2 prob2
prob2-sol
  2/8
Referential Integrity Ch 7
ref-int hw1

 6 2/13
Normalization Ch 7
norm
proj1 Team Formation (2/14)
  2/15
Project #1 Discussion


team-conduct,
prob3
hw1-sol (2/19)
 7 2/20
SQL
Ch 4
basic1

Prelim setup due (proj1)
  2/22
Review Ch 2, 5, 6, 7 review1, sample midterm


 8 2/27
Midterm Ch 2, 5, 6, 7 midterm-sol (2017)


  3/1
Project #1 Discussion


proj1 (3/5)
 9 3/6
SPRING BREAK




  3/8
SPRING BREAK



 10 3/13
SQL
Ch 4
basic2


  3/15
SQL
Ch 4
join1
prob4
prob4
 11 3/20
SQL
Ch 4 join2

  3/22
Project #2 Discussion

proj2
hw2

 12 3/27
PHP Extra
php.zip

  3/29
SQL
Extra
grouping


 13 4/3
SQL
Extra
subquery


  4/5
PHP
Extra



 14 4/10
SQL Practice

sql-jeopardy
prob5
prob5
   4/11
(6:30-8pm)
 SQL basic tutorial

     
  4/12
Storage
Ch 8
storage
hw2-sol (4/16)
 15 4/17
Index
Ch 8
index, b+tree
prob6

  4/19
Review
Ch 2, 4, 5, 6, 7, 8
sample final
proj2 (4/21)
 16 4/24
Proj Presentation




  4/26
Proj Presentation



 17 5/3 WED
(8:00-9:50am)

FINAL @ Keller 210
Ch 2, 4, 5, 6, 7, 8 + Extra SQL
(PHP is NOT included)