Ais CH - 3, 2018
Ais CH - 3, 2018
Ais CH - 3, 2018
Chapter Three
System Development and Documentation Techniques
Documentation Tools and Techniques
Documentation encompasses the narratives, flowcharts, diagrams, and other written material that
explain how the system works. This information covers the; who, what, when, where, why, and
how data entry, processing, storage, information output and system controls. One popular means
of documenting a system is to develop diagrams, flowcharts, tables, and other graphical
representations of information. These are then supplemented by a narrative description of the
system, which is a written step-by-step explanation of system components and interactions. The
two most common tools of system documentation; dataflow diagrams and flowcharts will be
discussed in this part. These tools save the organization both time and money. Depending on the
job function being performed, documentation tools are important on one or more of the
following levels:
1. At minimum, documentation is read to determine how the system works.
2. Internal control documentations are evaluated to identify control strengths and
weaknesses and to recommend improvements.
3. The greatest amount of skill is needed to prepare documentation.
An understanding of documentation tools is required regardless of the type of accounting career
chosen. For example, auditors are required to understand the client's system of internal controls
before conducting an audit.
1
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
This object-orientation helps programmers avoid writing duplicate programs and facilities
changes when programs must be modified later.
Standardizing communications with others: Documentation techniques such as flowcharts and
data flow diagrams are standard industry tools, and they are more likely to be interpreted the
same way by all parties viewing them.
Auditing AISs: Documentation helps auditors determine the strengths and weaknesses of a
system’s controls.
Documenting business processes: By mapping the business processes, documentation helps
managers better understand the ways in which their businesses operate.
The basic documentation tools are:
1. Data flow diagram - a graphical description of the source and destination of data that
shows data flow within an organization, the processes performed on the data and how
data are stored.
2. Document flow chart - a graphical description of the flow of documents and information
between departments or areas of responsibility within an organization.
3. System flowchart - a graphical description of the relationship among the input,
processing, and output in an information system.
4. Program flowchart - a graphical description of the sequence of logical operations that a
computer performs as it executes a program.
These tools are used extensively in the system development process. Systems development is a
complex process and these tools are used to create order from chaos and complexity. In addition,
the team members who develop information systems projects often change and these
documentation tools help the new team members get up to speed quickly. Both DFDs and
flowcharts are easy to prepare and revise when one of the recently developed DFDs or
flowcharting software packages is used. They are easier to use than most word processors. Once
a few basic commands are mastered, users can quickly and easily prepare, store, revise, and print
presentation quality DFDs or flowcharts.
2
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
3
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Process
DataStores
Source/Destination
Entity
DataFlow
Demarco & Yourdon Gane & Sarson
Symbols Symbols
These four symbols are combined to show how data are processed. For example, in the diagram
below, the input to process C is data flow B, which comes from data source A. The outputs of
process C are data flows D and E. Data flow E is sent to data destination F.
diagram below consists of two parts: a payment and remittance data. Process (process
payment) splits these two data elements and sends them in different directions. The
remittance data (D) flows to another process, where it is used to update accounts
receivable records, and the payment (E) is sent to the bank with a deposit slip. Because
data flows may consist of more than one data element, the designer must determine the
number of lines to show. For example; customers may send inquiries about the
processing of their payments with payments or separately.
A transformation process represents the transformations of data. The diagram below
shows that process payment (C) takes customer payment and splits into the remittance
data and the deposit (which includes the checks and deposit slip created within process
payment). The updating receivables (F) process takes the remittance data (D) and the
accounts receivables (F) data, producing updated receivables record and sending
receivables information to the credit manager.
A data store is a temporary or permanent repository of data. DFDs do not show the
physical storage medium such as disks, and paper, used to store data. As with other DFD
elements, data store names should be descriptive. Data stores are represented by
horizontal lines, with respective name recorded inside.
A data dictionary contains description of all the elements, stores, and flows in a system.
Data flows and data stores are typically collections of data elements. Typically, a master
copy of the data dictionary is maintained to ensure consistency and accuracy throughout
the development process.
6
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
7
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
13. Clearly labeling the pages 1 of 3, 2 of 3 etc if a flowchart cannot fit into a single page.
14. Showing documents or reports first in the column in which they are created and then
moving to another column for further processing. A manual process is not needed to
show documents being flowcharted.
15. Showing all data entered into or retrieved from a computer file as passing through a
processing operation (a computer program) first.
16. Drawing a line from the document to a file to indicate that it is being filed. A manual
process is not needed to show a document entering a file.
17. Drawing a rough sketch of the flowchart as a first effort. Concern shall be with capturing
content than perfect drawing. Few systems can be flowcharted in a single draft.
18. Redesigning the flowchart to avoid clutter and a large number of crossed lines.
19. Verifying the flowchart's accuracy by reviewing it with the people familiar with the
system. It shall be assured that all uses of flowchart conventions are consistent.
20. Drawing the final copy of the flowchart, placing the name of the flowchart, the date, and
the preparer's name on each page.
Flowchart Symbols
There are various types of symbols used to create flowcharts. Each symbol has a special meaning
that is easily conveyed by its shape. The shape indicates and describes the operation performed
and the input, processing, output, and storage media employed. The symbols are drawn by a
software program or with a flowcharting template. Flowcharting symbols can be divided into the
following four categories:
1. Input/output symbols - represent devices or media that provide input to or record output
from processing operations.
2. Processing symbols - either show what type of device is used to process data or indicate
when processing is completed manually.
3. Storage symbols - represent the device used to store data that the system is not currently
using.
4. Flow and miscellaneous symbols - indicate the flow of data and goods. They also
represent such operations as where flowcharts begin and end, where decisions are made,
and when to add explanatory notes to flowcharts.
9
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Flowchart Symbols:
Document
Online keying
Display
Input/output; journal/ledger
Magnetic disk
Magnetic tape
Off-page connector
Computer processing
Terminal
Decision
Auxiliary operation
Document Flowcharts
A document flowchart illustrates the flow of documents and information among areas of
responsibility within an organization. They trace a document from its cradle to its grave. They
show where a document originates, its distribution, the purpose for which it is used, its ultimate
disposition, and everything that happens as it flows through the system. A document flowchart is
particularly useful in analyzing the adequacy of control procedures in a system, such as internal
checks and segregation of duties. Flowcharts that describe and evaluate internal controls are
often referred to as internal control flowcharts. The document flowchart can reveal weaknesses
or inefficiencies in a system such as inadequate communication flows, unnecessary complexity
in document flows, or procedures responsible for causing wasteful delays. They also can be
prepared as part of the system design process and should be included in the documentation of an
information system.
Following is a typical example of how a document flowchart can be designed:
Major flowchart symbols are available from EXCEL. To view the Drawing Toolbar of MS10
EXCEL, select the following options from the main menu: In EXCEL,
“Insert/Toolbar/Drawing” or you can also click directly on the Drawing icon in the
Standard Toolbar. After the Drawing Toolbar appears, select “Auto shapes/Flowchart”.
You can observe approximately 28 symbols.
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
System Flowcharts
System flowcharts depict the relationship among the input, processing, and output of AIS. A
system flowchart begins by identifying both the inputs that enter the system and their origins.
The input is followed by the processing portion of the flowchart. The input is followed by
processing portion of the flowchart that is the steps performed on the data. The logic the
11
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
computer uses to perform the processing task is shown on a program flowchart. The resulting
new information is the output component, which can be stored for later use, displayed on a
screen, or printed on paper. In many instances, the output from one process is an input to
another. System flowcharts are an important systems analysis, design, and evaluation tool. They
are universally employed in systems work and provide an immediate form of communication
among workers. The system flowchart is an excellent vehicle for describing information flows
and procedures within AIS.
Program Flowcharts
A program flowchart illustrates the sequence of logical operations performed by a computer in
executing a program. It describes the specific logic to perform a process shown on a systems
flowchart. A flow line connects the symbols and indicates the sequence of operations. The
processing symbol represents a data movement or arithmetic calculation. Once designed and
approved, the program flowchart serves as the blueprint for coding the computer program.
12
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Enter
Start sales
Input order
Reject
Approved No
Order
for credit?
Storage Yes
Process No
Back-
Inventory Order
available?
Yes
13
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
14
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
15
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
methodology is a very formal and precise system development process that defines a set of
activities, methods, best practices, deliverables, and automated tools that system developers and
project managers are to use to develop and maintain information systems and software.
Frequently, several models are combined into some sort of hybrid methodology. Documentation
is crucial regardless of the type of model chosen or devised for any application, and is usually
done in parallel with the development process. Some methods work better for specific types of
projects, but in the final analysis, the most important factor for the success of a project may be
how closely the particular plan was followed. In general, an SDLC methodology follows the
following steps:
1. The existing system is evaluated - deficiencies are identified. This can be done by
interviewing users of the system and consulting with support personnel.
2. The new system requirements are defined - in particular, the deficiencies in the existing
system must be addressed with specific proposals for improvement.
3. The proposed system is designed - plans are laid out concerning the physical
construction, hardware, operating systems, programming, communications, and security
issues.
4. The new system is developed - the new components and programs must be obtained and
installed. Users of the system must be trained in its use, and all aspects of performance
must be tested. If necessary, adjustments must be made at this stage.
5. The system is put into use - this can be done in various ways. The new system can
phased in, according to application or location, and the old system gradually replaced. In
some cases, it may be more cost-effective to shut down the old system and implement the
new system all at once.
6. Once the new system is up and running for a while, it should be exhaustively evaluated.
Maintenance must be kept up rigorously at all times. Users of the system should be kept
up-to-date concerning the latest modifications and procedures.
16
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Romney and Steinhart identified the following five as the components of SDLC.
1. Systems analysis 4. Implementation and conversion
2. Conceptual design 5. Operations and maintenance
3. Physical design
Systems analysis is the first step in SDLC where in-depth understanding about a system starts. At
this stage, the information needed to purchase or develop a new system is gathered. Since
analysis is too costly (in terms of time, effort, money, etc), it is mostly started after the project is
approved and green light is obtained from the management. When a new or improved system is
needed, a written request for systems development is prepared. The request describes the current
system’s problems, why the change is needed, and the proposed system’s goals and objectives. It
also describes the anticipated benefits and costs.
System analysis is the stage of:
- Studying the current business system
- Understanding how the existing system works
- Determining the weakness and strength of the existing system
17
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
- Defining the business needs and requirements (user requirement determination and
system requirement determination independent of technology issues), et
Systems survey - at this stage, an extensive study of the current AIS is undertaken. It may
take weeks or months depending on the complexity and the scope of the system. The
objectives of a system survey include:
– Gain a thorough understanding of the company operations, policies, and procedures; data and
information flows; AIS strengths and weaknesses; and available hardware, software, and
personnel.
– Make preliminary assessment of current and future processing needs, and determine the
extent and nature of the changes needed.
– Develop working relationships with users and build support for the AIS
– Collect data that identify user needs, conduct a feasibility analysis and make
recommendations to management.
Finally, the findings are documented, the existing system is modeled and analyzed and a survey
report is prepared.
Feasibility study - a more thorough feasibility analysis is conducted to determine the project's
viability. Especially important is economic feasibility. The feasibility analysis is updated as the
project proceeds and costs and benefits become clearer.
18
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Information needs and systems requirements - once a project is deemed to be feasible, the
company identifies the information needs of the AIS users and documents system requirements.
the strategies for determining requirements include the following:
Ask users what they need; Analyze existing system; Examine existing system
use; & Create a prototype
Systems analysis report - is the conclusion of the system analysis phase. It is used to summarize
and document the analysis activities and serve as a repository of data from which system
designers can draw. A go-no-go decision is generally made three times during system analysis:
During the initial investigation - to determine whether to conduct a feasibility
survey
At the end of the feasibility study - whether to proceed to the information
requirements phase
At the completions of the analysis phase - to decide whether to proceed to the
next phase.
System Design: System design is the evaluation of alternative solutions and the specification
and construction of a detailed computer based solution. It is also called physical design as it
deals with implementation issues. Systems analysis depends more on the logical aspect,
implementation-independent aspects of a system /the requirements. Systems design
concentrates on the physical or implementation-dependent aspects of a system (the systems
technical specifications).
19
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Conceptual Design
Identify and evaluate
design alternatives
Develop design specifications Physical
Design
Deliver conceptual design
requirements
The system analysis phase is related to the conceptual design phase based on the diagram shown
below:
Systems
analysis
Prepare
Evaluate Prepare
conceptual
design design
systems
alternatives specifications
design report
©2003 Prentice Hall Business Publishing, 18-10
Accounting Information Systems, 9/e, Romney/Steinbart
20
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Once a design alternative has been selected, the team develops the conceptual design
specifications for the following elements: Input, Data storage, Processing procedures and
operations, and Outputs.
Prepare conceptual systems design report:
At the end of the conceptual design a conceptual systems design report is developed and
submitted.
1. To guide physical systems design activities
2. To communicate how management and user information needs will be met
3. To help assess systems’ feasibility
Physical design
The above activities will come as a series of steps as shown by the diagram below:
Output Program
design design
Input Controls
design design
©2003 Prentice Hall Business Publishing, 18-16
Accounting Information Systems, 9/e, Romney/Steinbart
21
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Conceptual Physical
systems design systems design
Physical Systems Design: File and Database Design, Input Design, Procedures Design, and
Control Design
What are some control design considerations?
Validity Authorization Audit Control
Accuracy Security
Numerical Control Availability
Maintainability Integrity
22
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
The relationship of the items in this phase and the conversion process (next phase) will be as
shown below in a series of activities.
Systems Implementation
Implementation planning
Conversion
©2003 Prentice Hall Business Publishing, 18-27
Accounting Information Systems, 9/e, Romney/Steinbart
23
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
25
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
Feasibility Analysis
Systems analysis is the first step in the systems development life cycle (SDLC).
A feasibility study (also called a business case) is prepared during systems analysis and
updated as necessary during the remaining steps in the SDLC.
The steering committee uses the study to decide whether to terminate a project, proceed
unconditionally, or proceed conditionally.
What five important aspects need to be considered during a feasibility study?
Technical feasibility
Operational feasibility
Legal feasibility
Scheduling feasibility
Economic feasibility
Economic feasibility is the most frequently analyzed of the five aspects.
What is the basic framework for feasibility analysis?
capital budgeting model
What are some capital budgeting techniques?
Payback period
Net present value (NPV)
Internal rate of return (IRR)
Behavioral Aspects of Change
Individuals involved in systems development are agents of change who are continually
confronted by people’s reaction and resistance to change.
The best system will fail without the support of the people it serves.
Why do behavioral problems occur?
personal characteristics and background
manner in which change is introduced
experience with prior changes
communication
disruptive nature of the change process
fear
26
ACCOUNTING INFORMATION SYSTEM_DU HAND OUT_ABEL D.
27