Content-type: text/html cmsc424: Database Design

Online Classes Zoom link for all lectures.

Monday Wednesday
Jan 25
Introduction
(slides)

Jan 27Introduction 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 3Exam 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 15Spring Break Mar 17Spring 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 14Exam 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 10Exam 3

Web Accessibility