Database Systems: Design, Implementation, & Management 14th Edition

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.

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