CS 4250, Fall 2017   Class Schedule, Lecture Notes

Note: Schedule will change please check regularly.

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