Accounting Information Systems Chapter 3: Data Modeling

Accounting Information Systems Chapter 3: Data Modeling

1. User

   • IFAC and AICPA recommend all accountants develop proficiency as a user and at least one other type.

2. Manager

3. Designer

   • Business Process Documentation
     • BPI provides a starting point for business process improvement.
     • Activity
       • Activity models show the flow of work in a business process.
     • Structure
       • Structure models describe the information structure of one or more business processes. They support the design, implementation, and use of databases.
       • UML Class Model Building Blocks:
         • UML class models can be used to create tables by mapping classes to tables, mapping attributes to table fields, mapping associations to foreign keys depending upon the multiplicities of the association, and creating new tables to implement many-to-many relationships.
         • Classes
         • Attributes
           • Attributes for each class include the primary key, foreign key, and those that describe the characteristics of the class.
           • Foreign Key
             • FKs allow tables to be linked together and are the primary keys of other tables to allow linking.
           • Primary Key
             • PK define each instance of a class in a unique way.
         • Associations
         • Multiplicities

4. Evaluator

Images and files in the map

• Modeling Basics - Creating UML Class Models (Embed)
• Introduction to Accounting Information System (Embed)