CSCI 273 - Database Management System - Spring 2004
Reading Assignments and Related Course Notes
| Reading Assignment | Topic from Fundamentals of Database Management Systems, Fourth Edition | Online Notes | Homework Solutions |
| Week 1 | Chapter 1 - Databases and Database Users | Chapter 1 and 2 notes | |
| Week 1 | Chapter 2 - Database System Concepts and Architecture | Chapter 1 and 2 notes | |
| Week 1 | Chapter 3 - Data Modeling Using the Entity-Relationship Model | Chapter 3 notes | Chapter 3 solutions |
| Week 2 | Chapter 4 - Enhanced Entity-Relationship and UML Modeling | Chapter 4 notes | Chapter 4 solutions |
| Week 3-4 | Chapter 5 - The Relational Data Model and Relational Database Constraints | Chapter 5 powerpoints | Chapter 5 solutions |
| Week 4-5 | Chapter 6 - The Relational Algebra and Relational Calculus | Chapter 6 powerpoints | Chapter 6 solutions |
| Week 5-6 | Chapter 7 - Database Design by ER and EER to Relational Mapping | Chapter 7 powerpoints | Chapter 7 solutions |
| Week 6-7 | Chapter 8 - SQL-99: Schema Definition, Basic Constraints, and Queries | Chapter 8 powerpoints | Chapter 8 solutions |
| Week 7-8 | Chapter 9 - More SQL: Assertions, Views, and Programming Techniques | Chapter 9 powerpoints | |
| Week 9-10 | Chapter 10 - Functional Dependencies and Normalization for Relational Databases | Chapter 10 powerpoints | Chapter 10 solutions |
| Week 10-11 | Chapter 12 - Practical Database Design Methodology and Use of UML Diagrams | Chapter 12 powerpoints | |
| Week 12 | Chapter 17 - Introduction to Transaction Processing Concepts and Theory | Notes on Transactions | Chapter 17 solutions |
| Week 13 | Chapter 18 - Concurrency Control Techniques | Notes on Concurreny Control Techniques | Chapter 18 solutions |
| Week 14-15 | Chapter 19 - Database Recovery Techniques | Notes on Database Recovery Techniques | Chapter 19 solutions |