数据库课程ch6 完整性和安全性.pptVIP

Chapter 6: Integrity and Security Domain Constraints Referential Integrity Assertions断言 Triggers Security Authorization Authorization in SQL Domain Constraints Integrity constraints guard against accidental damage to the database, by ensuring that authorized changes to the database do not result in a loss of data consistency. Domain constraints are the most elementary form of integrity constraint. They test values inserted in the database, and test queries to ensure that the comparisons make sense. New domains can be created from existing data types E.g. create domain Dollars numeric(12