سیستم پشتیبانی طراحی کنترل EDI با استفاده از سیستم پایگاه داده رابطه ای

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.