学习要点 1、候选键、替代键和外来键 2、完全函数依赖、部分函数依赖、传递函数依赖 3、1NF、2NF和3NF 4、关系模式的分解

7.1程序设计基础 7.2程序的控制结构 7.3程序模块 7.4程序的调试 7.5一个结构化程序设计的实例

5.1表的建立 5.2表的显示与维护 5.3表的排序与索引 5.4表的统计与计算 5.5多个表的操作

广东海洋大学：电子工程系《数据库原理及应用》课程教学大纲

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

《数据库管理及应用》课程电子教案（PPT课件）3.02 SQL Introduction & DDL SQL 查询语言入门和 DDL）（SQL：结构化查询语言，DDL：数据定义语言

《数据库管理及应用》课程电子教案（PPT课件）5.03 Execution and Recovery of Update Transaction 更新事务的执行与恢复