Database Systems (CSC270) — Lecture Slides¶
Presentation-style slide decks for the CSC270 lectures, one slide per PDF page — use full-screen view in your PDF reader for a proper presentation, or print them for offline study.
- Lecture 1: Introduction to Databases and Information Systems
- Lecture 2: The Database Approach
- Lecture 3: Database Languages and Functions
- Lecture 4: Database Architecture and Data Independence
- Lecture 5: The Relational Model
- Lecture 6: Integrity Constraints
- Lecture 7: Relational Algebra: Unary and Set Operations
- Lecture 8: Join and Division Operations
- Lecture 9: Aggregation and Grouping
- Lecture 10: Relational Calculus
- Lecture 11: Data Modeling and Database Design
- Lecture 12: The Entity-Relationship Model
- Lecture 13: ER Modeling: Issues and Problems
- Lecture 14: The Enhanced ER Model
- Lecture 15: EER Modeling: A Case Study
- Lecture 16: Mapping EER Models to Relational Schemas
- Lecture 17: Midterm Review
- Lecture 18: Normalization: Purpose and Concepts
- Lecture 19: The Normalization Process: 1NF, 2NF, 3NF
- Lecture 20: Advanced Normalization: Functional Dependencies and BCNF
- Lecture 21: BCNF Schema Design by Decomposition
- Lecture 22: Multi-Valued Dependencies and Fourth Normal Form
- Lecture 23: Views and Materialized Views
- Lecture 24: Database Authorization
- Lecture 25: Indexing
- Lecture 26: Introduction to NoSQL Databases
- Lecture 27: MongoDB and the Document Model
- Lecture 28: MongoDB Sharding and Replication
- Lecture 29: Database Transactions and ACID Properties
- Lecture 30: Transaction Management: Concurrency Control
- Lecture 31: Failure and Recovery in Transaction Management
- Lecture 32: Course Review