Design of Trigger of Foreign Language Audiovisual Products Accounting System

DOI

10.2991/ameii-15.2015.74How to use a DOI?

Keywords

audiovisual products; accounting system; trigger; design

Abstract

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.

Copyright

© 2015, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Xuefeng Liu
PY  - 2015/04
DA  - 2015/04
TI  - Design of Trigger of Foreign Language Audiovisual Products Accounting System
BT  - Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics
PB  - Atlantis Press
SP  - 394
EP  - 397
SN  - 2352-5401
UR  - https://doi.org/10.2991/ameii-15.2015.74
DO  - 10.2991/ameii-15.2015.74
ID  - Liu2015/04
ER  -