CS580 Spring 2006

Class notes

Chapter 1 -Databases and Database Users

Chapter 2 - Database Systems Concepts and Architecture

Chapter 3 - Data Modeling Using E-R Model

Chapter 4 - Enhanced E-R Model EER

Chapter 4 - UML versus EER Modeling

Chapter7  - Conversion E-R and EER into Relations

Chapter 5   - Relational Data Model, Relational Constraints and Relational Algebra Operators (Inherited from Set Theory)

Chapter 6- Relational algebra Operations

Chapter 8 - SQL 3

Chapter 8 - SQL 3 Part two

Chapter 8 -SQL 3 Part three

Chapter 8 - SQL 3 Part four

Chapter 9 - Tuple Relational Calculus

Chapter 14- Functional Dependencies and Normalization

Chapter 19 - Transaction Processing

Chapter 19 - Transaction Processing Part Two

Chapter 20 - Concurrency Control Techniques