Database Systems: Design, Implementation, and Management, 10th Edition

Practical and easy to understand, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, Tenth Edition, gives readers a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, the tenth edition has been thoroughly updated to include hot topics such as green computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-database connectivity and code security. In addition, new review questions, problem sets, and cases have been added throughout the book so that readers have multiple opportunities to test their understanding and develop real and useful design skills.

Table of Contents

PART I: DATABASE CONCEPTS
Chapter 1: Database Systems
Chapter 2: Data Models

PART II: DESIGN CONCEPTS
Chapter 3: The Relational Database Model
Chapter 4: Entity Relationship (ER) Modeling
Chapter 5: Advanced Data Modeling
Chapter 6: Normalization of Database Tables

PART III: ADVANCED DESIGN AND IMPLEMENTATION
Chapter 7: Introduction to Structured Query Language (SQL)
Chapter 8: Advanced SQL
Chapter 9: Database Design

PART IV: ADVANCED DATABASE CONCEPTS
Chapter 10: Transaction Management and Concurrency Control
Chapter 11: Database Performance Tuning and Query Optimization
Chapter 12: Distributed Database Management Systems
Chapter 13: Business Intelligence and Data Warehouses

PART V: DATABASES AND THE INTERNET
Chapter 14: Database Connectivity and Web Technologies

PART VI: DATABASE ADMINISTRATION
Chapter 15: Database Administration and Security

APPENDIX A: DESIGNING DATABASES WITH VISIO PROFESSIONAL: A TUTORIAL
APPENDIX B: THE UNIVERSITY LAB: CONCEPTUAL DESIGN
APPENDIX C: THE UNIVERSITY LAB: CONCEPTUAL DESIGN VERIFICATION, LOGICAL DESIGN, AND IMPLEMENTATION
APPENDIX D: CONVERTING AN ER MODEL INTO A DATABASE STRUCTURE
APPENDIX E: COMPARISON OF ER MODEL NOTATIONS
APPENDIX F: CLIENT/SERVER SYSTEMS
APPENDIX G: OBJECT-ORIENTED DATABASES
APPENDIX H: UNIFIED MODELING LANGUAGE (UML)
APPENDIX I: DATABASES IN ELECTRONIC COMMERCE
APPENDIX J: WEB DATABASE DEVELOPMENT WITH COLDFUSION
APPENDIX K: THE HIERARCHICAL DATABASE MODEL
APPENDIX L: THE NETWORK DATABASE MODEL
APPENDIX M: MICROSOFT® ACCESS® TUTORIAL
APPENDIX N: CREATING A NEW DATABASE USING ORACLE 11G
APPENDIX O: DATA WAREHOUSE IMPLEMENTATION FACTORS