 |
|
Each group will complete a project
case study based on a fictitious business. A document describing
this business, Sheldon Shirts,
can be downloaded from here.
|
The project will be completed in six
stages and a final report as follows:
|
| |
Due dates
|
|
| 1 |
October 15 |
Document the existing information system for
the purchases, conversion (i.e., production), revenue, payroll
and general ledger processes using flowcharts.
|
| |
| 2 |
October 22 |
Design event-oriented (R.E.A.) models for the
business processes - Part1- EER diagram.
|
| |
|
This stage will involve the first six steps in the REA process
discussed in Chapter 8 of our textbook.
A WORD document to help you
organize your solution to Stages 2 - 4 of the project may be
downloaded from here.
(In addition, a list of the necessary Tables is required -
thinking about this will help you prepare for the next Stage).
|
| |
| 3 |
October 29 |
Design event-oriented (R.E.A.) models for the
business processes - Part 2 - DFDs.
|
| |
|
Step seven of the REA process described in
Chapter 8 of the textbook will be completed at this stage,
concluding the logical design of the system. This year we will
do this only for the Materials Acquisition and Sales cycles.
|
|
| 4 |
November 5 |
Design event-oriented (R.E.A.) models for the
business processes - Part 3 - Data Repository Structure.
|
| |
|
Step eight of the REA process described in Chapter 8 of the
textbook will be completed at this stage, concluding the
physical design of the system.
|
| |
| 5 |
November 12 |
Document the existing internal control
structure for the client, and recommend additional desirable
controls.
|
| |
|
The main issues to be explored in this stage of the project
will be covered in Chapter 10 of our textbook. The format of the
documentation of controls will be discussed in class. In brief,
you will be asked to list the controls you intend to implement
in the Materials Acquisition and Sales cycles, classify them in
accordance with various categories, and explain their purpose.
|
| |
| 6a |
December 3 |
Implement your event-oriented information
system using Microsoft ACCESS and enter fictitious data to as to
be able to generate the various reports: Tables and Forms. This
year the minimum requirement is to complete the Sales cycle.
|
| |
| 6b |
December 10 |
Implement your event-oriented information
system using Microsoft ACCESS and enter fictitious data to as to
be able to generate the various reports: Reports. This year the
minimum requirement is to complete the Sales cycle.
|
|
| 7 |
December 12 |
Complete any necessary reworking of the
project and produce the final report.
|
| |
The final report for the completed
project including all phases is due by the beginning of class on
December 12. You will need to describe remaining work that would
be necessary to implement the re-designed system for use in the
business, conclude as to the advantages and disadvantages of
potentially adopting your revised system, and report on the
lessons learned by group members during the course of the
project. Handwritten materials will not be accepted or graded
for any of the project stages. Text must be produced using a
word processor, and other forms of documentation (tables,
flowcharts, diagrams, etc.) must be produced using appropriate
software tools.
|
| |
|