A one-to-one model for audit trails construction in database design

Tian-Lih Koo, Ming-Hsien Yang and Hsin-Tsu Liu

International Journal of Business and Systems Research, 2013, vol. 7, issue 1, 61-80

Abstract: The clear and complete audit trails of a transaction system are important to auditing, management and control. In the environment of manual operation, the data created during the transaction process are all written down on papers and account books; in other words, the audit trails are composed of a group of reference codes on the original documents. Hence, all the processing trails are visible and checkable. However, after the data processing environment has been changed from manual operation to computerised operation, the audit trails have become not only invisible due to the electronic data, but also ambiguous due to the special characteristics of database design principles. This paper found that the characteristics of database would be affected by 'control constructs' and their 'one to one' manipulated values of the data model, and then presents a OTO model. Finally, a simple simulated case is prepared for illustration of the OTO model.

Keywords: one-to-one models; audit trails; database design; database characteristics; E-R model; entity-relationship model; transaction systems; auditing; management; manual operations; data creation; transaction processes; account books; written transactions; reference codes; original documents; processing trails; visible trails; checkable trails; data processing; computerised operations; invisible trails; electronic data; ambiguous trails; special characteristics; control constructs; manipulated values; data models; business; systems research. (search for similar items in EconPapers)
Date: 2013
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=50621 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijbsre:v:7:y:2013:i:1:p:61-80

Access Statistics for this article

More articles in International Journal of Business and Systems Research from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().