西安石油大学：《数据结构》精品课程资源_教学大纲

Chapter 4: SQL Background Basic Structure Set Operations Aggregate Functions Null Values Nested Subqueries Derived Relations Views Modification of the Database Joined Relations

Chapter 15: Transactions Transaction Concept Transaction State Implementation of Atomicity and Durability Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL

Chapter 7: Relational Database Design First Normal Form Pitfalls in Relational Database Design Functional Dependencies Decomposition Boyce-Codd Normal Form Third Normal Form Multivalued Dependencies and Fourth Normal Form

Chapter 3: Relational Model Structure of Relational Databases Relational Algebra Extended Relational-Algebra-Operations Modification of the Database Views Tuple Relational Calculus Domain Relational Calculus Database System Concepts

7.1 Transact-SQL程序设计 7.2 存储过程 7.3 触发器 7.4 备份和还原

关系模型的理论基础是集合论，是用集合代数定义一个关系。 定义1：域(Domain)是一组具有相同数据类型的值的集合。 定义2：设D1， D2，…， Dn为一组域， D1， D2， …，Dn上的笛卡尔积定义为：

Chapter 2: Entity-Relationship Model Basic Concepts Constraints Keys Design Issues E-R Diagram Weak Entity Sets Extended E-R Features Design of an E-R Database Schema Reduction of an E-R Schema to Tables

Chapter 1: Introduction Applications of Database Systems Database Systems versus File Systems View of Data Data Models Database Language Database Users and Administrator Transaction Management Database System Structure Application Architectures

湖南大学：《数据库原理及应用》课程教学资源（PPT课件讲稿）电子教案（目录）