Transcript Chapter 3 - McGraw Hill Higher Education - McGraw

Chapter 8
Integrated
Project
Copyright © 2014 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education.
Learning Objectives
• LO#1 Plan and manage a business analysis project
• LO#2 Develop an integrated UML Class Diagrams for a
business
• LO#3 Develop activity models of multiple business processes
and use those models to assess potential risks and
opportunities for process improvements
• LO#4 Use the UML Class Diagram to design and implement a
relational database system in Microsoft Access™
• LO#5 Employ the relational database to answer a variety of
business performance questions
8-2
LO# 1
Sy’s Fish Company
Sy’s Fish Company owns a chain of wholesale fish stores. The
company has grown rapidly over the last few years and now
operates eight different stores. The company is poised to
expand further, but first needs to develop a better accounting
information system. This project involves
1) a thorough analysis of Sy’s Fish Company business
processes to assess opportunities for improvement and
2) implementation of a prototype integrated database to
provide financial and management information.
The Sy’s Fish Project is based on a project developed by Bill McCarthy, Professor, Michigan State
University.
8-3
LO# 1
Sy’s Fish Company Overview
• You will focus on five processes
1.
2.
3.
4.
5.
Selling fish
Purchasing fish
Paying employees
Purchasing miscellaneous supplies and services
Providing refunds to customers
8-4
LO# 1
Sy’s Fish Company Information
• Summary of interviews with key employees
available separately
• EXCEL spreadsheet with all necessary data
available separately
• Sy’s Fish uses accrual accounting
• Sy’s Fish uses a calendar fiscal year
8-5
LO# 1
Suggested Project Steps
8-6
LO# 2, 3,
4, 5
Project Deliverables
• Project Plan
• Integrated UML Class Diagram encompassing the
five processes
• BPMN Activity Model for each of the five
processes
• Access database with all tables efficiently
organized, relationships set to match your UML
diagram, and referential integrity enforced
• Queries to address Sy’s requirements
• Report
8-7
Query Requirements
• Company income statement for 1st quarter
• Company balance sheet at the end of the 1st
quarter
• Stores’ income statements for 1st quarter
• Accounts receivable for each customer
(showing all customers)
• Each of these may require several queries, but
the final query in each set should show the
information required
8-8
LO# 2, 3,
4, 5
Report Requirements
• Financial performance evaluation for 1st quarter
• Risk assessment and recommendations for risk
management based on the BPMN activity
diagrams
• Assessment of potential benefits of the use of
information technology
– Refer to BPMN activity diagrams
– Consider costs and benefits
• Address report to Sy, CEO of Sy’s Fish Company
• Use executive summary style, including tables
and charts to summary relevant information
8-9
Good luck!
8-10