数据库处理

Preface xvii

PART 1 GETTING STARTED

Chapter 1：Introduction

Chapter Objectives

The Characteristics of Databases

A Note on Naming Conventions

A Database Has Data and Relationships

Databases Create Information

Database Examples

Single-User Database Applications

Multiuser Database Applications

E-Commerce Database Applications

Reporting and Data Mining Database Applications

The Components of a Database System

Database Applications and SQL

The DBMS

The Database

Personal Versus Enterprise-Class Database Systems

What Is Microsoft Access?

What Is an Enterprise-Class Database System?

Database Design

Database Design from Existing Data

Database Design for New Systems Development

Database Redesign

What You Need to Learn

A Brief History of Database Processing

The Early Years

The Emergence and Dominance of the Relational Model

Post-Relational Developments

Summary

Key Terms

Review Questions

Project Questions

Chapter 2：Introduction to Structured Query Language

Chapter Objectives

Cape Codd Outdoor Sports

The Retail Sales Data Extraction

RETAIL_ORDER Data

ORDER ITEM Data

SKU_DATA Table

Data Extracts Are Common

SQL Background

The SQL SELECT/FROM/WHERE Framework

Reading Specified Columns from a Single Table

Reading Specified Rows from a Single Table

Reading Specified Columns and Rows from a Single Table

Submitting SQL Statements to the DBMS

Using SQL in Microsoft Access 2007

Using SQL in Microsoft SQL Server 2008

Using SQL in Oracle Database 11g

Using SQL in Sun Microsystems MySQL 5.1

SQL Enhancements for Querying a Single Table

Sorting the Results

SQL WHERE Clause Options

Combing the SQL WHERE Clause and the SQL ORDER BY Clause

Performing Calculations in SQL Queries

Using SQL Built-in Functions

SQL Expressions in SQL SELECT Statements

Grouping in SQL SELECT Statements

Looking for Patterns in NASDAQ Trading

Investigating the Characteristics of the Data

Searching for Patterns in Trading by Day of Week

Querying Two or More Tables with SQL

Querying Multiple Tables with Subqueries

Querying Multiple Tables with Joins

Comparing Subqueries and Joins

Summary

Key Terms

Review Questions

Project Questions

Marcias Dry Cleaning

Morgan Importing

PART 2 DATABASE DESIGN

Chapter 3：The Eelational Model and Normalization

Chapter Objectives

Relational Model Terminology

Relations

Characteristics of Relations

Alternative Terminology

Functional Dependencies

Finding Functional Dependencies

Keys

Normal Forms

Modification Anomalies

A Short History of Normal Forms

Normalization Categories

From First Normal Form to Boyce-Codd Normal Form

Eliminating Anomalies from Functional Dependencies

Eliminating Anomalies from Multivalued Dependencies

Fifth Normal Form

Domain/Key Normal Form

Summary

Key Terms

Review Questions

Project Questions

Marcias Dry Cleaning

Morgan Importing

Chapter 4：Database Design Using Normalization

Chapter Objectives

Assess Table Structure

Designing Updatable Databases

Advantages and Disadvantages of Normalization

Functional Dependencies

Normalizing with

Choosing Not to Use BCNF

Multivalued Dependencies

Designing Read-Only Databases

Denormalization

Customized Duplicated Tables

Common Design Problems

The Multivalue， Multicolumn Problem

Inconsistent Values

Missing Values

The General-Purpose Remarks Column

Summary

Key Terms

Review Questions

Project Questions

Marcias Dry Cleaning

Morgan Importing

Chapter 5：Data Modeling with the Entity-Relationship Model

Chapter Objectives

The Purpose of a Data Model

The Entity-Relationship Model

Entities

Attributes

Identifiers

Relationships

Maximum Cardinality

Minimum Cardinality

Entity-Relationship Diagrams and Their Versions

Variations of the E-R Model

E-R Diagrams Using the IE Crows Foot Model

Strong Entities and Weak Entities

ID-Dependent Entities

Non-ID-Dependent Weak Entities

Subtype Entities

Patterns in Forms， Reports， and E-R Models

Strong Entity Patterns

ID-Dependent Relationships

Mixed Identifying and Nonidentifying Patterns

The For-Use-By Pattern

Recursive Patterns

The Data Modeling Process

The College Report

The Department Report

The Department/Major Report

The Student Acceptance Letter

Summary

Key Terms

Review Questions

Project Questions

Marcias Dry Cleaning

Morgan Importing

Chapter 6：Transforming Data Models into Database Designs

Chapter Objectives

Create a Table for Each Entity

Selecting the Primary Key

Specifying Candidate （Alternate） Keys

Specify Column Properties

Verify Normalization

Create Relationships

Relationships Between Strong Entities

Relationships Using ID-Dependent Entities

Relationships with a Weak Non-ID-Dependent Entiy

Relationships in Mixed Entity Designs

Relationships Between Supertype and Subtype Entities

Recursive Relationships

Representing Ternary and Higher-Order Relationships

Relational Representation of the Highline University Data Model

Design for Minimum Cardinality

Actions When the Parent Is Required

Actions When the Child Is Required

Implementing Actions for M-O Relationships

Implementing Actions for O-M Relationships

Implementing Actions for M-M Relationships

Designing Special Case M-M Relationships

Documenting the Minimum Cardinality Design

An Additional Complication

Summary of Minimum Cardinality Design

The View Ridge Gallery Database

Summary of Requirements

The View Ridge Data Model

Database Design with Data Keys

Minimum Cardinality Enforcement for Required Parents

Minimum Cardinality Enforcement for the Required Child

Column Properties for the View Ridge Database Design Tables

Summary

Key Terms

Review Questions

Project Questions

Marcias Dry Cleaning

Morgan Importing

PART 3 DATABASE IMPLEMENTATION

Chapter 7：SQL for Database Construction and Application Processing

Chapter Objectives

The View Ridge Gallery Database

SQL DDL， DML， and a New Type of Join

……

PART 4 MULTIUSER DATABASE PROCESSING

PART 5 DATABASE ACCESS STANDARDS

APPENDICES

Bibliography

Glossary

Index

《数据库处理：基础、设计与实现（第11版）（英文版）》从基础、设计和实现三个层面介绍数据库处理技术，内容全面翔实，既包括数据库设计、数据库实现、多用户数据处理、数据访问标准等经典理论，也包括商务智能、XML和NET等最新技术。《数据库处理：基础、设计与实现（第11版）（英文版）》在内容编排和写作风格上新颖，强调学习过程中的乐趣，围绕两个贯穿全书的项目练习，让读者从一开始就能把所学的知识用于解决具体的应用实例。
《数据库处理：基础、设计与实现（第11版）（英文版）》每章都有丰富的习题，可作为高校本科生或研究生的数据库课程的双语教材，同时也是一本很好的专业参考书。

提前介绍了SQL查询
使用“螺旋方法”进行数据库设计
为数据建模和数据库设计使用了一种通用的信息工程“鸦脚”E-R模型
详细探讨了实际规范技术中的特定范式
使用了最新的DBMS技术：Microsoft Access 2007，Microsoft SQL．Setver 2008，Oracle Database 11g，MySQI 5．1
基于广泛使用的Web开发技术，创建了Web数据库应用
简介了商务智能系统
探讨了数据仓库和联机分析处理数据库设计中使用的维数据库概念