摘要
数据完整性约束是保证数据一致性和正确性的一种有效机制,其包括域(列)完整性、实体(行)完整性、参照(表间)完整性。相比较而言,参照完整性比较复杂,初学者往往不易掌握。笔者旨在剖析参照完整性的基本语法、作用机制和实际运用,帮助数据库初学者理解和掌握数据库中参照完整性的应用方法及注意事项,为教师教学和学生学习提供参考。
Data integrity constraint is an effective mechanism to ensure data consistency and correctness,including domain(column)integrity,entity(row)integrity,and reference(inter-table)integrity.Comparatively speaking,referential integrity is more complex,and beginners are often not easy to master.The purpose of this paper is to analyze the basic grammar,function mechanism and practical application of reference integrity,to help beginners understand and master the application methods and points for attention of reference integrity in database,and to provide reference for teachers'teaching and students'learning.
作者
徐博龙
Xu Bolong(Guangdong Engineering Polytechnic,Guangzhou Guangdong 510520,China)
出处
《信息与电脑》
2019年第3期167-168,共2页
Information & Computer
