The trigger is a special kind of storing procedure. The system will automatically perform certain SQL statements defined inside the trigger when carrying out some particular T-SQL statements, thus ensuring data security and integrity. The appropriate definition of the trigger helps to improve the security of the book database and alleviate the running burden of the library management system.