CS 4250, Spring 2024   Class Schedule, Lecture Notes

Note: Schedule will change please check regularly.

WK Class/Date Topic Book Chapter Homeworks Lecture Notes
1 Fri 1/26 Introduction Ch 1 Intro slides
2 Mon 1/29 Database Planning and the Entity-Relationship Model Ch 2, 3 Project Part 1 assigned Chs. 2, 3 slides
Wed 1/31
Fri 2/2
3 Mon 2/5 Project Part 1 due
Project Part 2 assigned
Wed 2/7 Relational Model : EER to Relational Ch 4 Chapter 4 slides
Fri 2/9
4 Mon 2/12 Part 2 Review 1 deadline
Hwk 1 assigned
Wed 2/14 Relational Model : Relational Algebra
Fri 2/16
5 Mon 2/19 SQL, SQL, SQL Part 2 Review 2 deadline Chapter 5 slides, Part A
Wed 2/21 Project Part 2 due
Fri 2/23 Quiz
6 Mon 2/26 Hwk 1 due
Wed 2/28 more SQL, SQL, SQL...
Fri 3/1 Project Part 3 assigned
7 Mon 3/4 a SQL class exercise Chapter 5 slides, Part B
Wed 3/6 and now some SQL -to- PL API
Fri 3/8
8 Mon 3/11 Database Normalization Ch 6 Chapter 6 slides
Wed 3/13 Hwk 2 assigned
Fri 3/15
9 Mon 3/18 Transactions and Concurrency Control -- the secret sauce for scale-up Ch 9 (3rd ed), Ch 11 (4th ed) Chapter 9 slides
Wed 3/20 (Slide from today's midterm discussion) Project Part 3 due (old)
Project Part 4 assigned
Fri 3/22 Midterm
10 Mon 3/25 Hwk 2 due
Wed 3/27
Fri 3/29 Project Part 3 due (new new)
11 Mon 4/1 School Holiday: Spring Break
Wed 4/3 School Holiday: Spring Break
Fri 4/5 School Holiday: Spring Break
12 Mon 4/8
Wed 4/10 Project Part 4 due (original deadline)
Hwk 3 assigned
Fri 4/12 Project Part 4 due (new deadline)
13 Mon 4/15
Wed 4/17
Fri 4/19 Quiz
14 Mon 4/22
Wed 4/24 Hwk 3 due
Fri 4/26 Class cancelled due to professor business meeting. Work on your project!
15 Mon 4/29
Wed 5/1
Fri 5/3
16 Mon 5/6
Wed 5/8
Fri 5/10 Warrior Day. No class.
17 Mon 5/13
Wed 5/15 Course Wrap-Up
Fri 5/17 Reading Day
18 Wednesday 5/22 FINAL EXAM
Location: DBH 165
Time: 2:00 pm - 4:00 pm