November 24, 2025

Monday of Week 14

Topics of the day

Database design principles
Database security
Database constraints
Database correctness (ACID)
Distributing databases

| Reading | Online | Assignments |

Suggested readings

Sections 5.2, 8.2, 12.2, 17.3, 23.1, 23.2 from Ramez Elmasri and Shamkant Navathe, Fundamentals of database systems, 4e
Sections 3.2, 4.2, 10.2, 21.3, 24.1, 24.2 from Ramez Elmasri and Shamkant Navathe, Fundamentals of database systems, 6e
Sections 7.1, 7.2, 1.2.4 from Jeffrey Ullman and Jennifer Widom, A first course in database systems, 2e

Online references

Database constraints (en.wikipedia.org)
Database transaction (en.wikipedia.org)
ACID (en.wikipedia.org)
Shard (en.wikipedia.org)
No SQL (en.wikipedia.org)
Database security (en.wikipedia.org)
"Exploits of a Mom" (Little Bobby Tables) (www.xkcd.com)

Assignments

Upcoming

Project 4: Database due (01 Dec)
Homework 7 revision (01 Dec)
Exam 2 out (03 Dec)
Convex Hull lab (03 Dec)
Exam 2 (08 Dec)
Project 4: Database followup (08 Dec)