Welcome to the InfoSci Platform
A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design

A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design

Jason Chen, Ming-Hsien Yang, Tian-Lih Koo
Copyright: © 2014 |Volume: 4 |Issue: 2 |Pages: 17
ISSN: 2155-6393|EISSN: 2155-6407|EISBN13: 9781466655348|DOI: 10.4018/ijkbo.2014040102
Cite Article Cite Article

MLA

Chen, Jason, et al. "A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design." IJKBO vol.4, no.2 2014: pp.20-36. http://doi.org/10.4018/ijkbo.2014040102

APA

Chen, J., Yang, M., & Koo, T. (2014). A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design. International Journal of Knowledge-Based Organizations (IJKBO), 4(2), 20-36. http://doi.org/10.4018/ijkbo.2014040102

Chicago

Chen, Jason, Ming-Hsien Yang, and Tian-Lih Koo. "A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design," International Journal of Knowledge-Based Organizations (IJKBO) 4, no.2: 20-36. http://doi.org/10.4018/ijkbo.2014040102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

The internal controls construction of a transaction system is important to management, operation and auditing. In the environment of manual operation, the internal controls of the transaction process are all done by manual mechanism. However, after the transaction processing environment has been changed from manual operation to computerized operation, the internal control techniques have been gradually transformed from manual mechanisms to computerized methods. The essence of internal controls in operational activities is the data expressions or constraints. The adoption of information systems often results in internal control deficiencies and operating risks due to the data unavailable in database for the data expressions of internal controls. Hence, how to design database schema to support internal controls mechanism is becoming a crucial issue for a computerized enterprise. Therefore, this paper referred Entity-Relationship model (ER model) in order to propose a Control-Data-Mapping Entity-relationship (CDMER) model by manipulating the required fields of tables to design database to support internal controls construction. Finally, a simple simulated case is prepared for illustration of the CDMER model. The contribution of this paper is to enhance the reliability of information systems through internal controls construction by applying the model to design databases.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.