A Practical Approach to Design, Implementation and Management
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases--conceptual, logical, and physical database design. The Fifth Edition brings Web and legal issues to the fore in two new chapters, Database Architectures and the Web and Professional, Legal, and Ethical Issues. Students are exposed not only to the foundational theory of databases but also to the most recent developments in the field. This book is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With comprehensive coverage, this book can also be used as a reference for IT professionals.
I. Background 1. Introduction to Databases 2. Database Environment 3. Database Architectures and the Web II. The Relational Model and Languages 4. The Relational model 5. Relational Algebra and Relational Calculus 6. SQL: Data Manipulation 7. SQL: Data Definition 8. Query-By-Example (QBE) III. Database Analysis and Design 9. Database System Lifecycle 10. Database Analysis and the DreamHome Case Study 11. Entity--Relationship Modeling 12. Enhanced Entity--Relationship Modeling 13. Normalization 14. Advanced Normalization IV. Methodology 15. Methodology--Conceptual Database Design 16. Methodology--Logical Database Design for Relational Model 17. Methodology--Physical Database Design for Relational Databases 18. Methodology--Monitoring and Tuning the Operational System V. Selected Database Issues 19. Security and Administration 20. Professional, Legal, and Ethical Issues 21. Transaction Management 22. Query Processing VI. Distributed DBMSs and Replication 23. Distributed DBMSs--Concepts and Design 24. Distributed DBMSs--Advanced Concepts 25. Replication and Mobile Databases VII. Object DBMSs 26. Object-Oriented DBMSs--Concepts and Design 27. Object-Oriented DBMSs--Standards and Languages 28. Object-Relational DBMSs VIII. Web and DBMSs 29. Web Technology and DBMSs 30. Semistructured Data and XML IX. Business Intelligence Technologies 31. Data Warehousing Concepts 32. Data Warehousing Design 33. OLAP 34. Data Mining Appendices A. Users' Requirements Specification for DreamHome Case Study B. Other Case Studies C. Alternative Data Modeling Notations D. Summary of the Database Design Methodology for Relational Databases E. Introduction to Pyrrho--A Liteweight RDBMS Web Appendices F. File Organization and Storage Structures G. When Is a DBMS Relational? H. Commercial DBMSs: Access and Oracle I. Programmatic SQL J. Estimating Disk Space Requirements K. Introduction to Object-Orientation L. Example Web Scripts