CSCI 470 - Database
Management Systems – Fall 2008
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 |