cmsc424: Database Design

Monday		Wednesday
Jan 25	Introduction (slides)	Jan 27	Introduction Continued Read chapters 1 (skim), 2, 3.1-3.7 for Quiz 1, due by Friday Midnight Assignment 1 should be completed by Friday Midnight. (slides)
Feb 1	Modeling and Querying SQL Read chapter 4 for Quiz 2 due at noon (slides)	Feb 3	Modeling and Querying More SQL, Relational Algebra (slides) Assignment 2 due Friday, midnight
Feb 8	Modeling and Querying Relational Algebra Quiz 3 due at noon (slides)	Feb 10	Modeling and Querying E-R Diagrams Assign 3 due Friday, midnight (slides)
Feb 15	Modeling and Querying E-R Diagrams, reduction (slides)	Feb 17	Modeling and Querying FDs, BCNF normal form, Normalization Chapter 5 for Quiz 4 due at noon (note different day just for this week) Assign 4 due Saturday, midnight (slides)
Feb 22	Modeling and Querying FDs, BCNF normal form, Normalization Chapters 7,8 for Quiz 5 due Wednesday at noon(long, start early) (slides)	Feb 24	Functional Dependencies Chapters 7,8 for Quiz 5 due at noon Assign 5 due Friday, midnight (slides) (Example midterms: mid1s17.pdf, mid1f17.pdf, midf19.pdf)
Mar 1	Functional Dependencies (slides)	Mar 3	Exam 1 Exam on Gradescope
Mar 8	Storage / Implementation / Optimization Query Processing Quiz 6 due at noon (slides)	Mar 10	Storage / Implementation / Optimization Query processing Assign 6 due Friday, midnight (slides)
Mar 15	Spring Break	Mar 17	Spring Break
Mar 22	Storage / Implementation / Optimization Indexes, B+trees Quiz 7 due at noon (slides)	Mar 24	Storage / Implementation / Optimization Query processing Assign 7 due Friday, midnight (updated slides folded into slides in last class)
Mar 29	Storage / Implementation / Optimization Query processing (slides)	Mar 31	Storage / Implementation / Optimization Query optimization (slides)
Apr 5	Storage / Implementation / Optimization Query optimization Quiz 8 due at noon (slides)	Apr 7	Storage / Implementation / Optimization Query optimization Assign 8 due Friday, midnight (slides)
Apr 12	Isolation and Serializability (slides)	Apr 14	Exam 2
Apr 19	Isolation and Serializability Quiz 9 due at noon (slides)	Apr 21	Isolation and Serializability Assign 9 due Friday, midnight (slides)
Apr 26	Isolation and Serializability Quiz 10 due at noon	Apr 28	Isolation and Serializability Assign 10 due Friday, midnight Late deadline for Quiz 10
May 3	Isolation and Serializability Quiz 11 due at noon	May 5	Isolation and Serializability Distributed Systems Assign 11 due Friday, midnight Late deadline for Quiz 11
May 10	The End (examples from prior final) Exam 3