ACCT project
Integrated Project
Guide
1
Project Goals
Plan and manage a business analysis project
Develop activity models of multiple business processes and use those models to assess potential risks and opportunities for process improvements
Develop an integrated UML Class Diagrams for a business
Use the UML Class Diagram to design and implement a relational database system in Microsoft Access™
Employ the relational database to answer a variety of business performance questions
Use the BPMN diagrams and business requirements to assess new process after Z CHEDDR implements a new integrated system.
Determine appropriate controls/cybersecurity controls for the new system
8-2
Suggested Project Steps
8-3
Defining Business Requirements
4
Use BPMN pools to establish the context.
Preparing Activity Models using BPMN
5
Step 1: Establish the basic activities for each process.
Preparing Activity Models using BPMN
6
Step 2: Establish who is responsible for each activity and what data objects are created and used.
Preparing Activity Models using BPMN
7
Step 3: Allow for errors and exceptions in the process.
Prepare Structure (UML Class) Diagram
8
Example UML Diagram
Prepare Data Dictionary and Import Data into Access
9
Correct any data redundancies and occasional typographical errors.
Split inefficient tables into multiple tables, e.g., sales information might involve the sales event and the sales items information.
Set appropriate primary keys and verify data types.
Form relationships to look like your UML class diagram to the extent possible.
Prepare Queries
10
Ensure data is limited to the period of interest.
1
Summarize by store/location for income statement elements before forming an overall income statement.
2
Develop balance sheet amounts.
3
Develop other performance measures as appropriate.
4
Complete Other Parts
Prepare actual financial statements using query data
Describe Z Cheddr financial performance for 1st quarter
Determine changes to processes after IT implementation
Develop internal control recommendations
Package Your Report
Chedd r
Prepare
Project Plan
Determine
Requirements
Prepare
Activity
Diagrams
Prepare
Structure
Diagrams
Import Data
into Access
Create Tables
and Establish
Relations
Prepare
Queries
Prepare
Report
Customers
Record
Order
Prepare
Delivery
Deliver
Products
Receive
Payment
C/R
Product
Sales & Invoice
Orders
Customers
Your
Company
Ship &
Receive
Acct
Record
Order
Prepare
Delivery
Deliver
Products
Receive
Payment
Order
Inv
De-
posit
Inv
C/R
Product
Sales & Invoice
Orders
Customers
Your
Company
Ship &
Receive
Acct
Record
Order
Prepare
Delivery
Deliver
Products
Receive
Payment
Order
Inv
De-
posit
Inv
C/R
Product
Sales & Invoice
Orders
Cancel
Order
Order
Sales
C/R
Purchases of
Inventory
C/D
Purchases
Admin
C/D
Timecards
Payroll
Employees
Customers
Misc Vendors
Vendors
Cash
Inventory
p
tax payment
0..1
0..1
1..1
1..1
1..1
1..11..11..11..1
1..1
1..1
1..1
1..1
1..1
1..1
1..*
1..1
1..1
1..1
1..1
1..1
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
0..*
1..1
pay
receive
0..*
0..*
0..*
0..*
0..*
0..*
0..*
1..*
1..*
1..1
0..1
0..1
0..*