These notes are meant to
supplement any notes taken in class.
Some of the notes refer to chapters in earlier editions of the textbook.
Please defer to class discussion when discrepencies arise.
Chapter 1 - Database and Database Users
Chapter 2 - Database System Concepts and Architecture
Chapter 3 - Data Modeling Using the Entity-Relationship Model
Chapter 4 - Enhanced Entity-Relationship Model and UML Modeling
Chapters 5 and 6 - Relational Data Model, Relational Database Constraints, Relational Algebra
Chapter 7 - Relational Database Design by ER- and EER-to-Relational Mapping
Chapter 8 - SQL - Sample Queries
Chapter 10 - Functional Dependencies and Normalization for Relational Databases
Chapter 11 - Relational Database Design Algorithms and Further Dependencies
Chapter 13 - Disk Storage, Basic File Structures, and Hashing
Chapter 14 - Indexing Structures for Files
Chapter 15 - Query Processing and Optimization
Chapter 17-19 - Transactions Processing, Concurrency Control, Recovery
Chapters
20-22 - Object-Oriented Databases and Object-Relational Databases
Object-Oriented Databases
Object-Oriented Database Management Systems
Object Data Management Group
Object Data Language and Object Query Language
Chapter 26 - XML
Notes, and Examples
pdf
, ppt
PHP Tutorial and Examples
K. Ramamritham, Real-Time Databases , (invited paper) International Journal of Distributed and Parallel Databases 1 (1993), pp. 199-226, 1993.
J. R. Haritsa, and K. Ramamritham, Real-Time Databases in the New Millenium Real-Time Systems, 2000.
K. Ramamritham, S. Son, L. DiPippo, Real-Time Databases and Data Services, Real-Time Systems Journal, November - December 2004, Volume 28, Issue 2-3, pages 179-215.