Abstract:

Insering data, deleting data and modifying data are very frequent in the process of data processing. A trigger is designed rationally to protect data in tables, and the integrity of data is ensured by preventing non-authorized or nonuniformed modification. A way of data flow chart is adopted, and the  design of the trigger is given by a concrete development example.

Key words: database integrity triggerdata flow chart;T-SQL language