Database Systems: Design, Implementation, & Management. 14 Ed

Cover....1

 Dedication....5

 Brief Contents....6

 Contents....8

 About the Authors....15

 Preface....16

 Text Features....22

 Additional Features....24

 Acknowledgments....26

 Part 1: Database Concepts....30

 Chapter 1: Database Systems....31

 1-1 Why Databases?....32

 1-2 Data versus Information....33

 1-3 Introducing the Database....36

 1-4 Why Database Design Is Important....40

 1-5 Evolution of File System Data Processing....43

 1-6 Problems with File System Data Processing....46

 1-7 Database Systems....49

 1-8 Preparing for Your Database Professional Career....56

 Summary....57

 Key Terms....57

 Review Questions....58

 Problems....59

 Chapter 2: Data Models....61

 2-1 Data Modeling and Data Models....62

 2-2 The Importance of Data Models....63

 2-3 Data Model Basic Building Blocks....64

 2-4 Business Rules....65

 2-5 The Evolution of Data Models....67

 2-6 Degrees of Data Abstraction....80

 Summary....87

 Key Terms....88

 Review Questions....88

 Problems....89

 Part 2: Design Concepts....92

 Chapter 3: The Relational Database Model....93

 3-1 A Logical View of Data....95

 3-2 Keys....97

 3-3 Integrity Rules....101

 3-4 Relational Algebra....103

 3-5 The Data Dictionary and the System Catalog....112

 3-6 Relationships within the Relational Database....114

 3-7 Data Redundancy Revisited....122

 3-8 Indexes....124

 3-9 Codd's Relational Database Rules....126

 Summary....126

 Key Terms....127

 Review Questions....127

 Problems....130

 Chapter 4: Entity Relationship (ER) Modeling....136

 4-1 The Entity Relationship Model....137

 4-2 Developing an ER Diagram....162

 4-3 Database Design Challenges: Conflicting Goals....170

 Summary....174

 Key Terms....175

 Review Questions....175

 Problems....177

 Cases....183

 Chapter 5: Advanced Data Modeling....190

 5-1 The Extended Entity Relationship Model....191

 5-2 Entity Clustering....198

 5-3 Entity Integrity: Selecting Primary Keys....199

 5-4 Design Cases: Learning Flexible Database Design....203

 Summary....210

 Key Terms....210

 Review Questions....210

 Problems....211

 Cases....213

 Chapter 6: Normalization of Database Tables....220

 6-1 Database Tables and Normalization....221

 6-2 The Need for Normalization....222

 6-3 The Normalization Process....225

 6-4 Improving the Design....234

 6-5 Surrogate Key Considerations....238

 6-6 Higher-Level Normal Forms....240

 6-7 Normalization and Database Design....246

 6-8 Denormalization....250

 6-9 Data-Modeling Checklist....253

 Summary....255

 Key Terms....255

 Review Questions....256

 Problems....257

 Part 3: Advanced Design and Implementation....266

 Chapter 7: Introduction to Structured Query Language (SQL)....267

 7-1 SQL Basics....268

 7-2 Basic SELECT Queries....272

 7-3 SELECT Statement Options....273

 7-4 FROM Clause Options....279

 7-5 ORDER BY Clause Options....280

 7-6 WHERE Clause Options....282

 7-7 JOIN Operations....292

 7-8 Aggregate Processing....305

 7-9 Subqueries....314

 7-10 SQL Functions....324

 7-11 Relational Set Operators....332

 7-12 Crafting SELECT Queries....338

 Summary....340

 Key Terms....341

 Review Questions....342

 Problems....343

 Chapter 8: Advanced SQL....379

 8-1 Data Definition Commands....380

 8-2 Creating Table Structures....386

 8-3 Altering Table Structures....395

 8-4 Data Manipulation Commands....398

 8-5 Virtual Tables: Creating a View....406

 8-6 Auto Increment, Identity, and Sequences....409

 8-7 Procedural SQL....415

 8-8 Embedded SQL....440

 Summary....445

 Key Terms....446

 Review Questions....446

 Problems....446

 Cases....453

 Chapter 9: Database Design....459

 9-1 The Information System....460

 9-2 The Systems Development Life Cycle....462

 9-3 The Database Life Cycle....465

 9-4 Conceptual Design....476

 9-5 DBMS Software Selection....486

 9-6 Logical Design....487

 9-7 Physical Design....490

 9-8 Database Design Strategies....492

 9-9 Centralized versus Decentralized Design....493

 Summary....496

 Key Terms....496

 Review Questions....496

 Problems....497

 Part 4: Advanced Database Concepts....500

 Chapter 10: Transaction Management and Concurrency Control....501

 10-1 What Is a Transaction?....502

 10-2 Concurrency Control....509

 10-3 Concurrency Control with Locking Methods....514

 10-4 Concurrency Control with Time Stamping Methods....520

 10-5 Concurrency Control with Optimistic Methods....522

 10-6 ANSI Levels of Transaction Isolation....522

 10-7 Database Recovery Management....524

 Summary....529

 Key Terms....529

 Review Questions....530

 Problems....530

 Chapter 11: Database Performance Tuning and Query Optimization....534

 11-1 Database Performance-Tuning Concepts....535

 11-2 Query Processing....541

 11-3 Indexes and Query Optimization....544

 11-4 Optimizer Choices....546

 11-5 SQL Performance Tuning....549

 11-6 Query Formulation....552

 11-7 DBMS Performance Tuning....553

 11-8 Query Optimization Example....555

 Summary....561

 Key Terms....562

 Review Questions....562

 Problems....563

 Chapter 12: Distributed Database Management Systems....567

 12-1 The Evolution of Distributed Database Management Systems....568

 12-2 DDBMS Advantages and Disadvantages....570

 12-3 Distributed Processing and Distributed Databases....571

 12-4 Characteristics of Distributed Database Management Systems....573

 12-5 DDBMS Components....574

 12-6 Levels of Data and Process Distribution....575

 12-7 Distributed Database Transparency Features....578

 12-8 Distribution Transparency....579

 12-9 Transaction Transparency....581

 12-10 Performance and Failure Transparency....586

 12-11 Distributed Database Design....587

 12-12 The CAP Theorem....593

 12-13 C. J. Date's 12 Commandments for Distributed Databases....595

 Summary....596

 Key Terms....596

 Review Questions....597

 Problems....598

 Chapter 13: Business Intelligence and Data Warehouses....601

 13-1 The Need for Data Analysis....602

 13-2 Business Intelligence....602

 13-3 Decision Support Data....611

 13-4 The Data Warehouse....616

 13-5 Star Schemas....620

 13-6 Online Analytical Processing....630

 13-7 Data Analytics....638

 13-8 SQL Analytic Functions....642

 13-9 Data Visualization....649

 13-10 Data Lake....655

 Summary....656

 Key Terms....656

 Review Questions....657

 Problems....658

 Chapter 14: Big Data and NoSQL....668

 14-1 Big Data....669

 14-2 Hadoop....675

 14-3 NoSQL....682

 14-4 NewSQL Databases....690

 14-5 Working with Document Databases Using MongoDB....691

 14-6 Working with Graph Databases Using Neo4j....694

 Summary....698

 Key Terms....700

 Review Questions....701

 Part 5: Databases and the Internet....702

 Chapter 15: Database Connectivity and Web Technologies....703

 15-1 Database Connectivity....704

 15-2 Database Internet Connectivity....714

 15-3 Extensible Markup Language (XML)....724

 15-4 Cloud Computing Services....731

 Summary....738

 Key Terms....739

 Review Questions....740

 Problems....741

 Part 6: Database Administration....742

 Chapter 16: Database Administration and Security....743

 16-1 Data as a Corporate Asset....744

 16-2 The Need for a Database and Its Role in an Organization....746

 16-3 Introduction of a Database: Special Considerations....747

 16-4 The Evolution of Database Administration....749

 16-5 The Database Environment's Human Component....752

 16-6 Security....765

 16-7 Database Administration Tools....769

 16-8 Developing a Data Administration Strategy....774

 16-9 The DBA's Role in the Cloud....776

 16-10 The DBA at Work: Using Oracle for Database Administration....777

 Summary....785

 Key Terms....786

 Review Questions....786

 Glossary....788

 Index....803

Database skills are among the most in-demand IT skills. With its practical, accessible approach, Coronel/Morris' market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, & MANAGEMENT, 14th edition, equips you with a solid foundation in database design and implementation for today's market. The authors blend foundational theory, the latest real-world practices and the skills employers want. Straightforward writing and vivid illustrations make even complex concepts easy to understand. You'll learn the key to successful database implementation as you study how to properly design databases that fit within the larger strategic data environment. Expanded coverage includes big data analytics, NoSQL and data visualization technologies. In addition, the MindTap digital platform gives you real-world, hands-on practice to help you prepare for a successful career in database design and management.