CINS
370 - Database Management Systems – Fall 2010
Reading
Assignments and Related Course Notes
|
Reading Assignment |
Topic from Fundamentals of Database Management Systems, Sixth Edition |
Online notes from 6th Edition |
Online Notes from 5th Edition & Dr. Stapleton’s Notes |
Homework Solutions – Theses are now from 6th Edition!!!! |
|
Week 1 |
Chapter 1 - Databases and Database Users |
|||
|
Week 1 |
Chapter 2 - Database System Concepts and Architecture |
|||
|
Week 2 |
Chapter 7 - Data Modeling Using the Entity-Relationship Model |
|||
|
Week 3 |
Chapter 8 - Enhanced Entity-Relationship and UML Modeling |
|||
|
Week 3-4 |
Chapter 9 - Database Design by ER and EER to Relational Mapping |
|||
|
Week 4-5 |
Chapter 10 - Practical Database Design Methodology and Use of UML Diagrams |
|
||
|
Week 5-6 |
Chapter 3 - The Relational Data Model and Relational Database Constraints |
|||
|
Week 6-7 |
Chapter 4 – Basic SQL |
|||
|
Week 7-8 |
Chapter 5 - More SQL: Complex Queries, Triggers, Views, and Schema Modification |
|||
|
Week 8-9 |
Chapter 6 - The Relational Algebra and Relational Calculus |
|||
|
Week 9-10 |
Chapter 15 - Functional Dependencies and Normalization for Relational Databases |
|
||
|
Week 11 |
Chapter 21 - Introduction to Transaction Processing Concepts and Theory |
|
||
|
Week 13 |
Chapter 22 - Concurrency Control Techniques |
|
||
|
Week 14-15 |
Chapter 23 - Database Recovery Techniques |
|