西北农林科技大学：《数据库原理与应用》课程教学资源（授课教案）第3讲 数据模型

Agenda SQL Server Overview SQL Server Architecture Storage and Access Methods Query Processing and Optimization Transaction Processing Other Topics

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

西北农林科技大学：《数据库原理与应用》课程教学大纲 Database Principles and Applications（负责人：李书琴）

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

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

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