Database Systems: Design, Implementation, & Management, 14e

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. Cover Dedication Brief Contents Contents About the Authors 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 Blocks 2-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 Entity Relationship Model 4-2 Developing an ER Diagram 4-3 Database Design Challenges: Conflicting Goals Summary Key Terms Review Questions Problems Cases Chapter 5: Advanced Data Modeling 5-1 The Extended Entity Relationship Model 5-2 Entity Clustering 5-3 Entity Integrity: Selecting Primary Keys 5-4 Design Cases: Learning Flexible Database Design Summary Key Terms Review Questions Problems Cases Chapter 6: Normalization of Database Tables 6-1 Database Tables and Normalization 6-2 The Need for Normalization 6-3 The Normalization Process 6-4 Improving the Design 6-5 Surrogate Key Considerations 6-6 Higher-Level Normal Forms 6-7 Normalization and Database Design 6-8 Denormalization 6-9 Data-Modeling Checklist Summary Key Terms Review Questions Problems Part 3: Advanced Design and Implementation Chapter 7: Introduction to Structured Query Language (SQL) 7-1 SQL Basics 7-2 Basic SELECT Queries 7-3 SELECT Statement Options 7-4 FROM Clause Options 7-5 ORDER BY Clause Options 7-6 WHERE Clause Options 7-7 JOIN Operations 7-8 Aggregate Processing 7-9 Subqueries 7-10 SQL Functions 7-11 Relational Set Operators 7-12 Crafting SELECT Queries Summary Key Terms Review Questions Problems Chapter 8: Advanced SQL 8-1 Data Definition Commands 8-2 Creating Table Structures 8-3 Altering Table Structures 8-4 Data Manipulation Commands 8-5 Virtual Tables: Creating a View 8-6 Auto Increment, Identity, and Sequences 8-7 Procedural SQL 8-8 Embedded SQL Summary Key Terms Review Questions Problems Cases Chapter 9: Database Design 9-1 The Information System 9-2 The Systems Development Life Cycle 9-3 The Database Life Cycle 9-4 Conceptual Design 9-5 DBMS Software Selection 9-6 Logical Design 9-7 Physical Design 9-8 Database Design Strategies 9-9 Centralized versus Decentralized Design Summary Key Terms Review Questions Problems Part 4: Advanced Database Concepts Chapter 10: Transaction Management and Concurrency Control 10-1 What Is a Transaction? 10-2 Concurrency Control 10-3 Concurrency Control with Locking Methods 10-4 Concurrency Control with Time Stamping Methods 10-5 Concurrency Control with Optimistic Methods 10-6 ANSI Levels of Transaction Isolation 10-7 Database Recovery Management Summary Key Terms Review Questions Problems Chapter 11: Database Performance Tuning and Query Optimization 11-1 Database Performance-Tuning Concepts 11-2 Query Processing 11-3 Indexes and Query Optimization 11-4 Optimizer Choices 11-5 SQL Performance Tuning 11-6 Query Formulation 11-7 DBMS Performance Tuning 11-8 Query Optimization Example Summary Key Terms Review Questions Problems Chapter 12: Distributed Database Management Systems 12-1 The Evolution of Distributed Database Management Systems 12-2 DDBMS Advantages and Disadvantages 12-3 Distributed Processing and Distributed Databases 12-4 Characteristics of Distributed Database Management Systems 12-5 DDBMS Components 12-6 Levels of Data and Process Distribution 12-7 Distributed Database Transparency Features 12-8 Distribution Transparency 12-9 Transaction Transparency 12-10 Performance and Failure Transparency 12-11 Distributed Database Design 12-12 The CAP Theorem 12-13 C. J. Date's 12 Commandments for Distributed Databases Summary Key Terms Review Questions Problems Chapter 13: Business Intelligence and Data Warehouses 13-1 The Need for Data Analysis 13-2 Business Intelligence 13-3 Decision Support Data 13-4 The Data Warehouse 13-5 Star Schemas 13-6 Online Analytical Processing 13-7 Data Analytics 13-8 SQL Analytic Functions 13-9 Data Visualization 13-10 Data Lake Summary Key Terms Review Questions Problems Chapter 14: Big Data and NoSQL 14-1 Big Data 14-2 Hadoop 14-3 NoSQL 14-4 NewSQL Databases 14-5 Working with Document Databases Using MongoDB 14-6 Working with Graph Databases Using Neo4j Summary Key Terms Review Questions Part 5: Databases and the Internet Chapter 15: Database Connectivity and Web Technologies 15-1 Database Connectivity 15-2 Database Internet Connectivity 15-3 Extensible Markup Language (XML) 15-4 Cloud Computing Services Summary Key Terms Review Questions Problems Part 6: Database Administration Chapter 16: Database Administration and Security 16-1 Data as a Corporate Asset 16-2 The Need for a Database and Its Role in an Organization 16-3 Introduction of a Database: Special Considerations 16-4 The Evolution of Database Administration 16-5 The Database Environment's Human Component 16-6 Security 16-7 Database Administration Tools 16-8 Developing a Data Administration Strategy 16-9 The DBA's Role in the Cloud 16-10 The DBA at Work: Using Oracle for Database Administration Summary Key Terms Review Questions Glossary Index