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

国家开放大学：2008—2009学年第二学期“开放专科”计算机信息管理专业数据库基础与应用期末试题（7月）

国家开放大学：2008—2009学年第二学期“开放专科”电子商务专业数据库应用期末试题（7月）

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 4: SQL Background Basic Structure Set Operations Aggregate Functions Null Values Nested Subqueries Derived Relations Views Modification of the Database Joined Relations

国家开放大学：2007—2008学年第二学期“开放专科”计算机信息管理专业数据库基础与应用期末试题（7月）

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

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

国家开放大学：2006—2007学年第二学期“开放专科”计算机信息管理专业数据库基础与应用期末试题（7月）

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