SQL Server数据库完整性教学案例探析

Discussion of Teaching Cases about SQL Server Database Integrity

数据库完整性约束条件是数据模型三要素之一,与数据结构和数据操作一起抽象表示现实世界的数据和信息,数据库完整性是数据库课程的重要组成部分。针对目前高校普遍开设的基于SQL Server数据库课程,分析了数据库完整性约束的重要性,给出了一个包含实体完整性、参照完整性和用户自定义完整性的案例,探索数据库教学方法,为提升数据库能力奠定了基础。

The constraints of database integrity is one of the three elements of data model,and together with data structure and manipulation,an abstract representation of the data and information in the real world.The integrity of database is one of the important part of courses about database.For the SQL Server Database courses commonly offered in colleges,the paper analyzes the importance of the constraint of database integrity,offers a case including the entity integrity,referential integrity and user-defined Integrity,and explores into the teaching methods of database to cement the base for improving database capacity.