Database Systems : A Practical Approach to Design, Implementation and Management: United States Edition
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.
- Paperback | 1400 pages
- 190.5 x 228.6 x 48.26mm | 1,769g
- 27 Feb 2009
- Pearson Education (US)
- Boston, MA, United States
- 5th edition
About Thomas Connolly
Thomas M. Connolly is the head of the Computing and Information Systems division at the University of Paisley.Carolyn E. Begg is a lecturer at the University of Paisley, with research interests in Information Systems, Database Management Systems, and Decision Support Systems within medicine.
Table of contents
I. Background1. Introduction to Databases2. Database Environment3. Database Architectures and the WebII. The Relational Model and Languages4. The Relational model5. Relational Algebra and Relational Calculus6. SQL: Data Manipulation7. SQL: Data Definition8. Query-By-Example (QBE)III. Database Analysis and Design9. Database System Lifecycle10. Database Analysis and the DreamHome Case Study11. Entity-Relationship Modeling12. Enhanced Entity-Relationship Modeling13. Normalization14. Advanced NormalizationIV. Methodology15. Methodology-Conceptual Database Design16. Methodology-Logical Database Design for Relational Model17. Methodology-Physical Database Design for Relational Databases18. Methodology-Monitoring and Tuning the Operational SystemV. Selected Database Issues19. Security and Administration20. Professional, Legal, and Ethical Issues21. Transaction Management22. Query ProcessingVI. Distributed DBMSs and Replication23. Distributed DBMSs-Concepts and Design24. Distributed DBMSs-Advanced Concepts25. Replication and Mobile DatabasesVII. Object DBMSs26. Object-Oriented DBMSs-Concepts and Design27. Object-Oriented DBMSs-Standards and Languages28. Object-Relational DBMSsVIII. Web and DBMSs29. Web Technology and DBMSs30. Semistructured Data and XMLIX. Business Intelligence Technologies31. Data Warehousing Concepts32. Data Warehousing Design33. OLAP34. Data MiningAppendicesA. Users' Requirements Specification for DreamHome Case StudyB. Other Case StudiesC. Alternative Data Modeling NotationsD. Summary of the Database Design Methodology for Relational DatabasesE. Introduction to Pyrrho-A Liteweight RDBMSWeb AppendicesF. File Organization and Storage StructuresG. When Is a DBMS Relational?H. Commercial DBMSs: Access and OracleI. Programmatic SQLJ. Estimating Disk Space RequirementsK. Introduction to Object-OrientationL. Example Web Scripts