Table of Contents
Chapter 1: The Database Environment
Database Hardware Architecture
Other Factors in the Database Environment
Chapter 2: Systems Analysis and Database Requirements
Dealing with Resistance to Change
The Structured Design Life Cycle
Conducting the Needs Assessment
Evaluating and Choosing an Alternative
Part II: Relational database design theory
Chapter 3: Why Good Design Matters
Effects of Poor Database Design
Unnecessary Duplicated Data and Data Consistency
Chapter 4: Entities and Relationships
Dealing with Many-to-Many Relationships
Relationships and Business Rules
Data Modeling Versus Data Flow
Chapter 5: The Relational Data Model
Representing Data Relationships
The Relational Algebra and SQL Example Database: Rare Books
Making Vertical Subsets: Project
Making Horizontal Subsets: Restrict
Choosing Columns and Rows: Restrict and Then Project
Translating an ER Diagram into Relations
Chapter 8: Database Design and Performance Tuning
Chapter 9: Codd’s Rules for Relational DBMSs
Rule 2: The Guaranteed Access Rule
Rule 3: Systematic Treatment of Null Values
Rule 4: Dynamic Online Catalog Based on the Relational Model
Rule 5: The Comprehensive Data Sublanguage Rule
Rule 6: The View Updating Rule
Rule 7: High-Level Insert, Update, Delete
Rule 8: Physical Data Independence
Rule 9: Logical Data Independence
Rule 10: Integrity Independence
Rule 11: Distribution Independence
Part III: Relational database design practice
Chapter 10: Introduction to SQL
Chapter 11: Using SQL to Implement a Relational Design
Chapter 12: Using CASE Tools for Database Design
Sample Input and Output Designs
Chapter 13: Database Design Case Study #1: Mighty-Mite Motors
Chapter 14: Database Design Case Study #2: East Coast Aquarium
Chapter 15: Database Design Case Study #3: SmartMart
Part IV: Using interactive SQL to manipulate a relational database
Chapter 16: Simple SQL Retrieval
Nulls and Retrieval: Three-Valued Logic
Chapter 17: Retrieving Data from More Than One Table
Finding Multiple Rows in One Table: Joining a Table to Itself
Avoiding Joins with Uncorrelated Subqueries
Chapter 18: Advanced Retrieval Operations
The EXCEPT and INTERSECT Operators
Chapter 19: Working With Groups of Rows
Windowing and Window Functions
Inserting, Updating, or Deleting on a Condition: MERGE
Chapter 21: Creating Additional Structural Elements
Common Table Expressions (CTEs)
Part V: Database implementation issues
Chapter 22: Concurrency Control
Solution #2: Optimistic Concurrency Control (Optimistic Locking)
Solution #3: Multiversion Concurrency Control (Timestamping)
Web Database Concurrency Control Issues
Sources of External Security Threats
The Bottom Line: How Much Security Do You Need?
Scope and Purpose of a Data Warehouse
Obtaining and Preparing the Data
Data Modeling for the Data Warehouse
Recognizing and Handling Incomplete Data
Recognizing and Handling Incorrect Data
Recognizing and Handling Incomprehensible Data
Recognizing and Handling Inconsistent Data
Part VI: Beyond the relational data model
Chapter 27: Object-Relational Databases
Getting Started: Object-Orientation without Computing
Benefits of Object-Orientation
Limitations of Pure Object-Oriented DBMSs
The Object-Relational Data Model
SQL Support for the OR Data Model
SQL Data Types for Object-Relational Support
User-Defined Data Types and Typed Tables
Chapter 28: Relational Databases and “Big Data”: The Alternative of a NoSQL Solution
Other Differences Between NoSQL Databases and Relational Databases
Appendix A: Historical Antecedents