{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:40:21Z","timestamp":1654116021393},"reference-count":27,"publisher":"IGI Global","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2014,4,1]]},"abstract":"<p>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.<\/p>","DOI":"10.4018\/ijkbo.2014040102","type":"journal-article","created":{"date-parts":[[2014,9,24]],"date-time":"2014-09-24T15:47:39Z","timestamp":1411573659000},"page":"20-36","source":"Crossref","is-referenced-by-count":0,"title":["A Control-Data-Mapping Entity-Relationship Model for Internal Controls Construction in Database Design"],"prefix":"10.4018","volume":"4","author":[{"given":"Jason","family":"Chen","sequence":"first","affiliation":[{"name":"School of Business, Gonzaga University, Spokane, WA, USA"}]},{"given":"Ming-Hsien","family":"Yang","sequence":"additional","affiliation":[{"name":"School of Management, Department of Information Management, Fu Jen Catholic University, New Taipei City, Taiwan"}]},{"given":"Tian-Lih","family":"Koo","sequence":"additional","affiliation":[{"name":"School of Management, Department of Accounting, Shih Chien University, Taipei, Taiwan"}]}],"member":"2432","reference":[{"key":"ijkbo.2014040102-0","doi-asserted-by":"publisher","DOI":"10.1016\/j.jacceco.2006.10.001"},{"issue":"1","key":"ijkbo.2014040102-1","first-page":"186","article-title":"TICOM and the analysis of internal controls.","volume":"35","author":"A. D.Bailey","year":"1985","journal-title":"Accounting Review"},{"issue":"6","key":"ijkbo.2014040102-2","first-page":"1787","article-title":"Four (or five) easy lessons from Enron.","volume":"55","author":"D. G.Baird","year":"2002","journal-title":"Vanderbilt Law Review"},{"issue":"1","key":"ijkbo.2014040102-3","first-page":"91","article-title":"Shaping decisions with system analysis.","volume":"54","author":"G. A. W.Boehm","year":"1976","journal-title":"Harvard Business Review"},{"key":"ijkbo.2014040102-4","doi-asserted-by":"publisher","DOI":"10.1145\/320434.320440"},{"issue":"2","key":"ijkbo.2014040102-5","first-page":"267","article-title":"The appeal and limits of internal controls to fight fraud, terrorism, other ills.","volume":"29","author":"L. A.Cunningham","year":"2004","journal-title":"The Journal of Corporation Law"},{"key":"ijkbo.2014040102-6","unstructured":"Davis, G. B., & Weber, R. (1986). The impact of advanced computer systems on controls and audit procedures: A theory and an empirical test. Auditing: A Journal of Practice & Theory, 5(2), 35-49."},{"issue":"2","key":"ijkbo.2014040102-7","first-page":"70","article-title":"Effect of internal controls in data base design.","volume":"3","author":"E. A.Doty","year":"1989","journal-title":"Journal of Information Systems"},{"key":"ijkbo.2014040102-8","author":"U. J.Gelinas","year":"1999","journal-title":"Accounting information systems"},{"issue":"5","key":"ijkbo.2014040102-9","first-page":"146","article-title":"Reengineering controls.","volume":"52","author":"J.Gibbs","year":"1995","journal-title":"Internal Auditor"},{"key":"ijkbo.2014040102-10","doi-asserted-by":"publisher","DOI":"10.1108\/02686900810899536"},{"key":"ijkbo.2014040102-11","doi-asserted-by":"publisher","DOI":"10.1145\/203241.203265"},{"key":"ijkbo.2014040102-12","doi-asserted-by":"publisher","DOI":"10.1002\/isaf.249"},{"issue":"1","key":"ijkbo.2014040102-13","first-page":"19","article-title":"An IT assurance framework for the future.","volume":"60","author":"J. W.Lainhart","year":"2001","journal-title":"The Ohio CPA Journal"},{"issue":"1","key":"ijkbo.2014040102-14","first-page":"114","article-title":"The organizational contexts, controls and implementation of e-business.","volume":"51","author":"S.Lee","year":"2010","journal-title":"Journal of Computer Information Systems"},{"key":"ijkbo.2014040102-15","doi-asserted-by":"publisher","DOI":"10.1016\/j.jacceco.2007.01.002"},{"key":"ijkbo.2014040102-16","doi-asserted-by":"publisher","DOI":"10.1016\/S0272-6963(02)00071-2"},{"issue":"3","key":"ijkbo.2014040102-17","first-page":"667","article-title":"An entity-relationship view of accounting models.","volume":"60","author":"W. E.McCarthy","year":"1979","journal-title":"Accounting Review"},{"issue":"3","key":"ijkbo.2014040102-18","first-page":"554","article-title":"The REA accounting model: A generalized framework for accounting systems in a shared data environment.","volume":"63","author":"W. E.McCarthy","year":"1982","journal-title":"Accounting Review"},{"issue":"3","key":"ijkbo.2014040102-19","first-page":"712","article-title":"A framework for integrating Sarbanes-Oxley compliance into the systems development process.","volume":"20","author":"S.Mishra","year":"2007","journal-title":"Communications of the Association for Information Systems"},{"key":"ijkbo.2014040102-20","doi-asserted-by":"publisher","DOI":"10.1108\/02686900810839820"},{"key":"ijkbo.2014040102-21","author":"M. B.Romney","year":"2009","journal-title":"Accounting information systems"},{"issue":"2","key":"ijkbo.2014040102-22","first-page":"56","article-title":"Business risk, internal control and audit implications of EDI.","volume":"65","author":"W.Stanley","year":"1995","journal-title":"The CPA Journal"},{"issue":"1","key":"ijkbo.2014040102-23","first-page":"61","article-title":"Internal control re-design: An exploratory study of Australian organizations. Accounting","volume":"8","author":"C.Stringer","year":"2002","journal-title":"Accountability & Performance"},{"key":"ijkbo.2014040102-24","doi-asserted-by":"publisher","DOI":"10.4018\/jisss.2009070102"},{"key":"ijkbo.2014040102-25","doi-asserted-by":"publisher","DOI":"10.4018\/ijkbo.2011040101"},{"issue":"2","key":"ijkbo.2014040102-26","first-page":"311","article-title":"Audit system support in advanced computer-based accounting systems.","volume":"17","author":"R.Weber","year":"1982","journal-title":"Accounting Review"}],"container-title":["International Journal of Knowledge-Based Organizations"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=115564","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:03:03Z","timestamp":1654113783000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijkbo.2014040102"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2014,4,1]]},"references-count":27,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2014,4]]}},"URL":"https:\/\/doi.org\/10.4018\/ijkbo.2014040102","relation":{},"ISSN":["2155-6393","2155-6407"],"issn-type":[{"value":"2155-6393","type":"print"},{"value":"2155-6407","type":"electronic"}],"subject":[],"published":{"date-parts":[[2014,4,1]]}}}