CS 4250, Spring 2018   Class Schedule, Lecture Notes

Note: Schedule will change please check regularly.

WK Class/Date Topic Book Chapter Homeworks Lecture Notes
1 Thu 1/25 Introduction Ch 1 Lecture 1
2 Tue 1/30 Database Planning and the Entity-Relationship Model Ch 2-3 Project Part 1 assigned Chapter 2 and 3 slides
Thu 2/1 Project Part 2 assigned
3 Tue 2/6 Relational Model : EER to Relational Ch 4 Project Part 1 due Chapter 4 slides
Thu 2/8
4 Tue 2/13 Relational Model : Relational Algebra Project Part 2 due (old)
Hwk 1 assigned
R.A. exercise
Thu 2/15 R.A. wrap-up, and SQL, SQL, SQL Ch 5 Project Part 2 due (new) Chapter 5, Part A
5 Tue 2/20 SQL, SQL, SQL Project Part 3 assigned
Thu 2/22 Quiz Hwk 1 due
6 Tue 2/27
Thu 3/1 SQL (cont.), class exercise SQL / RA exercise
7 Tue 3/6 SQL (cont.), class exercise Hwk 2 assigned
Thu 3/8 Still SQL... and now some SQL -to- PL API Chapter 5, Part B
8 Tue 3/13 JDBC, ODBC, HTML, PHP... and Normalization Ch 6 Chapter 6 slides
Thu 3/15 Project Part 3 due (old)
9 Tue 3/20 Project Part 3 due (new)
Thu 3/22 Midterm
10 Tue 3/27 Transactions and Concurrency Control Ch 9 Hwk 2 due
Project Part 4 assigned
Thu 3/29 Hwk 3 assigned Chapter 9 slides
11 Tue 4/3 School Holiday: Spring Break
Thu 4/5 School Holiday: Spring Break
12 Tue 4/10 Project Part 5 assigned
Thu 4/12 Project Part 4 due (old)
Project Part 6 assigned
13 Tue 4/17 Recovery - ARIES Project Part 4 due (new)
Thu 4/19 Quiz Hwk 3 due
14 Tue 4/24 Project Part 7 assigned
Hwk 4 assigned
Thu 4/26 Relational Query Optimization Ch 13 Chapter 13 slides
15 Tue 5/1
Thu 5/3 Query Optimization Project Part 5 due
16 Tue 5/8 Database Security Ch 8 Project Part 6 due Chapter 8 slides
Thu 5/10
17 Tue 5/15 B+-Tree Introduction, Course Wrap-Up Hwk 4 due B+-Tree slides
Wrap-Up slides
Thu 5/17 No class. First day of final exams. Project Part 7 due (5/18)
18 Tuesday 5/22 FINAL EXAM
Location: DBH 101
Time: 11:15 am - 1:15 pm