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.
Feb 1	Modeling and Querying SQL Quiz 2 due at noon	Feb 3	Modeling and Querying More SQL, Relational Algebra Assign 2 due Friday, midnight
Feb 8	Modeling and Querying Relational Algebra Quiz 3 due at noon	Feb 10	Modeling and Querying E-R Diagrams Assign 3 due Friday, midnight
Feb 15	Modeling and Querying E-R Diagrams, reduction Quiz 4 due at noon	Feb 17	Modeling and Querying FDs, BCNF normal form, Normalization Assign 4 due Friday, midnight
Feb 22	Modeling and Querying FDs, BCNF normal form, Normalization Quiz 5 due at noon	Feb 24	Storage and Queries Storage Assign 5 due Friday, midnight
Mar 1	Storage and Queries Indexing	Mar 3	Exam 1
Mar 8	Storage and Queries Indexing Quiz 6 due at noon	Mar 10	Storage and Queries Query processing Assign 6 due Friday, midnight
Mar 15	Spring Break	Mar 17	Spring Break
Mar 22	Storage and Queries Query processing Quiz 7 due at noon	Mar 24	Storage and Queries Query optimization Assign 7 due Friday, midnight
Mar 29	Storage and Queries Query optimization / Transactions Quiz 8 due at noon	Mar 31	Isolation and Serializability Transactions Assign 8 due Friday, midnight
Apr 5	Isolation and Serializability Concurrency	Apr 7	Isolation and Serializability Isolation and Recovery Quiz 9 due at noon
Apr 12	Isolation and Serializability Recovery Assign 9 due Friday, midnight	Apr 14	Exam 2
Apr 19	Isolation and Serializability Security Quiz 10 due at noon	Apr 21	The Broader Field Differential Privacy Assign 10 due Friday, midnight
Apr 26	The Broader Field Cloud Intro Quiz 11 due at noon	Apr 28	The Broader Field Potpourri Assign 11 due Friday, midnight
May 3	The Broader Field Distributed Systems Quiz 12 due at noon	May 5	The Broader Field Review
May 10	Exam 3