EECS 647: Introduction to Database Systems

Schedule and Lecture Notes
http://ittc.ku.edu/~jhuan/EECS647_F13






Green cells denote no class                                                                                     
Class schedule is tentative and is subject to change according to class progress
Slides that appear before class meeting might have errors and the errors will be fixed after class meeting

Week Date Topic Reading Slides Assigned
Due
1
Aug 26
Introduction to DB
Introduction


1
Aug 28
ER

ER


1
Aug 30
Relational model




2
Sept 2
Labor day holiday




2
Sept 4
relational model

Relational model


2
Sept 6
Lab I

SQL


3
Sept 9
relational algebra

RA


3
Sept 11
relational algebra II

RAII


3
Sept 13
Projects



4
Sept 16
Mapping ER to relational models
Mapping


4
Sept 18
FD

FD


4
Sept 20
Lab II

Lab II


5
Sept 23
FD




5
Sept 25
Lab III

Lab III

5
Sept 27
SQL

SQL


6
Sept 30
DB Programming

DB


6
Oct 2
DB Programming Cont.



6
Oct 4
SQL II

SQL II


7
Oct 7
Lab IV
Lab IV
phpMyAdmin


7
Oct 9
Midterm I




7
Oct 11
SQL III

SQL III
CGI


8
Oct 14
Fall break




8
Oct 16
SQL IV

SQL IV


8
Oct 18
SQL IV




9
Oct 21
SQL V

SQL V


9
Oct 23
FD II

FD2

9
Oct 25
FD II




10
Oct 28
Disk

Disk

10
Oct 30
Index

Index


10
Nov 1
Index (cont.)




11
Nov 4
Index (cont.)



11
Nov 6
Index (cont.)



11
Nov 8
Query Processing
QP


12
Nov 11
Query Processing (cont.)




12
Nov 13
B+-tree review




12
Nov 15
Transaction Control
Transactions

13
Nov 18
Midterm review




13
Nov 20
Midterm II



13
Nov 22
Concurrency control

CC


14
Nov 25
Concurrency control(cont.)



14
Nov 27
Thanksgiving




14
Nov 29
Thanksgiving



15
Dec 2
Data Analytics
DM


15
Dec 4
Data Analytics II



15
Dec 6
Association Rule

AR


16
Dec 9
NoSQL




16
Dec 11
Student Project Presentation ( Harmon & Turner; Grimberg & Chen,

Sherchan & Mar)





16
Dec 13
Stop Day