This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice.
Table of contents
Chapter 1. Introduction to Databases
Chapter 2. Database Environment
Chapter 3. The Relational Model
Chapter 4. Relational Algebra and Relational Calculus
Chapter 5. SQL: Data Manipulation
Chapter 6. SQL: Data Definition
Chapter 7. Query-By-Example
Chapter 8. Commercial RDBMSs: Office Access and Oracle
Chapter 9. Database Planning, Design, and Administration
Chapter 10. Fact-Finding Techniques
Chapter 11. Entity–Relationship Modeling
Chapter 12. Enhanced Entity–Relationship Modeling
Chapter 13. Normalization
Chapter 14. Advanced Normalization
Chapter 15. Methodology – Conceptual Database Design
Chapter 16. Methodology – Logical Database Design for Relational Model
Chapter 17. Methodology – Physical Database Design for Relational Databases
Chapter 18. Methodology – Monitoring and Tuning the Operational System
Chapter 19. Security
Chapter 20. Transaction Management
Chapter 21. Query Processing
Chapter 22. Distributed DBMSs – Concepts and Design
Chapter 23. Distributed DBMSs – Advanced Concepts
Chapter 24. Replication and Mobile Databases
Chapter 25. Introduction to Object DBMSs
Chapter 26. Object-Oriented DBMSs – Concepts
Chapter 27. Object-Oriented DBMSs – Standards and Systems
Chapter 28. Object-Relational DBMSs
Chapter 29. Web Technology and DBMSs
Chapter 30. Semistructured Data and XML
Chapter 31. Data Warehousing Concepts
Chapter 32. Data Warehousing Design
Chapter 33. OLAP
Chapter 34. Data Mining
