Content-type: text/html cmsc424: Database Design

Online Classes Zoom link for all lectures.

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 3Exam 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 15Spring Break Mar 17Spring 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 14Exam 2
Apr 19
Isolation and Serializability

Quiz 9 due at noon

(slides)

Apr 21
Isolation and Serializability

Assign 9 due Friday, midnight

(slides)

Apr 26Isolation 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

Web Accessibility