Table of Contents Chapter 1: Introduction Part 1: Relational Databases Chapter 2: Introduction to the Relational Model Chapter 3: Introduction to SQL Chapter 4: Intermediate SQL Chapter 5: Advanced SQL Chapter 6: Formal Relational Query Languages Part II: Database Design Chapter 7: Database Design and the E-R Model Chapter 8: Relational Database Design Chapter 9: Application Design and Development Part III: Data Storage and Querying Chapter 10: Storage and File Structure Chapter 11: Indexing and Hashing Chapter 12: Query Processing Chapter 13: Query Optimization Part IV: Transaction Management Chapter 14: Transactions Chapter 15: Concurrency Control Chapter 16: Recovery System Part V: System Architecture Chapter 17: Database-System Architectures Chapter 18: Parallel Databases Chapter 19: Distributed Databases Part VI: Data Mining and Information Retrieval Chapter 20: Data Mining Chapter 21: Information Retrieval Part VII: Specialty Databases Chapter 22: Object-Based Databases Chapter 23: XML Chapter 24: Advanced Application Development Chapter 25: Advanced Data Types and New Applications Chapter 26: Advanced Transaction Processing Part IX: Case Studies Chapter 27: PostgreSQL Chapter 28: Oracle Chapter 29: IBM DB2 Universal Database Chapter 30: Microsoft SQL Server Part X: Appendices Appendix A: Detailed University Schema Appendix B: Other Relational Query Languages Appendix C: Advanced Relational Database Design Appendix D: Network Model Appendix E: Hierarchical Model