Content-type: text/html
Online Classes Zoom link for all lectures.
Monday | Wednesday | ||
---|---|---|---|
Introduction (slides)
|
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)
|
||
Modeling and Querying SQL Read chapter 4 for Quiz 2 due at noon (slides) |
Modeling and Querying More SQL, Relational Algebra (slides) |
||
Modeling and Querying Relational Algebra Quiz 3 due at noon (slides) |
Modeling and Querying E-R Diagrams (slides) |
||
Modeling and Querying E-R Diagrams, reduction (slides) |
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) |
||
Modeling and Querying FDs, BCNF normal form, Normalization Chapters 7,8 for Quiz 5 due Wednesday at noon(long, start early) (slides) |
Functional Dependencies Chapters 7,8 for Quiz 5 due at noon (slides) (Example midterms: mid1s17.pdf, mid1f17.pdf, midf19.pdf) |
||
Functional Dependencies (slides) |
Exam 1 | ||
Storage / Implementation / Optimization Query Processing Quiz 6 due at noon (slides) |
Storage / Implementation / Optimization Query processing (slides) |
||
Spring Break | Spring Break | ||
Storage / Implementation / Optimization Indexes, B+trees Quiz 7 due at noon (slides) |
Storage / Implementation / Optimization Query processing (updated slides folded into slides in last class) |
||
Storage / Implementation / Optimization Query processing (slides) |
Storage / Implementation / Optimization Query optimization (slides) |
||
Storage / Implementation / Optimization Query optimization Quiz 8 due at noon (slides) |
Storage / Implementation / Optimization Query optimization (slides) |
||
Isolation and Serializability (slides) |
Exam 2 | ||
Isolation and Serializability Quiz 9 due at noon (slides) |
Isolation and Serializability (slides) |
||
Isolation and Serializability Quiz 10 due at noon |
Isolation and Serializability Assign 10 due Friday, midnight Late deadline for Quiz 10 |
||
Isolation and Serializability Quiz 11 due at noon |
Isolation and Serializability Distributed Systems Assign 11 due Friday, midnight Late deadline for Quiz 11 |
||
The End Exam 3 |