cmsc424: Database Design

Tuesday		Thursday
Aug 27	Introduction (slides)	Aug 29	Relational Algebra (slides)
Sep 3	SQL (slides) Homework 1 due Tuesday midnight	Sep 5	SQL (slides) Assignment 0 (not graded)
Sep 10	Modeling and Querying (slides) Read Chapter 2, 3, 4 for Homework 2 due Monday midnight	Sep 12	Modeling and Querying (slides) Assignment 1a due Friday midnight
Sep 17	Modeling and Querying (slides) Read Chapter 2.6, 3, 4 for Homework 3 due Monday midnight	Sep 19	Modeling and Querying (slides) Assignment 1b due Friday midnight
Sep 24	Functional Dependencies (slides) Read Chapter 5.1 - 5.4, 6.1-6.7, 6.9 for Homework 4 due Monday midnight	Sep 26	Normalization (slides) Assignment 2 due Friday midnight
Oct 1	Normalization (slides) Read Chapter 7.1-7.5 for Homework 5 due Monday midnight	Oct 3	Normalization (slides) Assignment 3 due Friday midnight
Oct 8	Spark (slides) No new reading for Homework 6 due Monday midnight	Oct 10	Exam 1
Oct 15	Storage / Implementation / Optimization (slides)	Oct 17	Storage (slides) Assignment 4 due Friday midnight
Oct 22	Storage / Implementation / Optimization (slides) Read Chapters 13-1-13.3, 14.1-14.3 for Homework 7 due Monday midnight	Oct 24	Storage / Implementation / Optimization (slides)
Oct 29	Storage / Implementation / Optimization (slides)	Oct 31	Storage / Implementation / Optimization (slides) Assignment 5 due Friday midnight
Nov 5	Storage / Implementation / Optimization (slides) Read Chapter 15 for Homework 8 due Monday midnight	Nov 7	Isolation and Serializability (ch 17+18) (slides)
Nov 12	Exam review (slides) Read Chapter 15, 16.1-16.3 for Homework 9 due Monday midnight	Nov 14	Exam 2
Nov 19	Isolation and Serializability (ch 17+18) zoom: Transactional Discussion (video lecture, slides) Read Chapter 17.1-17.7 for Homework 10 due Wednesday midnight	Nov 21	Isolation and Serializability (ch 17+18) zoom: Transactional Discussion (video lecture, slides)
Nov 26	Recovery Read Chapters 17.8-17.9, 18.1-18.1.3, 18.2.1-18.3, 18.5-18.6, 18.8 for Homework 11 due Wednesday midnight Assignment 6 due tonight	Nov 28	Thanksgiving
Dec 3	Distributed Systems Homework 12 due Wednesday midnight (Ch 19)	Dec 5	Distributed Systems Assignment 7 due Friday midnight