CS 4250, Spring 2017   Class Schedule, Lecture Notes

Note: Schedule will change please check regularly.

WK Class/Date Topic Book Chapter Homeworks Lecture Notes
1 Thu 1/26 Introduction Ch 1 Project Part 1 assigned Lecture 1
2 Tue 1/31 Database Planning and the Entity-Relationship Model Ch 2-3 Chapter 2 and 3 slides
Thu 2/2 Project Part 2 assigned
3 Tue 2/7 Relational Model : EER to Relational Ch 4 Project Part 1 due
Hwk 1 assigned
Chapter 4 slides
Thu 2/9
4 Tue 2/14 Project Part 2 due
Thu 2/16 SQL, SQL, SQL Ch 5 Hwk 1 due
Project Part 3 assigned
R.A. exercise slide
Chapter 5, Part A
5 Tue 2/21 Hwk 2 assigned
Thu 2/23 Quiz
6 Tue 2/28
Thu 3/2
7 Tue 3/7 Still SQL... Project Part 3 due (old)
Thu 3/9 Group work Mini-Homework 1 assigned
8 Tue 3/14 Still SQL... and now some SQL -to- PL API Hwk 2 due Chapter 5, Part B
Thu 3/16 JDBC, ODBC, HTML, PHP... and Normalization Ch 6 Project Part 3 due (new)
Mini-Homework 1 due
9 Tue 3/21 School Holiday: Spring Break
Thu 3/23 School Holiday: Spring Break
10 Tue 3/28 More Database Normalization Project Part 4 assigned Chapter 6 slides
Thu 3/30 Midterm
11 Tue 4/4 Project Part 5 assigned
Thu 4/6 Transactions and Concurrency Control Ch 9 Hwk 3 assigned Chapter 9 slides
12 Tue 4/11 Project Part 4 due (old)
Thu 4/13 Project Part 6 assigned
13 Tue 4/18 Project Part 4 due (new)
Thu 4/20 Quiz Hwk 3 due
14 Tue 4/25 Relational Query Optimization Ch 13 Hwk 4 assigned
Project Part 7 assigned
Chapter 13 slides
Thu 4/27 Project Part 5 due
15 Tue 5/2 Database Security Ch 8 Project Part 6 due
Thu 5/4
16 Tue 5/9 Chapter 8 slides
Thu 5/11 Database Indexing B+Tree slides
17 Tues 5/16 Course Wrap-Up, Q & A Hwk 4 due (5/16)
Project Part 7 due (5/19)
Wrap-Up slides
Thursday 5/18 FINAL EXAM
Location: CX 102
Time: 11:15 am - 1:15 pm