Lecture Notes - Fall 2026#
Lecture 20 (B-trees)B-trees - Secondary Storage
Lecture 19 (Secondary Storage)Lecture 19: Hard disk - The Final Frontier
Lecture 18 (Procedural SQL - PLPGSQL)Lecture 18: Procedural SQL and Database Program Complexity
Lecture 17 (Access Control, Extended Group by, Procedural SQL)Lecture 17: Access Control and Procedural SQL
Lecture 16 (Triggers, Views and Recursion)Lecture 16: Triggers, Views, Access Control
Lecture 14 (Advanced SQL: subqueries)Lecture 14- Advanced SQL
Lecture 13 (SQL left join and scalar queries)Lecture 13 - Even more SQL
Lecture 12 (SQL set operations/count/group by/having)Lecture 12 - More on SQL
Lecture 11 (SQL Lecture 11 - SQL is here
Lecture 10 (ER Weak Entities, Ternary R., Hierarchies) Lecture 10 - Entity-Relationship Models
Lecture 8 (Entity-Relationship Models Lecture 8 - Entity-Relationship Models
Lecture 7 (3NF and BCNF Decompositions, Entity-Relationship Models Lecture 7 - BCNF & 3NF Decompositions AND ER Models
Lecture 6 (Minimal Functional Dependencies and Decompositions: lossless and dependency preserving) Lecture 6 - Normalization continued
Lecture 5 (Functional Dependencies, Closure, Keys, Normal Forms) Lecture 5 - Normalization
Lecture 4 (Relational Algebra and Normalization) Lecture 4 - Relational Algebra and Normalization
Lecture 3 (Relational Algebra) Lecture 3 - Relational Algebra
Lecture 2 (Relational Data Model and Algebra) CSCI 4380 Database Systems