Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics

Design of Trigger of Foreign Language Audiovisual Products Accounting System

Authors
Xuefeng Liu
Corresponding Author
Xuefeng Liu
Available Online April 2015.
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)

Volume Title
Proceedings of the International Conference on Advances in Mechanical Engineering and Industrial Informatics
Series
Advances in Engineering Research
Publication Date
April 2015
ISBN
10.2991/ameii-15.2015.74
ISSN
2352-5401
DOI
10.2991/ameii-15.2015.74How to use a DOI?
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/).

Cite this article

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  -