《数据库系统概念 Database System Concepts》原书教学资源（第六版，附录，英文版）Advanced Relational Database Design

Centralized and Client-Server Systems Server System Architectures Parallel Systems Distributed Systems Network Types

SQL in a Programming Environment embedded SQL persistent stored modules Database-Connection Libraries Call-level interface (CLI) JDBC PHP

1．数据 数据(Data)实际上是描述事物的符号记录。 2．数据库 数据库（Database）是数据的集合，以统一的结构形式存放于统一的存储介质内，可被各个应用程序所共享。 3．数据库管理系统 数据库管理系统(Database Management System，简称DBMS)是负责数据库中的数据组织、数据操纵、数据维护、控制及保护和数据服务等功能的一种系统软件

Data Definition Basic Query Structure Set Operations Aggregate Functions Null Values Nested Subqueries Complex Queries Views Modification of the Database Joined Relations**

3.1 Introduction 3.2 Setting Up the Database 3.3 Queries 3.4 View 3.5 Data manipulation 3.6 Security

▪ Reasoning with MVDs ▪ Higher normal forms • Join dependencies and PJNF • DKNF

Structure of Relational Databases Fundamental Relational-Algebra-Operations Additional Relational-Algebra-Operations Extended Relational-Algebra-Operations Null Values Modification of the Database

▪ Features of Good Relational Design ▪ Functional Dependencies ▪ Decomposition Using Functional Dependencies ▪ Normal Forms ▪ Functional Dependency Theory ▪ Algorithms for Decomposition using Functional Dependencies ▪ Decomposition Using Multivalued Dependencies ▪ More Normal Form ▪ Atomic Domains and First Normal Form ▪ Database-Design Process ▪ Modeling Temporal Data

《数据库系统概念 Database System Concepts》原书教学资源（第七版，PPT课件讲稿，英文版）Chapter 06 Database Design Using the E-R Model