Comp 305-001/405-001: Database Administration

Spring 2024: MWF

Week 12


Normalization

Lots example, and the revision that can be put into 3NF but not BCNF

Denormalization; Reddit has two tables

Wednesday

Transactions

Friday

Start with Recoverable and Nonrecoverable Transactions

SQL Isolation rules

Postgres MVCC