The Conformance Analysis for System Process and Database Design

Autor: CHIH-CHI LI, 李智琦
Rok vydání: 2012
Druh dokumentu: 學位論文 ; thesis
Popis: 100
This Information technology is growing nowadys, there are more and more companies start using a highly integrated information systems, Also, they put emphasize on business workflow technology. Database plays a very important role in the stage of system analysis and design.The poor database would not consistent with the business process. Moreover, it would cause information security issues.Recent years, there are more and more computer fraud criminal cases; however, we are focus on the post-audit, Post-audit are often already the loss of opportunities. In the conclustion, if we can detect the problem early and provide assessment of the enterprises on the control, company would reduce the potential risks.For this reason, the study proposes Data Access Audit Rule, and use Relational Database as the base to analyze the existing Schema and Programming. We will use PK, FK, Null, Weak Entity, Integrity Constraints, Cardinality, Trigger and Stored Procedure to follow the procedure and Data Access Audit Rule.By using Data Access Audit Rule to build up the mechanism, we would make comparison between corporation data access processes and data comes from EPC which extract from corporation’s standard operation procedure. After the comparison, we can make the conclusion to the structure of enterprise database design, and see if they are match the standard operation procedure. In the conclusion, we can provide the improvement for information security and achieve the Pre-Audit and Post-Audit.
Databáze: Networked Digital Library of Theses & Dissertations
načítá se...