西北农林科技大学：《数据库原理与应用》课程教学实验指导书（SQL SERVER 2008）

4.1关系系统 一、关系系统的定义 二、关系系统的分类 三、全关系系统12条准则

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

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 15: Transactions Transaction Concept Transaction State Implementation of Atomicity and Durability Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL

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 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

存在问题 (1)数据冗余太大 (2)插入异常 (3)删除异常 (4)更新异常

11.1屏幕生成器 11.2菜单生成器