November 24, 2025
Monday of Week 14
Topics of the day
- Database design principles
- Database security
- Database constraints
- Database correctness (ACID)
- Distributing databases
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 th out (03 Dec)
- Convex Hull lab in class (03 Dec)
- Exam 2 (08 Dec)
- Project 4: Database followup (08 Dec)
