Class Activities

Week 15 : 4/30-5/6
Exams Final Exam
Week 14 : 4/23-4/29
Lectures Chapter 16: Recovery
Worksheet - Chapter 16a
Reading Chapter 16 (Silberschatz)
Chapter #16 Quiz (Canvas) - (due 4/29)
Homeworks HW #5 - Concurrency and Recovery (due 4/29 - No late period)
Week 13 : 4/16-4/22
Lectures Chapter 15: Concurrency
Worksheet - Chapter 15a
Worksheet - Chapter 15b
Reading Chapter 15 (Silberschatz)
Chapter #15 Quiz (Canvas) - (due 4/22)
Labs Lab Assignment #5- JDBC and a GUI (due 4/22)
Week 12 : 4/9-4/15
Lectures Chapter 14: Transactions
Worksheet - Chapter 14a
Reading Chapter 14 (Silberschatz)
Chapter #14 Quiz (Canvas) - (due 4/15)
Week 11 : 4/2-4/8
Lectures Chapter 6.1: Relational Algebra
Chapter 12: Query Processing
Worksheet - Chapter 12a
Reading Chapters 6.1 / 12 (Silberschatz)
Chapter #6/12 Quiz (Canvas) - due 4/8
Labs Lab Assignment #4- XML and JDBC (due 4/8)
Week 10 : 3/26-4/1
Lectures Chapter 11: Indexing
Worksheet - Chapter 11a
Worksheet - Chapter 11b
Reading Chapter 11 (Silberschatz)
Chapter #11 Quiz (Canvas) - due 4/1
Homeworks HW #4 - Indexing (due 4/1)
Week 9 : 3/19-3/25
Lectures Chapter 10: Storage
Worksheet - Chapter 10a
Worksheet - Chapter 10b
Reading Chapter 10 (Silberschatz)
Chapter #10 Quiz (Canvas) - due 3/25
Labs Lab Assignment #3- Creating a Larger Database (due 3/25)
Spring Break : 3/12-3/18
Vacation
Week 8 : 3/5-3/11
Lectures Chapter 5.1-5.3: JDBC / Triggers
Reading Chapter #5.1-5.3 (Silberschatz)
Labs Lab Assignment #2 - Building a Database - due 3/11
Week 7 : 2/26-3/4
Exams Midterm Exam
Week 6 : 2/19-2/25
Lectures Chapter 8.1-8.4: Database Design
Worksheet - Chapter 8a
Reading Chapter #8.1-8.4 (Silberschatz)
Chapter #8 Quiz (Canvas) - due 2/25
Homeworks HW #3 (due 2/25 - No late period)
Week 5 : 2/12-2/18
Lectures Chapter 7: E/R model
Worksheet - Chapter 7a
Worksheet - Chapter 7b
Reading Chapter #7 (Silberschatz)
Chapter #7 Quiz (Canvas) - due 2/18
Homeworks HW #2 (due 2/18)
Week 4 : 2/5-2/11
Lectures Chapter 4: Intermediate SQL
Worksheet - Chapter 4a
Worksheet - Chapter 4b
Reading Chapter #4 (Silberschatz)
Chapter #4 Quiz (Canvas) - due 2/11
Labs Lab Assignment #1b - Intro to Queries - due 2/11
Week 3 : 1/29-2/4
Lectures Chapter 3: Introduction to SQL
Worksheet - Chapter 3a
Worksheet - Chapter 3b
Reading Chapter #3 (Silberschatz)
Chapter #3 Quiz (Canvas) - due 2/4
Labs Lab Assignment #1a - Intro to MySQL - due 2/4
Week 2 : 1/22-1/28
Lectures Chapter 2: Introduction to the Relational Model
Worksheet - Chapter 2a
Reading Chapter 2 (Silberschatz)
Chapter #1 Quiz (Canvas) - due 1/28
Chapter #2 Quiz (Canvas) - due 1/28
Homeworks HW #1 (due 1/28)
Week 1 : 1/16-1/21
Lectures Introduction to CS430/CS430dl
Chapter 1: Introduction
Worksheet - Chapter 1a
Reading Chapter 1 (Silberschatz)
Chapter #1 Quiz (Canvas) - due 1/21