Class Activities

Week 12 : 7/31-8/3
Exams Final Exam - on-line (8/1-8/3)
Final Exam - on campus (8/3) - CSB110 from 1pm to 7pm
Week 11 : 7/24-7/30
Lectures Chapter 16: Recovery
Worksheet - Chapter 16a
Reading Chapter 16 (Silberschatz)
Chapter #16 Quiz (Canvas) - (due 7/30)
Homeworks HW #5 - Concurrency and Recovery (due 7/30)
Week 10 : 7/17-7/23
Lectures Chapter 14: Transactions
Chapter 15: Concurrency
Worksheet - Chapter 14a
Worksheet - Chapter 15a
Worksheet - Chapter 15b
Reading Chapter 14 & 15 (Silberschatz)
Chapter #14 Quiz (Canvas) - (due 7/23)
Chapter #15 Quiz (Canvas) - (due 7/23)
Labs Lab Assignment #5- JDBC and a GUI (due 7/23)
Week 9 : 7/10-7/16
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 7/16
Labs Lab Assignment #4- XML and JDBC (due 7/16)
Week 8 : 7/3-7/9
Lectures Chapter 11: Indexing
Worksheet - Chapter 11a
Worksheet - Chapter 11b
Reading Chapter 11 (Silberschatz)
Chapter #11 Quiz (Canvas) - due 7/9
Homeworks HW #4 - Indexing (due 7/9)
Week 7 : 6/26-7/2
Lectures Chapter 10: Storage
Worksheet - Chapter 10a
Worksheet - Chapter 10b
Reading Chapter 10 (Silberschatz)
Chapter #10 Quiz (Canvas) - due 7/2
Labs Lab Assignment #3- Creating a Larger Database (due 7/2)
Week 6 : 6/19-6/25
Exams Midterm Exam - online (6/21-6/23)
Midterm Exam - on Campus (6/23 - 1-7pm in the CS110 lab)
Lectures Chapter 5.1-5.3: JDBC / Triggers
Reading Chapter #5.1-5.3 (Silberschatz)
Labs Lab Assignment #2 - Building a Database - due 6/25
Week 5 : 6/12-6/18
Lectures Chapter 8.1-8.4: Database Design
Worksheet - Chapter 8a
Reading Chapter #8.1-8.4 (Silberschatz)
Chapter #8 Quiz (Canvas) - due 6/19
Homeworks HW #3 (due 6/19)
Exams Midterm Exam (6/21-23)
Week 4 : 6/5-6/11
Lectures Chapter 7: E/R model
Worksheet - Chapter 7a
Worksheet - Chapter 7b
Reading Chapter #7 (Silberschatz)
Chapter #7 Quiz (Canvas) - due 6/12
Homeworks HW #2 (due 6/12)
Week 3 : 5/29-6/4
Lectures Chapter 4: Intermediate SQL
Worksheet - Chapter 4a
Worksheet - Chapter 4b
Reading Chapter #4 (Silberschatz)
Chapter #4 Quiz (Canvas) - due 6/4
Labs Lab Assignment #1b - Intro to Queries - due 6/4
Week 2 : 5/22-5/28
Lectures Chapter 3: Introduction to SQL
Worksheet - Chapter 3a
Worksheet - Chapter 3b
Reading Chapter #3 (Silberschatz)
Chapter #3 Quiz (Canvas) - due 5/28
Labs Lab Assignment #1a - Intro to MySQL - due 5/28
Week 1 : 5/15-5/21
Lectures Introduction to CS430/CS430dl
Chapter 1: Introduction
Chapter 2: Introduction to the Relational Model
Worksheet - Chapter 1a
Worksheet - Chapter 2a
Reading Chapters 1 & 2 (Silberschatz)
Chapter #1 Quiz (Canvas) - due 5/21
Chapter #2 Quiz (Canvas) - due 5/21
Homeworks HW #1 (due 5/21)