数据库系统基础教程Database-Systems-7.pptxVIP

Constraints and Triggers;A constraint is a expression or statement stored in the database. A constraint is an active(主动性) element, it execute when a certain event occurs or the database changes. SQL provides integrity（完整性） constraints: key, referential integrity, domain constraints, check constraints, assertions(断言). SQL provides trigger(触发器) which is a form of active element that is called into play on certain specified events.;Key is the most important kind of constraint. Each table may have several sets of attributes called candidate keys(候选键). Each table can have an unique primary key. I