Database Systems: Design, Implementation & Management

"Provide a balanced approach to databases as the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, and MANAGEMENT, 13E emphasizes the knowledge and skills necessary for success and makes databases accessible without overwhelming students. Readers gain a solid foundation in database design and implementation as diagrams, illustrations, and tables clarify in-depth coverage of database design. Students learn how successful database implementation involves designing databases to fit within a larger strategic data environment. Revised coverage of SQL introduces more examples and simpler explanations that focus on areas most important for a database career -- making supplementary SQL materials unnecessary. Additional coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, offers a strong hands-on approach. MindTap℗® now include a digital auto-graded MySQL environment.". -- Publisher.

9-9 Centralized versus Decentralized Design.

Cover; Dedication; Brief Contents; Contents; Preface; Text Features; Additional Features; Acknowledgments; Part 1: Database Concepts; Chapter 1: Database Systems; 1-1 Why Databases; 1-2 Data versus Information; 1-3 Introducing the Database; 1-4 Why Database Design Is Important; 1-5 Evolution of File System Data Processing; 1-6 Problems with File System Data Processing; 1-7 Database Systems; 1-8 Preparing for Your Database Professional Career; Summary; Key Terms; Review Questions; Problems; Chapter 2: Data Models; 2-1 Data Modeling and Data Models; 2-2 The Importance of Data Models.

2-3 Data Model Basic Building Blocks2-4 Business Rules; 2-5 The Evolution of Data Models; 2-6 Degrees of Data Abstraction; Summary; Key Terms; Review Questions; Problems; Part 2: Design Concepts; Chapter 3: The Relational Database Model; 3-1 A Logical View of Data; 3-2 Keys; 3-3 Integrity Rules; 3-4 Relational Algebra; 3-5 The Data Dictionary and the System Catalog; 3-6 Relationships within the Relational Database; 3-7 Data Redundancy Revisited; 3-8 Indexes; 3-9 Codd's Relational Database Rules; Summary; Key Terms; Review Questions; Problems; Chapter 4: Entity Relationship (ER) Modeling.

4-1 The Entit…