AFM341 Chapter Notes - Chapter 6: Referential Integrity, Business Process Model And Notation, Foreign Key

• School: University of Waterloo
• Department: Accounting & Financial Management
• Course: AFM341
• Professor: Jee Hae Lim

Document Summary

Bpmn: basic only shows start/end, activities and sequence flows: segregation of duties (minimum swim lanes, custodial, recording, approval. Refinement of bpmn: can add sub-process, gateway: decision tree. Attributes: yes you can recognize primary and foreign key as attributes: can"t show many to many relationship with er (have to make linking table/ junction/ association table with 2 primary and 2 foreign keys) Supplier table maintenance: data entry screen and record layout. ): limited to the authorized people by password - logical access control: using supplier file maintenance to control execution risk, unauthorized goods or services received: purchase was from wrong supplier, wrong quantity, quality, or price, recommendation (rec. ): standard procedures should be established for approcing supliers and monitoring their perfromance: controls over supplier maintenance, recommendation (rec. ): the most important control for accuracy is a careful comparison of the data entered in the screen with the original source of the information (reduce duplications)