Database systems : a practical approach to design, implementation, and management
Thomas M. Connolly, Carolyn E. Begg
- 6th global ed.
- Boston : Pearson Education Limited, c2015.
- 1329 p. (various paging) : ill., ; 23 cm.
- Always learning. .
Previous edition: 2010.
Part 1: Background 1. Introduction to databases 2. Database environment 3. Database architectures and the web Part 2: The Relation Model and Languages 4. The relational model 5. Relational algebra and relational calculus 6. SQL: Data manipulation 7. SQL: Data definition 8. Advanced SQL 9. Object-relational DBMSs Part 3: Database Analysis and Design 10. Database system development lifecycle 11. Database analysis and the 'DreamHome' case study 12. Entity-relationship modeling 13. Enhanced entity-relationship modeling 14. Normalization 15. Advanced normalization Part 4: Methodology 16. Methodology: Conceptual database design 17. Methodology: Logical database design for the relational model 18. Methodology: Physical database design for relational databases 19. Methodology: Monitoring and tuning the operational system Part 5: Selected Database Issues 20. Security and administration 21. Professional, legal, and ethical issues in data management 22. Transaction management 23. Query processing Part 6: Distributed DBMSs and Replication 24. Distributed DBMSs: Concepts and design 25. Distributed DBMSs: Advanced concepts 26. Replication and mobile databases Part 7: Object DBMSs 27. Object-oriented DBMSs: Concepts and design 28. Object-oriented DBMSs: Standards and systems Part 8: The Web and DBMSs 29. Web technology and DBMSs 30. Semistructured data and XML Part 9: Business Intelligence 31. Data warehousing concepts 32. Data warehousing design 33. OLAP 34. Data mining Appendices.
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 its comprehensive coverage, this book can also be used as a reference for IT professionals. This 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. Teaching and Learning Experience This program presents a better teaching and learning experience-for you and your students. It provides: Database Design Methodology that can be Used by Both Technical and Non-technical Readers ; A Comprehensive Introduction to the Theory behind Databases ; A Clear Presentation that Supports Learning.