November 20, 2023

Monday of Week 14

Topics of the day

Entity-relationship models
Database design principles
Database security
Database constraints
Database correctness (ACID)
Distributing databases

| Reading | Online | Assignments | Photos |

Suggested readings

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

Online references

Database constraints (en.wikipedia.org)
E-R model (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

Homework 8 - practice due (27 Nov)
Homework 7 revision (27 Nov)
Exam 2 out (29 Nov)
Convex Hull lab (29 Nov)
Exam 2 due (04 Dec)

Board photos

.

.