CINS
370 - Database Management Systems – Fall 2009
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 |
||
|
Week 1 |
Chapter 2 - Database System Concepts and Architecture |
||
|
Week 1 |
Chapter 3 - Data Modeling Using the Entity-Relationship Model |
||
|
Week 2 |
Chapter 4 - Enhanced Entity-Relationship and UML Modeling |
||
|
Week 3-4 |
Chapter 5 - The Relational Data Model and Relational Database Constraints |
||
|
Week 4-5 |
Chapter 6 - The Relational Algebra and Relational Calculus |
||
|
Week 5-6 |
Chapter 7 - Database Design by ER and EER to Relational Mapping |
||
|
Week 6-7 |
Chapter 8 - SQL-99: Schema Definition, Basic Constraints, and Queries |
||
|
Week 7-8 |
Chapter 9 - More SQL: Assertions, Views, and Programming Techniques |
||
|
Week 9-10 |
Chapter 10 - Functional Dependencies and Normalization for Relational Databases |
||
|
Week 10-11 |
Chapter 12 - Practical Database Design Methodology and Use of UML Diagrams |
||
|
Week 12 |
Chapter 17 - Introduction to Transaction Processing Concepts and Theory |
||
|
Week 13 |
Chapter 18 - Concurrency Control Techniques |
Notes on Concurreny Control Techniques Newer, more complete Chapter 18 Powerpoints - recently submitted by the authors |
|
|
Week 14-15 |
Chapter 19 - Database Recovery Techniques |
Notes on Database Recovery Techniques Newer, more complete Chapter 19 Powerpoints - recently submitted by the authors |