数据库系统概念

Chapter 1 Introduction

1.1 Database-System Applications

1.2 Purpose of Data base Systems

1.3 View of Data

1.4 Database Languages

1.5 Relational Databases

1.6 Database Design

1.7 Data Storage and Querying

1.8 Transaction Management

1.9 Database Architecture

1.10 Data Mining and Information Retrieval

1.11 Specialty Databases

1.12 Database Users and Administrators

1.13 History of Database Systems

1.14 Summary

Review Terms

Practice Exercises

Exercises

Tools

Bibliographical Notes

PART ONE RELATIONAL DATABASES

Chapter 2 Introduction to the Relational Model

2.1 Structure of Relational Databases

2.2 Database Schema

2.3 Keys

2.4 Schema Diagrams

2.5 Relational Query Languages

2.6 Relational Operations

2.7 Summary

Review Terms

Practice Exercises

Exercises

Bibliographical Notes

Chapter3 Introduction to SQL

3.1 Overview of the SQL Query Language

3.2 SQL Data Definition 3.3 Basic Structure of SQL Queries

3.4 Additional Basic Operations

3.5 Set Operations

3.6 Null Values

3.7 Aggregate Functions

3.8 Nested Subqueries

3.9 Modification of the Database

3.10 Summary

Review Terms

Practice Exercises

Exercises

Tools

Bibliographical Notes

Chapter 4 Intermediate SQL

4.1 Join Expressions

4.2 Views

4.3 Transactions

4.4 Integrity Constraints

4.5 SQL Data Types and Schemas

4.6 Authorization

4.7 Summary

Review Terms

Practice Exercises

Exercises

Bibliographical Notes

Chapter 5 Advanced SQL

5.1 Accessing SQL From a Programming Language

5.2 Functions and Procedures

5.3 Triggers

5.4 Recursive Queries

5.5 Advanced Aggregation Features

5.6 OLAP

5.7 Summary

Review Terms

Practice Exercises

Exercises

Tools

Bibliographical Notes

Chapter 6 Formal Relational Query Languages

6.1 The Relational Algebra

6.2 The Tuple Relational Calculus

6.3 The Domain Relational Calculus

6.4 Summary

Review Terms

Practice Exercises

Exercises

Bibliographical Notes

PART TWO DATABASE DESIGN

Chapter 7 Database Design and the E-R Model

7.1 Overview of the Design Process

7.2 The Entity-Relationship Model

7.3 Constraints 269

7.4 Removing Redundant Attributes in Entity Sets

7.5 Entity-Relationship Diagrams

7.6 Reduction to Relational Schemas

7.7 Entity-Relationship Design Issues

7.8 Extended E-R Features

7.9 Alternative Notations for Modeling Data

7.10 0ther Aspects of Database Design

7.11 Summary

Review Terms

Practice Exercises

Exercises

Tools

Bibliographical Notes

Chapter 8 Relational Database Design

8.1 Features of Good Relational Designs

8.2 Atomic Domains and First Normal Form

8.3 Decomposition Using Functional Dependencies

8.4 Functional-Dependency Theory

8.5 Algorithms for Decomposition

8.6 Decomposition Using Multivalued Dependencies

8.7 More Normal Forms

8.8 Database-Design Process

8.9 Modeling Temporal Data

8.10 Summary

Review Terms

Practice Exercises

Exercises

Bibliographical Notes

PART THREE DATA STORAGE , QUERYING, AND TRANSACTION MANAGEMENT

PART FOUR ADVANCED TOPICS

Bibliography

《经典原版书库：数据库系统概念（英文精编版·第6版）》内容由浅入深，既包含数据库系统基本概念，又反映数据库技术新进展。它被国际上许多著名大学所采用，包括斯坦福大学、耶鲁大学、得克萨斯大学、康奈尔大学、伊利诺伊大学等。我国也有多所大学采用《经典原版书库：数据库系统概念（英文精编版·第6版）》作为本科生和研究生数据库课程的教材和主要教学参考书，收到了良好的效果。《经典原版书库：数据库系统概念（英文精编版·第6版）》基于该书第6版进行改编，保留其中的基本内容，压缩或删除了一些高级内容，更加适合作为国内高校计算机及相关专业本科生数据库课程教材。