Design Process Modeling Constraints E-R Diagram Design Issues Weak Entity Sets Extended E-R Features Design of the Bank Database Reduction to Relation Schemas Database Design UML

Relational Algebra Tuple Relational Calculus Domain Relational Calculus

Accessing SQL From a Programming Language Functions and Procedural Constructs Triggers Recursive Queries Advanced Aggregation Features OLAP

Join Expressions Views Transactions Integrity Constraints SQL Data Types and Schemas Authorization

Overview of The SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database

《数据库系统概念 Database System Concepts》原书教学资源（第六版，PPT课件讲稿，英文版）Chapter 2 Introduction to the Relational Model

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

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

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

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