ACG 3401 Lecture Notes - Lecture 1: Supplier Relationship Management, Financial Statement, Balanced Scorecard
Document Summary
Why use ais: users, system designers(consulting, auditing. Sarbox requires internal control report with financial statements. Operations: business and day to day transactions (transaction processing. Compared to today, all databases are integrated into one giant database instead of just several individual one. This makes things much more streamlined and uniform and easier to spot issues and problems. Granularity (audit trail and meta-data) road map that displays how each transaction relates to one another. Customer orders, shipping, billing, and audit trail on sales transactions. Purchase orders, receiving, invoice payments, and material requirement planning. General ledger, financial statements, and ap and ar sub ledgers. Cost center and profitability analysis, budgeting, and variance analysis. Logical data structures: tree or hierarchal, network structures, relational structures: logical data structure that views the database as a collection of two dimensional tables. There are no complicated pointers: object oriented structures. Can only represent one to may or one to one relationship.