Design of Trigger of Foreign Language Audiovisual Products Accounting System

摘要

Referential integrity refers to data integrity between two tables, in the process of software development, if cannot ensure referential integrity, will result in disastrous consequences for data. In this paper, based SQL Server database management system designed on the trigger of audiovisual product accounting system, in order to ensure data integrity and provide scientific solutions. Firstly, research the working principle of "INSERT, DELETE, UPDATE" three types of triggers; then, the database structure design, including conceptual structure design and logical structure design; and finally, for audiovisual product accounting system "Account head table" and the "Account detail table "designed three triggers. Contents of this paper, to improve development efficiency of audiovisual product accounting system, to ensure data integrity, and so has an important role.