EDI controls design support system using relational database system

Cited 2 time in webofscience Cited 4 time in scopus
  • Hit : 865
  • Download : 68
The purpose of this paper is to introduce EDIRDB (EDI controls design support system using a relational database system), a prototype audit support system based on a relational database designed to act as a decision aid for EDI auditors. This paper describes how EDIRDB operates; explicates the manner in which a relational database is utilized to support the design of EDI controls; suggests relevant risks resulting from the absence of some controls; and suggests test results. The system recommends effective controls and shows relevant risks in a specific organizational context, suggesting test procedures for that particular company. The EDIRDB database consists of nine tables: (1) four tables from the entities ENVIRONMENTS, CONTROLS, RISKS, and TESTS, and (2) five tables corresponding to the relations between each of the four entities. An E-R (Entity-Relationship) diagram along with a data flow diagram are drawn to show the system's design. Relevant controls, risks, and test procedures along with their results can be stored for each individual company. Managers can suggest required controls, relevant risks, and test procedures from results coming through cross referencing (e.g., JOIN, PROJECTION, and SELECT commands) between the nine base tables. This system improves the efficiency and effectiveness of EDI auditing and may also be applied to general IS auditing. (C) 2000 Elsevier Science B.V. All rights reserved.
Publisher
ELSEVIER SCIENCE BV
Issue Date
2000
Language
English
Article Type
Article
Citation

DECISION SUPPORT SYSTEMS, v.29, no.2, pp.169 - 193

ISSN
0167-9236
DOI
10.1016/S0167-9236(00)00071-3
URI
http://hdl.handle.net/10203/3710
Appears in Collection
MT-Journal Papers(저널논문)
Files in This Item
This item is cited by other documents in WoS
⊙ Detail Information in WoSⓡ Click to see webofscience_button
⊙ Cited 2 items in WoS Click to see citing articles in records_button

qr_code

  • mendeley

    citeulike


rss_1.0 rss_2.0 atom_1.0